parameters for queries

  • Thread starter Thread starter BJM
  • Start date Start date
B

BJM

I have a table that keeps attendance for students. My
principal wishes to see a list of all students with no
attendance for the previous three week period.

I keep the attendance on a per week bases and the field is
a week number, not a date.

How can I query the table to show me those students with
no attendance for three consecutive weeks? I understand
how to set the criteria to find no attendance for a single
week, but how do I set a compound criteria on a single
field for three week numbers in a row?

Thanks,
BJM
 
Without using any VBA code?

If so, then I would create a query of missed attendence for each week.

Then, create one more query that links all three queries together. Any
student that satisfies each condition will remain in the 4th query.

There are some more graceful things that could be implemented, but this can
get you started.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Thanks Steve. I guess I could write a macro to run the
four queries, but I'm not afraid of VB code. If the more
graceful solution requires a bit of coding, I'd be open to
hearing it.

Thanks,
BJM
 
The queries would still be involved, the automation is where the VBA would
be used.

It wasn't clear if this was a one-time deal, or something that needed to
occur on any random day, with a random number of weeks. With the
random-ness, VBA would help with the parameters.
 
Back
Top