counting ids

[Paula]

Hi
I have a form in which I link people (in a table as clients) with a certain kind of room they are booing(doubles - twin - singles).
The kind of room is an id to a room type.

I want to know the total amount of singles, doubles, etc and put that into a box that will change everytime I book someone to a room.
How can I count the id types ?

Regards.

Paula

 

[Amy Vargo]

Hi,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.

You might be able to use the DCount function in the Control Source of a
textbox to count values in a table based on criteria. For more information
about the DCount function, you can search in VBA Help under the topic
"DCount" or "domain aggregate functions".

In addition, the following article uses the DLookup function, which is a
different aggregate function, however, the syntax of the statements and
examples still applies. Please review this article for examples.

208786 ACC2000: DLookup() Usage, Examples, and Troubleshooting
http://support.microsoft.com/?id=208786

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.