Help with MS Access reports

[jrmachine]

Can anyone help me????? I need to set my reports on MS access to only report delinquent records and specific dates.

 

[GingerR]

Without any further information from you, the most basic way to do this is to write a query based on your table(s) and then use that query as the recordsource of the report.

I assume you have some date field on which you decide "Delinquency"? So let's say you have two fields, DueDate and CompDate. Generally, Delinquency would be defined as CompDate is blank (null) and the DueDate is prior to today. So in the criteria for your query, you'd set the criteria for DueDate to

<=Date

and the criteria for CompDate to

Is Null.

I'm not sure what you want filtered on for specific dates.

Please read through other posts within this forum to see how other people provide more information (table structure, field names, what they've tried, what doesn't work, how they want it to work, etc) otherwise we can't really help you. Also, you could easily search this forum or a text book for the basics on writing reports.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[ProgramError]

Specific dates could mean...

between dates...

a selection of dates...

one date...

before a particular date...

after a perticular date...

to date...

More information required


Ian Mayor (UK)
Program Error
Programmers do it one finger at a time!

 

[jrmachine]

I have a database set up so that if a person is put into the system you have fields for: ID number, last name, first name, diagnoses, date diagnosed, and date of follow up.

I want my query to show only the people that dont follow up in a thirty day period. Therefor if the date diagnosed expires without update, the info from above will show up on the query. and the person can be contacted simply by checking the report without having to dig through the database.

 

[GingerR]

Do you mean 30 calendar days? or 30 working days?

For 30 calendar days, use the DateAdd() function.

In the criteria of your query, you can put for DateOfFollowUp:

Is null


Make a caluculated field in the query:

FollowUpDue: Dateadd("d",30,[DateDiagnosed])

And in the criteria, put

>=date()

This adds 30 calendar days to the DateDiagnosed, and if that date is >=today and DateOfFollupUp is blank, the record will be returned.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html