Count in a Query

[Bentley]

Hello,



I have a query written and I am using the count function to count the number of items performed or requested. However, when I use the Not Like criteria when counting, it appears that access ignores this command and counts the 'not like' item in the total. Is there a way around this or do I need to figure out a different way to obtain my count query?

Bentley

[davegri]

If you're using <> This OR <> That
try
<> This AND <> That

[Bentley]

I ended up adding an additional field to fix the issue. Now I have another in the same query. How do I count one item from a combo box where I made the choices? I have entered in the criteria using the "like" & "not like" but neither seems to work.

[CJ_London]

suggest you post the entire sql for your query so we can see what we are dealing with

[Bentley]

I am not sure how to post the SQL to this thread.

[CJ_London]

if you are talking about query sql open the query in design view

select the sql window (from dropdown to the left of the ribbon, or the SQL button to the bottom right of the access window)

copy the code and paste into your post, then highlight the pasted code and click on the code button (# button) to surround the code with the code tags

if talking about vba code

highlight the relevant code (the whole function or sub) copy, paste and surround with code tags as above