Using COUNT - Microsoft Access Expert 3


	Back to Access Expert 3 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Using COUNT

Joan Young

2 years ago

I would like to get the record count from another table to display on a form. With =Count(PhotoTBL.PhotoID) it at least doesn't refuse the syntax, but it displays as #error. I have tried it with the primary key (ID) and with a different field. Can I do this?

	Kevin Robertson @Reply 2 years ago
Use DCount.

	Joan Young OP @Reply 2 years ago
I got this syntax from an example, but it isn't working. It accepts the syntax, but doesn't display either an error or a value. DCount("PhotoID", "PhotoTBL")

	Kevin Robertson @Reply 2 years ago
Are you entering the function in the Control Source of the Text Box? Try this to count all the records in the table: `=DCount("*", "PhotoTBL")`

	Joan Young OP @Reply 2 years ago
Yes, putting in control source. That did it! These courses are the best! 18 years ago, I really knew what I was doing with Access, but I've forgotten SO much. Thank you.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 3.

Next Unseen