total record in each Query to be show in the Main Dashboard form

[YaseenIskaf]

total record in each Query to be show in the Main Dashboard form

Dear All

I have a database with many Quires I want to create in the main form “welcome Form” many txt boxes cells
To show a total records in Each Quires
For Example I have the below list queries

1. Expired Employees Passport
2. Expired Employees Work Permit
3. Expired Employees Visas
4. Expired Employees Insurance

In the “Welcome Forms” I will create a txt boxes Cells for Each one of those Queries to be Show only No “total Record in Each one”
It is like a dashboard to monitor daily without opening the Report or Query

So, can I get a help

Thank you All

[alansidman]

Try using the DSum function

http://www.techonthenet.com/access/f...omain/dsum.php

[spider]

DSum will calculate the sum of fields. If you want to show the number of records, we will need to use the DCount function.


DCount ( expression, domain, [criteria] )

exampe: DCount("UnitPrice", "Order Details", "OrderID = 10248")

[alansidman]

Thanks Spider for correcting my suggestion with the correct function.