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?

>>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?

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?