Query gives no results when using [enter] in one of the Criteria field

[bendixen]

I am running into a problem where the query gives no results when I have [enter budget reference] in the Criteria but if I hard code the same information into the Criteria line the results are produced. I'm trying to create a pop-up box so the user doesn't have to go into the query itself to change variables. All the other criteria pieces of the query work fine. Anyone understand why it's doing this and how to fix it? Thanks.

Here's the sql code...

SELECT GL_GL_DTL.ACCTG_PRD, GL_GL_DTL.ACCTG_FISC_YR, GL_GL_DTL.GL_GRANT_PGM_ELEM_CD, GL_GL_DTL.BUDGET_REF
FROM GL_GL_DTL
WHERE (((GL_GL_DTL.ACCTG_PRD)=[enter accting prd]) AND ((GL_GL_DTL.ACCTG_FISC_YR)=[enter yr]) AND ((GL_GL_DTL.GL_GRANT_PGM_ELEM_CD)=[enter program #]) AND ((GL_GL_DTL.BUDGET_REF)=[enter budget reference]));

 

[dinger2121]

did you try using only one variable at a time so that you could determine which one was causing the problem? I would start by doing that.

 

[bendixen]

I did that. I'm thinking it must be something with the field in the table. I created another query with just this field and get the same problem.

 

[GingerR]

What is some of your data? What are you entering when prompted by the query?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[dhookom]

faq701-6763

Duane MS Access MVP
Now help me support United Cerebral Palsy

 

[PHV]

...
WHERE (GL_GL_DTL.ACCTG_PRD=[enter accting prd] OR [enter accting prd] Is Null)
AND (GL_GL_DTL.ACCTG_FISC_YR=[enter yr] OR [enter yr] Is Null)
AND (GL_GL_DTL.GL_GRANT_PGM_ELEM_CD=[enter program #] OR [enter program #] Is Null)
AND (GL_GL_DTL.BUDGET_REF=[enter budget reference] OR [enter budget reference] Is Null);

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886