Date Query

P

PPerry

I have a query (thanks to this group) which works like a charm. This query finds the last date for an event. I now want to produce a report which displays this date (from the query) and also counts attendance from this query date. Any ideas? Would this be a seperate query? Once again, thank you for your help in this matter
Pat
 
V

Van T. Dinh

Not enough info. for me to give precise suggestion but my guess is that you
need to use the techniques in The Access Web article:

http://www.mvps.org/access/queries/qry0020.htm

--
HTH
Van T. Dinh
MVP (Access)



PPerry said:
I have a query (thanks to this group) which works like a charm. This query
Click to expand...
finds the last date for an event. I now want to produce a report which
displays this date (from the query) and also counts attendance from this
query date. Any ideas? Would this be a seperate query? Once again, thank you
for your help in this matter.
 
P

PPerry

I have a table which records the dates students received their latest karate belt. The fields are BID (Belt ID), SNAME (Student Name), PRANK (Promotion Rank) and PROMD (Promotion Date). Using a query generously supplied by this group (SELECT Max ( [PROMD] ) FROM BELT AS X WHERE X.SNAME=BELT.SNAME), I can now query on the very last date of belt promotion for each student
However, I need to calculate attendance from this last belt promotion to determine if the student is eligible to test again (karate rules state required hours of class participation between belts). I have another table which records attendance. The karate owner uses a book to record daily attendance and records only a cumulative number at the end of the month. The table for attendance has the following fields: AID (attendance ID), SNAME (Student Name), ATT (Number of attendances for the month) and MONTH (the month and year)
I am unsure how to use the queried last date and the date today to achieve a sum of the number of attendances from the last belt promotion to the date of the query. Any help would be MOST appreciated
PPerry
 
Top