query parameter?

  • Thread starter Thread starter js
  • Start date Start date
J

js

Hi, how to create a query can accept parameters, and how to avoid
that(sometime I see a popup box for asking parameters for this query: select
* from tb1 where id not in (select id from tb2)? Thanks...
 
The popup that you see is a prompt for the parameter, so this is the UI for
it. It's not great, but it's the quick and dirty method. If you need
something better, you can build a form, then have the query look at the form
for the values.

Select * from tablename where somefield = forms!formname!controlname
 

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

Similar Threads

complex update query 2
need query results showing Table 1 records both w/ and w/o matches in Table 2. 6
Parameter Query Won't Run 0
Update Query with Parameter 3
How to use variable in sql string 1
Using Combo Boxes as a Source for Parameter Queries 2
Parameter Query help - Not passing parameter? 3
Modify Parameter Query 1

Back
Top