A simple count

  • Thread starter Thread starter Kathy
  • Start date Start date
K

Kathy

Hello,
I am new to Access and I am just trying to get a simple
count of a list of names. I am using the count function,
but it returns the count as 1 1 1 1 1, instead of 1 2 3 4
etc. I have a feeling this is easy, but I just have not
been able to get it correctly. Any help is greatly
appreciated. Thank you.
 
Hello,
I am new to Access and I am just trying to get a simple
count of a list of names. I am using the count function,
but it returns the count as 1 1 1 1 1, instead of 1 2 3 4
etc. I have a feeling this is easy, but I just have not
been able to get it correctly. Any help is greatly
appreciated. Thank you.
Click to expand...

Well, *you* can see your table and your query; we can't!

Please open the Query that's giving the "1" counts; go to SQL view
(with the View menu item or the SQL option on the leftmost icon in the
query design toolbar), and post the SQL here. That should give someone
enough information to post an answer.
 
To John Vinson: please re-send your reply as it did not
get posted. Thank you.
Click to expand...

The Microsoft webpage interface is badly bollixed up today... LOTS of
people (including me) aren't seeing responses. Therefore I'm sending
this by EMail (or you probably won't be able to see this answer
either).

You can use Outlook Express as a newsreader rather than using
Microsoft's malfunctioning web page. Set the news server to
msnews.microsoft.com. This *appears* to be working, though the webpage
isn't.

Please reply to the newsgroup - if you really can't, or can't see this
reply there using OE, you can reply by email (just during this
out(r)age).

Hello,
I am new to Access and I am just trying to get a simple
count of a list of names. I am using the count function,
but it returns the count as 1 1 1 1 1, instead of 1 2 3 4
etc. I have a feeling this is easy, but I just have not
been able to get it correctly. Any help is greatly
appreciated. Thank you.
Click to expand...

Well, *you* can see your table and your query; we can't!

Please open the Query that's giving the "1" counts; go to SQL view
(with the View menu item or the SQL option on the leftmost icon in the
query design toolbar), and post the SQL here. That should give someone
enough information to post an answer.
 
Back
Top