4 parameters and the query return no records!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query with 4 fields. Each of these fields as a criteria value. All of these criteria values are ok. (the right data type!) My query gets the data from only one table. (really simple!) The primary index of this table is the combination of these 4 fields. I have only 1 record in the table corresponding to the 4 selection criterias

Problem:
If I have 4 selection criterias (a,b,c,d) entered in the query, I've got no records returned from the query! WRON
If I remove 1 of these 4 selection criterias (whatever the fields) I've got records!!

If I change the index of my table to something else, it works fine with all my 4 parameters!

I have installed Jet database engine 4.0 SP8 & MDAC 2.8 and it doesn't change a think

Please Help

THANKS!!!
 
What is your query specifically? What are the four fieds? What criteria
are you entering?

Are you entering the criteria all on one line in the query builder (and
statement) or are you entering one criteria on each line (or statement).
This will make a difference in how the data is evaluated.

Give us more details.



Simon said:
I have a query with 4 fields. Each of these fields as a criteria value.
Click to expand...
All of these criteria values are ok. (the right data type!) My query gets
the data from only one table. (really simple!) The primary index of this
table is the combination of these 4 fields. I have only 1 record in the
table corresponding to the 4 selection criterias.
Problem:
If I have 4 selection criterias (a,b,c,d) entered in the query, I've got
Click to expand...
no records returned from the query! WRONG
 
Back
Top