By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,521 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,521 IT Pros & Developers. It's quick & easy.

User input criteria with a hard coded symbol

P: 1
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)
Jun 3 '15 #1
Share this Question
Share on Google+
1 Reply


Seth Schrock
Expert 2.5K+
P: 2,951
We need to see what you have tried. Then we can help tweak what you have. Please include the event that triggers your code. And please use CODE tags (the [CODE/] button in the header of your reply box).
Jun 3 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.