30, 60, and 90 day reprots

[Lindsay]

Im know access fairly well, and I am creating a database that will keep
up with contracts for customers. I need to develop a report that will
allow me to see which contracts are 30, 60, and 90 days from renewal.
Do I need to create a crosstab query??? Any help with this would be
greatly appreciated.

 

[BruceM]

Something like this in the criteria row for your date field (query design
view) should work:
Between DateAdd("m",1,Date()) And Date()

This will give you all records in which the date in that field is between
now and a month from now. You could also use:
Between DateAdd("d",30,Date()) And Date()

This specifies 30 days exactly rather than the same day in another month,
which may be more (or less, in February) than a full month.

Or, from another angle, you could enter:
Between [Start Date] and [End Date] as the date field criteria. This will
prompt you for the dates.

Or do you mean to produce a single report that shows 30, 60, and 90 days all
at once. Your will need to be more specific if the answers given so far do
not do the trick.

 

[Guest]

Use a select query and add a column like this --
Date Group: Format(Left(Partition([Date open],0,999999,30),7),"mm/dd/yyyy")
& " : " & Format(Right(Partition([Date open],0,999999,30),5),"mm/dd/yyyy")
Substitute your date field for the [Date open].

In your report use Grouping and Sorting. Group on the Date Group ( or your
label) and then sort on your other fields as nedded.

 

[Lindsay]

Thank You for your help! That's exactly the advice that I needed!

 

[BruceM]

You're welcome. Glad I could help.