Query to Show selection after certain date and code

[GraemeG]

Hello,

I have a table of a list of repairs orders for 10000+ properties. There are various details for each line address, workforce details, log details, costs etc.

I need to produce a query that shows what appears after the specific workforce "Z1MT" has been logged.
For example. 1 Smith Street had the Z1MT" repair logged on "1.10.2011". I need to show what repairs have been logged since that Z1MT Date. However this table contains 10000+ properties with 37000 repairs. and more than one Z1MT. would I have to break this down for each property that has had the Z1MT first?

Any help much appreciated.



I have attached a picture for detail.

Thanks
Graeme

[orange]

Can you show the tables and relationships for your database?

[GraemeG]

Can you show the tables and relationships for your database?

Thanks Orange. I managed to sort it by doing a few queries first with date specifics against Z1MT then doing a crosstab.
Thanks