X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Attendance By Date, Any Version    
post Aug 19 2019, 08:14 PM

Posts: 11
Joined: 22-July 12

I have to make an attendance report based on dates. It need to be by date (oldest to newest). Attached are the required report and a copy of my query
Attached File(s)
Attached File  query.JPG ( 23.01K )Number of downloads: 2
Attached File  report.JPG ( 67.29K )Number of downloads: 4
Go to the top of the page
Start new topic
post Aug 19 2019, 08:25 PM

Access Wiki and Forums Moderator
Posts: 76,391
Joined: 19-June 07
From: SunnySandyEggo

Hi. I think if you modify your query to look like your report, then you're all set.

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
post Aug 19 2019, 09:14 PM

UtterAccess VIP
Posts: 10,087
Joined: 25-October 10
From: Gulf South USA

Hi: This is a start on a solution for a query to feed your report.

SELECT StartDate, Sum(IIf(Attendance = "P" And [censored] = "M",1,0)) As PM, Sum(IIf(Attendance = "P" And [censored] = "F",1,0)) As PF, ... , Count(StartDate) As CorpsStrength, Sum(IIf(Attendance="P",1,0))/Count(StartDate) As Present, ... FROM qryAttendance GROUP BY StartDate ORDER By StartDate;

(The censor entered Censored where your word for gender appeared)

You can complete the other fields for attendance counts and percentages, and clean up any other issues for testing. The percentages will actually be produced as proportions, but you can format the control in the report. See if you can make this work for you.


Note: If you grabbed this right away, I just made some corrections to the SQL (9:17)... so check it again ...

"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    18th October 2019 - 11:56 AM