how do I add different criterias in a make-table query?

M

mutlu

I am trying to add different types of criterias in a make table query. The
problem is that I could not manage to enter a null parameter value (At that
time I want to get all data in the field). for example in the state part,
there are three different name "chicago", "NY" ,"NJ". when write NJ, all
data contains NJ comes into the screen, however, if I directly press enter
and wanna to get all data, there is a problem. Any ideas
 
M

[MVP] S.Clark

....WHERE Fieldname Like [Enter State] & "*"
will allow a blank value in the field, and retrieve all data for that
column.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting
 

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

Create a chart from a table in word thats dynamic 0
Powerpoint Ink Reacts Different in Different places 0
How can I calculate tax for 2 states? 8
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Make table query: [Enter 1] AS Test 1
How do I clear a form? 0
how do you have 2 columns totaled in a cross tab query 4
Dealing with a Pivot Table (when I don't want to) 0

Top