Saving Querys

  • Thread starter Thread starter Beth
  • Start date Start date
B

Beth

I have created and saved my query but when I go back to it
it still asks me what id number? How do I save the query
that i created and then go back and create new ones to
save for other items?

Thanks

Beth
 
I have created and saved my query but when I go back to it
it still asks me what id number? How do I save the query
that i created and then go back and create new ones to
save for other items?

Thanks

Beth
Click to expand...

Beth,

You can see your query. You can see your database.

We cannot. And we're not mindreaders.

Please open the query in SQL view and post the SQL text here, and
explain what you want the query to do. Typically you should NOT save a
whole bunch of queries with different fixed criteria; if you have a
criterion of

[Enter ID:]

the query will prompt you for the ID and then display the results for
that ID, so that you can use the one query for any desired ID without
storing a mess of almost identical queries!
 
Back
Top