ACCESS

[SeanE]

I have created a report to show my purchase orders by supplier by delivery
date (oldest date first), is it possible for Access to "draw a line" under
dates that are older than todays date, but still show the rest of the future
orders that are due.
I would then like it to give me a percentage of what the over due qty is, ie
tally up all the parts due, divided whats overdue, and put into a percentage
format.
Any help would be great
Thanks
Sean

 

[Marshall Barton]

I have created a report to show my purchase orders by supplier by delivery
date (oldest date first), is it possible for Access to "draw a line" under
dates that are older than todays date, but still show the rest of the future
orders that are due.
I would then like it to give me a percentage of what the over due qty is, ie
tally up all the parts due, divided whats overdue, and put into a percentage
format.

I think you need to add a level of grouping to separate the
two sets of records. Use an expression like:
=DeliveryDate < Date()

You can then use a text box in this group's footer section
to calculate the total quantity before and after today's
date.