Form Question

[smpayne]

I want to create a form that just counts the number of records in a given table and displays the total number of records in the table. Also, putting a button or something by the total in the even the user wants to access the table.

Anyone??

Shawn.

 

[FoFa]

Just use the agregate function Dcount and put the results in your field for display.

 

[smpayne]

Huh??

lol... Ok, lets put it this way...I have no idea how to do that. I am soooo new to Access and VBA. Could you show me the syntax is the table I want to do a count on is called 'PoolA'??

I appreciate it!

Shawn

 

[ghudson]

Check the Access help files for more info on using the DCount function.

'This will count all records in the PoolA table
=DCount("*", "PoolA")

'This will count the number of orders to be shipped to California
=DCount("[OrderID]", "Orders", "[ShipRegion] = 'CA'")

 

[smpayne]

Sweet!

Perfect, I created a lable and used the function. Works perfect!

Thanks so much!

Shawn