Thank you for taking the time to report an issue.
What's wrong... Please write below.
Charts for Daily Attendance report, Weekly Report, and monthly Report. For this how to design database in msaccess?
SELECT [QA Tracking].[State], ([QA Tracking].[Misnumbered Check Number]+[QA Tracking].[X-Post Not Rej/Flag]+[QA Tracking].[Check Rejected for Incorrect Reason]+[QA Tracking].[Mis-Keyed Vendors]+[QA Tracking].[Vendors Not Charged]+[QA Tracking].[Vendor Charged Incorrectly]+[QA Tracking].[Altered Error]+[QA Tracking].[Missed EE's Not Flagged/Rej]+[QA Tracking].[Check S/B Paid]+[QA Tracking].[No Issuance Keyed/Checked]+[QA Tracking].[Check S/B Rej]+[QA Tracking].[Stale Date Missed]+[QA Tracking].[Missing Signature(s)]+[QA Tracking].[Invalid MICR Line]+[QA Tracking].[Invalid Flag(s) Not Checked]+[QA Tracking].[Processor]) AS [Total Project Errors]
FROM [QA Tracking];
But when I run it in Access, nothing is showing up in the Total Project Error column for any of the States
I have two tables
1) List of staff members (Name and Dept)
2) Daily log of who attended (Date, Name, Dept etc
My Student Information form is used for inputing basic student information and then it's apended to the Student Information table.
I'd like to make each student's attendance viewable on the Student Information Form. If so, could you explain how this is done.
I've also read something about subforms. This is my first time working with Access 2007.
What I did was this:
Now what this does is simply count the boxes regardless of if there checked or not. How can I make this show the sum of only those that are checked true.
I been reading before asking and I was reading I could do something like = Count(IIF([Tardy] = True,1,Null)) but even though Tardy only exist on one table and I have specified that table it still tells me that Tardy could apply to too many things when I try and run it
Currently the table was 12 weeks so there is:
12WeekProgramme.Week 1 Date
12WeekProgramme.Week 1 Attendance
12WeekProgramme.Week 2 Date
12WeekProgramme.Week 2 Attendance
And so on.
Marks are AA/UA or /
Is there a way I can export the dates/marks to a new table with only the 2 columns? Then I could use that to tally types of attendance within a specified date range
Report Attendance record by Scout
Report Attendance record by Term
Report Attendance record by Date
Report Attendance record by Activity
Fileds I am looking at is
Date - Meeting date
Name - Scout Name, needs to be associated as a pull down list from scout name [scout input table]
Activity - Pull down box [Indoor Activity] [Outdoor Activity]
Just not sure how to do it
After having done the initial database of the personal data, classes, teachers, ecc., now I need to relate the attendance registry to the main table.
I think this is a many-to-many relationship, because one person will have various dates of attendance, and one date will have many persons which will enter the school
What I am trying to figure out it the sql query or VBA to call the records that are not associated with dates from the attendance table between and including 2 dates.
For example: on My form I have 2 txt boxes that I place in Mondays date and say Weds date I need to see who hasn't been recorded for attendance between and including the dates in the range.
IE who doesn't have at least 7/18 7/19 7/20 but I could also chose the first and the 30th of any month so I need a formula referring to the 2 boxes.