complex query

[cliff]

i have following data
cdata-query
lastdate nos
1/16/08 14
2/23/08 16
2/27/08 23
2/28/08 45
3/31/08 61
4/12/08 55

playdata table
nos
14
23
12

now I have list value in cdate-query moving nos from playdata table. how can
achieve that. moreover I want view data in cdata query while selecting for
playdata table . How to do that. what changes required in query. In other
words suppose after selecting 14 nos query table should all existing value
minus 14. similarly after selecting 23 query table should show all but 14 &
23.

please held to solve this

thanks

 

[Lord Kelvan]

that sounds like you want a nice form with a bit of code you cannot do
that in a query try posting in

microsoft.public.access.forms

Regards
Kelvan