Access 2007-Report by Month; Year to Date Total

[SueW]

Returning Access user after a two-year absence.

Report to show the following:

Month Count Expected Shorted Over
Jan 100 200 100
Feb 250 200 50
Mar 50 200 150
etc.

Yearly Total: 400 200 250 50

Count is the number of appointments scheduled for a month. I know how to
get the calculations done. It is showing the constant data that I don't
remember how to.

Would it be best to query the data for a count and then actually place the
above data on a worksheet in Excel?

 

[KARL DEWEY]

It is showing the constant data that I don't remember how to.
What does 'constant data' mean?

What are your table and field names? DataTypes? Post some sample data.

 

[SueW]

Scheduling senior/disabled transportation appointments.
Expected field will always be the same number for an entire year.

tblSchedule
ScheduleID-PK-AutoNumber
Driver-Number
Day-Text
AppointmentDate-Date/Time
PickUpTime-Text (Need to add the word Cancelled before the time if appt. is
cancelled)
SeniorIntakeID-Number
AppointmentTime-Text (Other information is entered into this field in
addition to
the time)
AppointmentNotes-Text
Destination-Text
ReturnTime-Text (Same as AppointmentTime field reason)
ReasonforTransportation-Number
Cancelled-Yes/No
DateCancelled-Date/Time
WhoCancelled-Text
NoShow-Yes/No
UnabletoSchedule-Yes/No

Need to query this table to count how many rides were given in a month.
Then the report below written.