Attractive Blond woman, looking for help with Access

[Guest]

Ok so im not an attractive blond woman...

I was just wondering if the Heading might catch someones attention and help
me find some answers ???

I have a form that accepts registrations, involving contact info, date and
time.
Beside those fields is a subform that is set to display any "limits" that
have been set on registrations for that day. This way the user can select
alternate times if he / she sees there will be a conflict.

In order for someone to realize if a limit has been met, I need the current
# of registrations that have already been made to be displayed on the form.
However, I need this total to be specific to the date that the user has
entered on the form.

I have tried using DCount... and maybe I am using it incorrectly.. but it
usually comes back telling me the expression I have created is too complex.

I would like to be able to display a list that would have the times that
registrations have been made, along with the number of entries at that time.
This list would populate once the user had entered the "date" on the form.

ie. dcount would use the date being entered to count the # of entries made
at each unique time slot on that date.

Sorry for such a confusing post... I hope the general idea has gotten through.

Thanks in advance for any help on this!!!

Cheers

 

[Sylvain Lafontaine]

You should give us an exemple of your DCount expression if you want some
advice on it.

If you want to build a list, then using a Count(*) associated with a Group
By statement in a Select would be a better idea. If necessary, this Select
statement can be used as a subquery. Counting the number of entries if
usually a simple task; the only exception being if you want to include or
exclude null values.

Finally, you should start another thread with a real subject describing your
problem. This will give you a much better chance of getting an appropriate
answer.

 

[Tony Toews]

Ok so im not an attractive blond woman...

I was just wondering if the Heading might catch someones attention and help
me find some answers ???

Yes and no.

Tony <smile>
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm