 | |
Re: Totals query plus manual input
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Totals query plus manual input -
08-05-2003
, 10:49 AM
|
I belong to a non-profit group that teaches seniors and am responsible for the student enrollment db. A status report of the number of students registered and the number waitlisted in each class is desired. Am using a Totals query to obtain the number registered from the student registration table. The number waitlisted is to be entered manually. A form can be created from the Totals query with a column for the waitlisted ... BUT it is read-only! Any suggestions on how to have one form which displays the Totals query data AND allows the waitlisted data to be entered manually? Chuck No, but those waitlisted people should be in a table too, then you can |
Bob
Quote:
| |
#2
| |||
| |||
|
|
Chuck Goldstein <chuckmg (AT) comcast (DOT) net> wrote in news:3F2FCC6C.9E078AC (AT) comcast (DOT) net: I belong to a non-profit group that teaches seniors and am responsible for the student enrollment db. A status report of the number of students registered and the number waitlisted in each class is desired. Am using a Totals query to obtain the number registered from the student registration table. The number waitlisted is to be entered manually. A form can be created from the Totals query with a column for the waitlisted ... BUT it is read-only! Any suggestions on how to have one form which displays the Totals query data AND allows the waitlisted data to be entered manually? Chuck No, but those waitlisted people should be in a table too, then you can just total them. Bob |
Obviously!
Why didn't I think of that??? Probably because there is noprovision for entering people who are waitlisted. There will be now!
Many thanks,
Chuck
#3
| |||
| |||
|
#4
| |||
| |||
|
|
Bob Quintal wrote: No, but those waitlisted people should be in a table too, then you can just total them. Bob Bob... Obviously! Why didn't I think of that??? Probably becausethere is no provision for entering people who are waitlisted. There will be now! Many thanks, Chuck The provision is already there. Just treat them as registered students, |
call onWaitlist.
Bob
Quote:
#5
| |||
| |||
|
|
The provision is already there. Just treat them as registered students, but register them in a class called Waitlist. Or just add a Yes/No field call onWaitlist. Bob |
we also have the class(s) for which they are waitlisted. Could, of course,
have captured the class with the first suggestion, but just unchecking
would not have left them in the right class or classes.
Chuck
#6
| |||
| |||
|
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.