Number of records

[ianbar]

Hi,

I need to write a query that returns the number of records that match the criteria. I do not need to see the reults just the number of records matching the criteria. Is this possible? Any help would be really appreciated.

 

[SoloDroid]

Hello ianbar,
The query would look like:

SELECT COUNT(*) AS MyCount FROM MyTable WHERE ...

Good Luck, Robert
•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•
Professional, affordable, Access database solutions and assistance

http://www.SoloDroid.com

°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°

 

[muneco]

Try something like this:

select count(*) from mytable
where condition = 1;

Of course substitute "condition = 1" with your own criteria.

 

[ianbar]

Thanks, I got it working.

 

[ianbar]

I am trying to create a form that shows database statistics, like:

Number of Complaints: 90
Number closed: 88

How can I do this using this query, do I need to code it in VB?

 

[SoloDroid]

Use the domain aggregate function DCount(). In your text box add the following control source:
=DCount("MyID", "MyTable", "Complaint = True&quot
and to the other box's control source:
=DCount("MyID", "MyTable", "Close = True&quot

Of course you will have to substitute the appropriate values, but this should give you the basic idea of what to do. Robert
•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•
Professional, affordable, Access database solutions and assistance

http://www.SoloDroid.com

°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°