general problems with queries

[Guest]

I made a table according to the wizard "mailing list"
I made a simple input form
I made a querry(with the wizard, again,) made by first name, last name,
phone numbers.
saved it.
and it doesn't work. the only thing I get is sth like the main table where
you can only alter/input your contacts, but only the records you have
selected for the querry.
What should I do? I downloaded an example from queries help and it works
fine but I didn't see any properties different from mine.

 

[Guest]

I think I found it... I shouldn't have used the primary key?! it somehow
affected the query (it seems so, at least!)

Ο χÏήστης "atacams2" έγγÏαψε:

 

[John Vinson]

I made a table according to the wizard "mailing list"
I made a simple input form
I made a querry(with the wizard, again,) made by first name, last name,
phone numbers.
saved it.
and it doesn't work. the only thing I get is sth like the main table where
you can only alter/input your contacts, but only the records you have
selected for the querry.
What should I do? I downloaded an example from queries help and it works
fine but I didn't see any properties different from mine.

Please open your query in design view, select View...SQL from the
menu, and post the SQL text here. Also describe what values you're
getting, vs. what values you expect to get. "sth like the main table"
means nothing to me - sth is not a word and I can't dope out what it
should have been!

John W. Vinson[MVP]