Month Sort on report

D

dawnecia

I need to track the monthly information received by policy holders according
to the effective dates of the policy. For example, policy A has an effective
date of 6/1/07, on the report I would like to start the information from June
07 to May 08. Policy B has an effective date of 4/15/07 - the report should
run April 07 to March 08. Any help would be appreciated.
 
D

Duane Hookom

I'm not sure what you question is. Your subject line states "Sort" which
means to display in a particular order. Your message seems like you want to
"Filter" your report by a date range.

Have you read any of the many messages here and on various web pages
regarding filtering or setting criteria for queries/reports? Is this what you
are looking for help with?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab Month Sort 1
Calculating interest due on late loan payments 1
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Summarise data by Month 7
Report Help - Starting/Ending Balance 7
Return column values based on criteria (HLOOKUP & VLOOKUP?) 0
Date Equation on Report 3
Report Using Crosstab Query 1

Top