displaying data

[stevie1969]

Can't figure this one out. I am trying to get my query to show me which company's have not sent a supplier any money during a certain period.

However if I have the following data

abc company
1/10/02 £5
1/12/02 £10

an i search for any company who has not sent any money between 2/10/2 and 1/11/02 abc company does not show up because there is no data between these dates. If I had a record 2/11/02 £0 it shows up. So what criteria or query can I use to show this up?

many thanks

 

[Uncle Gizmo]

You may find this example Useful--- you may not find it useful .

 

[stevie1969]

sorry cannot get that Dbase to work.

anyone any ideas regarding my problem?

 

[gemma-the-husky]

do you have all your company's in a separate table, and your payments in another table. If so

1) prepare a query of the companies who have! paid between the dates you want to test

then

2) use the unmatched query wizard to compare the full list, and the extract, which will identify the ones that HAVEN't paid

 

[stevie1969]

fantastic, excellent

got it to work now

many thanks