complex query

C

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
 
L

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top