Re: Problem adding "<16" into DCOUNT function to reflect a cap of 16???
- From: "andrew v via AccessMonster.com" <forum@xxxxxxxxxxxxxxxxx>
- Date: Wed, 30 Mar 2005 22:40:45 GMT
tables are: tblCUSTOMER INFO and tblEVENTS with a one to many relationship
by CustID field.
forms are: frmCUSTOMER INFO and frmEVENTS
in the frmEVENTS, a user uses a combo box with custID to pull up the CustID
and CustName. the subform reflects tblEVENTS in datasheet view where the
user can schedule the customer for a testing date. the user would go into
frmEVENTS, pull up the customer throught combo box and schedule them for a
test session in the subform.
tblEVENTS
Event(a drop down menu with 8 different tests that customer can take)
EventDate(current date default)
EventTime(am or pm)
ScheduledBy
at the top of all this shows:
Date() Date()+1...
am-session (dcount)
pm-session (dcount)
where the dcount function calculated the number of customers who has been
scheduled for a am/pm session on a certain date. this shows that this many
customers has been reserved for this session on this date. this number
needs to be less than or equal to 16.
your suggestion about not being able to choose or flag closed suggestions
is great. hope this helps...
--
Message posted via http://www.accessmonster.com
.
- Follow-Ups:
- Re: Problem adding "<16" into DCOUNT function to reflect a cap of 16???
- From: Dirk Goldgar
- Re: Problem adding "<16" into DCOUNT function to reflect a cap of 16???
- Prev by Date: Error with date function
- Next by Date: Re: AutoExpand Not working
- Previous by thread: Error with date function
- Next by thread: Re: Problem adding "<16" into DCOUNT function to reflect a cap of 16???
- Index(es):
Relevant Pages
|
