RE: Parameter Query- Query not using other criteria

Tech-Archive recommends: Fix windows errors by optimizing your registry

Jerry,

I tried that and it appears to work. Thank you so much for the assistance.
This just made my day!

Thanks again,
Brent

"Jerry Whittle" wrote:

Under the Employee Number field put another Is Null right under the other Is
Null
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Brent" wrote:

Thanks for the reply Jerry.

I am learning to create databases on my own and I have no training other
than an Access book I picked up from a bookstore. The Criteria: Like [Enter
AOC] & "*"
and or: [Enter AOC] Is Null on the AOC field seems to be working fine.
It's just that a separate field, Employee Number, I just have a simple "Is
Null" criteria on it and it doesn't seem to be working when I don't put a
value in for the paramater on the other field. It's strange since those
feelds are unrelated other than the fact they are on the same table.

I look forward to a respones,
Brent


"Jerry Whittle" wrote:

Do you have Is Null under Employee Number once or twice? I'm thinking that
you need it on both the "Like [Enter AOC] & "*"" and "[Enter AOC] Is Null"
criteria lines.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Brent" wrote:

I have a query in which i have multiple parameters being asked for for the
user. I am using the wildcard and the or statement so that if the user just
hits enter it will pull all records and I am having a problem with the query
ignoring the criteria on other fields.

For Example:

Field: AOC

Criteria: Like [Enter AOC] & "*"
or: [Enter AOC] Is Null

But when I hit Enter when it asks for entering the AOC the query seems to be
ignoring the criteria on other fileds such as:

Field: Employee Number

Criteria: Is Null

the query appears to be ignoring the criteria for [Employee Number]. and
will show every record instead of those that have null values.

Does anyone know why this happens and how I can stop it?

Thanks,
Brent
.

Relevant Pages

  • Re: Dlookup and dates
    ... Reserved Words in Microsoft Access" ... When using a Date datatype criteria in Access, ... If the above DLookUp is being done on the form you can ...
    (microsoft.public.access.formscoding)
  • RE: Retrieve records based on 3 three periods, not using dates
    ... "Jerry Whittle" wrote: ... I need to create a query (for a report) that will automatically give me data ... I know I can easily do this by putting a criteria of Between [Enter Beg ... three periods automatically without any user input. ...
    (microsoft.public.access.queries)
  • RE: records with current year
    ... In the criteria put: ... Jerry Whittle, Microsoft Access MVP ... Keith Bontrager - Bicycle Builder. ... "aubrey" wrote: ...
    (microsoft.public.access.queries)
  • Re: Need HELP with Custom Dialog query
    ... look at the SQL of your query. ... Doug Steele, Microsoft Access MVP ... criteria and on the next line put the OR. ...
    (microsoft.public.access.queries)
  • RE: Type mismatch in a criteria that used to work
    ... Jerry Whittle, Microsoft Access MVP ... "RobD" wrote: ... fails no matter what I put in it. ... Now, if I try to criteria against this output, I get a type mismatch. ...
    (microsoft.public.access.queries)