Remove duplicates based on 2 category and only show data from last 24hrs

[ttbeverley]

Gday Again.

This Forum is AWESOME!

I have got so much useful information from the people on this site.

I have another question that i am having trouble findiing an answer on.

I have created a report, but at the minute it is 4500 items long, each item being output to a single A4 page. What i would like to do is limit this to 48hrs MAX and if possible not print again if it has already been printed?

This same report will have duplicates of items, i would like to limit the criteria to not duplicate based on two columns, one being an IP Address and the other being an alarm condition. Is there some way to do this query based on IF ip address is a duplicate and condition is the same?

Once i have got the duplicates removed, i would like to impose the 48hr limit so that it does not print out reports that have happened outside 48hrs OR reports that have already been printed (if possible).

Any advice you can offer will be much appreciated.

I would like to do the query in the reports section if possible, i am not sure of how the query wizard works nor how to apply it to a Report instead of a table.

Thanks for your time

T.T.

 

[James Dudden]

Hi,

I think you need to add grouping to your report query to get rid of duplicates - in design of report open the Properties and on the Data tab select Record Source - now click on the little box with 3 dots at the end of the line to open your report query.

To add grouping click on the Totals button (looks like a backwards E) on the toolbar.

For the 48 hr limit you need to do a calc on a date field that preferably is a date and time field (If they do not have a time on them the default is 00:00 which could produce the wrong results).

A simple version of this is to put the following in to the date field criteria - >Now()-2 And <Now() - this would give you the 48 hours from the time you run the report. If you wanted to specify the cutoff point you will need to add a text box on a form to enter a date manually.

To not print reports that have already been printed - you could add a checkbox which is ticked when the user presses a print button. The problem being i'm not sure how you could control this as people could open the report but not actually print it.

Hope some of this helps get you started