Query to count records in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I need to creat a query to count how many records I have in a table
according to a specific criteria.

How?? When I insert a criteria que query return zero results. Why?

Regards,
Marco
 
You can use DCount:

? DCount("*", "TableNameHere", "fieldNameHere =1056" )


should return the number of records where the field holds the integer value
of 1056.


You can also use a query. Its SQL statement, in SQL view, could take a look
similar to:


SELECT COUNT(*)
FROM tableNameHere
WHERE fieldNameHere= 1056



What is your SQL statement (in SQL view of the query) ?




Hoping it may help,
Vanderghast, Access MVP
 
Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
query counting issue 4
Using "Count" in Queries 1
counting Null fields 3
Sum of Counts from a query 1
Use In() Expression as Query criteria with guts from Function 1
Access Counting records based on multiple age bracket and output to tabulated report 0
Counting records matching criteria 4

Back
Top