Picture this in MS Access:
I have a form that you input your criteria. The user puts a whole number like 5, but in my query criteria, I have a less than symbol in front of the request because they need the days to be less than. To answer some pre-thought questions I thought you might have, if you put the symbol in the dialog box, it does not work there either. I get data, but it is showing me everything as if ignoring the less than symbol. If I hardcode the less than symbol with a whole number, then it gives me correct data. I want my data to show me my whole number less than or equal too in my dynamic report.
(Sorry in advance for my 'all-over-the-place' question/comment. But that is how my brain is assimilating this issue)
I have a form that you input your criteria. The user puts a whole number like 5, but in my query criteria, I have a less than symbol in front of the request because they need the days to be less than. To answer some pre-thought questions I thought you might have, if you put the symbol in the dialog box, it does not work there either. I get data, but it is showing me everything as if ignoring the less than symbol. If I hardcode the less than symbol with a whole number, then it gives me correct data. I want my data to show me my whole number less than or equal too in my dynamic report.
(Sorry in advance for my 'all-over-the-place' question/comment. But that is how my brain is assimilating this issue)
Comment