With the database window open, click the Queries tab, highlight the Query,
and click the Design button -- that screen is Query Builder. In (design
view in) Query Builder, there should be a toolbar just above the design
grid, and by default, the leftmost button will allow you to go from Design
View (a "tool" icon) to Query View (a datasheet icon) to SQL View (the
letters SQL). Some later versions (Access 2002 and 2003) also have Pivot
Chart and Pivot Table view in the dropdown, but I can't remember if Access
2000 has those or not -- but they are not pertinent to our discussion.
In SQL View, you can highlight and copy (Ctrl-C) the SQL and paste it into
a
post... if you do that for both the Query that gives you all the records
and
the Query that gives you fewer, then someone can take a look -- it may not
be me, as I don't have Access 2000 installed on an active PC.
I don't know what you are experiencing about "browser" because there's no
web browser involved with a normal Access MDB.
<rfdjr1@[EMAIL PROTECTED]
> wrote in message
news:qjhh2498rk018foscf2ao6pr2svar36moq@[EMAIL PROTECTED]
> On Mon, 12 May 2008 21:02:14 GMT, "Larry Linson" <bouncer@[EMAIL PROTECTED]
>
> wrote:
>
>>
>><rfdjr1@[EMAIL PROTECTED]
> wrote in message
>>news:krah24lbrfi0mo2dj65agmg0s334eps6pm@[EMAIL PROTECTED]
>>> I'm using Access 2000. I have a raher simple database of my CD
>>> collection,
>>> with
>>> just three fields, Artist, Album Title and Type of Music. While going
to
>>> update
>>> it today with a couple new CD's, I noticed that if I sort
alphabetically
>>> by
>>> Artist it have 387 records but if I sort by Album Title it shows 393
>>> records.
>>> Any idea why this would be? And I know of at least two titles that
>>> don't
>>> show
>>> up when I look for them under the Artist sort. There's obviously a few
>>> more
>>> missing. Thanks.
>>
>>Access 2000 is "out of sup****t", but the Service Packs and other updates
>>are
>>still available -- my first step would be to look at "Help | About
>>Microsoft
>>Access 2000" and make certain that it is at the SP3 level; then go to
the
>>Microsoft site for Office update and see if there are later updates.
>>
>>If you are up-to-date, or if you still experience this after bringing
your
>>Access up to date, go into Query Builder, on the leftmost part of the
>>toolbar, click the dropdown, choose SQL view, copy the SQL for both
>>querys,
>>paste it into a response to this thread, and maybe someone will have a
>>good
>>suggestion.
>>
>> Larry Linson
>>
> Okay, I went to Microsoft's site and first downloaded SP1a as I
apparently
> had
> no SP's installed. I installed that then installed SP3 so all is up to
> date (the
> SP version shows up now in Help | About), but the problem with the
number
> of
> records still exists. Now I can't find Query Builder anywhere in any
drop
> down
> menus or on the tool bar. I looked it up in Help and it tells me to open
a
> do***ent in Design View. I tried that and get a warning that I can't do
> that
> because the security setting in my browser is set too high and to lower
it
> or
> see my system administrator. I AM the administrator. This is my home
> computer.
> What browser are they talking about? I only know about web browsers i.e.
> Internet Explorer. What would this have to do with Access? I'm totally
> confused.
> Bottom line is I just can't figure out why, with one sort I get one
number
> of
> records and with another sort, I get a different number.
>
|
