Creating Duplicate

[bgcogen]

Hi!

This is my boggle:

Basically I have a form that the user input into. They input 3 fields. E.g. Incident Type, Site and Date. Grand.

I want to create a report based on a creteria query that sorts the data based on date. So the user inputs a start and stop date and all the records betwen those values are shown.

But I only want it to show the last record that was entered for that particular site with that incident type, because in fact there will be lots of the same incident type at a particular sire. E.g.:

1-7-02 Dublin Outage
7-7-02 Dublin Outage
7-7-02 Cork Spark Plug
....
...

So I want the report to only show the last record for each site and incident type.


Hope yall got that!!!

Anywho, thanks,
D

 

[FloBob]

Whelp you have kinda a doosie there. What I would do is make a recordset of your table finding the date ranges you need. Then sort it assending. you can run it thur a loop to find the last date entered for and perticular item and walla. However it will be quite tedious on the system. If you need code examples email me.

 

[Fizzio]

In the query that populates the report, set the date field to Max and unique records to yes. I think this will filter your list.