Date Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
Back
Top