Hi All,

This is a hard one to explain,

Attached is a sample of one of the forms, I need to create a "outstanding/due" query, but I am wanting to use each of the actions

Notice Sent to Client Date as each different line

example

Client Site Action Date
Test 1 1 A Street Notice Sent to Client 13/06/08
Test 2 2 A Street Notice Sent to Incumbent 14/06/08


I can get the Client, Site, Date section but the Action point, dont know if its possible to use the Action as a line in a query.

Hope you understand what I mean

It is also very hard to understand what you mean. Could you draw a picture of how you want it to look like?

you probably want a lookup table of standard actions

so action
1 - notice sent
2 - recovery proceedings started

it will be easier to query the database, based on numeric values

Thanks,

Attached is a picture of what the end up query will look like within the front page of the DB,

Also attached is the DB so you can have a look.