2 hours
ago: Looks like the site was down today for about half an hour. Of course, as soon as I put a support ticket in with WinHost, it came back up and seems to be running normally now. Sorry for any inconvenience. I love technology, lol.
Dismiss
Hi. My query is not right!!! I try to count up my items. MASPIN, CK18 and SMAD4 are OK but CALD gives me 12, why? Should be 2 not 12. Any idea? Thanks Masih
Masih Ostad NovinOP
@Reply 2 years ago
Masih Ostad NovinOP
@Reply 2 years ago
Masih Ostad NovinOP
@Reply 2 years ago
Masih Ostad NovinOP
@Reply 2 years ago
Adam Schwanz
@Reply 2 years ago
There's no calculations or anything here, It's just straight data. So it has to be you put 12 in the table for the value instead of 2?
Another possibility, if you're trying to get a count of them, is you need to a field set to "count" instead of "group by"
John Davy
@Reply 2 years ago
Hi Masih
I am not sure what you are trying to count, for I cannot see your data, but try making a Query to do the count and then use that Query in the next query to Group your records.
John
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Forum.
