If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2007-Report by Month; Year to Date Total
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? |
#2
|
|||
|
|||
Access 2007-Report by Month; Year to Date Total
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. -- Build a little, test a little. "SueW" wrote: 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? |
#3
|
|||
|
|||
Access 2007-Report by Month; Year to Date Total
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. "KARL DEWEY" wrote: 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. -- Build a little, test a little. "SueW" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|