Data selection based on system date

[Aidanb]

Hi All,

I have been asked at work to create a report that uses actual data and forcasting data.

This will be monthly figures entered in to the database, from this we would like it to produce a year to date figure based on the current date and then projected earnings figure based on current information entered in and the budget figures entered in to the database.

any help would be greatly appriciated.

Thank you.

 

[raskew]

Hi -

In the criteria cell of your date field,

Between DateSerial(Year(Date()),1,1) And Date()
...returns records from current year to date, while

Between Date()+1 And DateSerial(Year(Date()),12,31)
...returns the balance of the current year

HTH - Bob

 

[Aidanb]

Hi Bob,

would this work with the system date so all i would need to do is tie it in to a command button so when i click it, it would print the report with the actual figures up to todays date then add the forecasted figures after todays date. and how would i do this in a report so it would incorporate everything past and present.

Thank you for your help and guidance.

Regards

Aidan