Dear All,
I've seen a QbF query that is active but the TS has a different question so I don't want to derail his thread, so apologies if I make another thread regarding QbF.
Anyway, here's my problem.
I have a query with a column that returns number of days per record. Using a form, I can query the records which has a specific number of days as based on my control field (i.e, all records that have "6" days). However, What I want to do now is to call records that fall within a range of number of days (i.e. all records that have "6 to 14" days).
I can do such in a query using >=6 AND <=14 in the query design view, but I tried using this in the form control and it does not work (or probably I missed something out).
Any thoughts or even best practice in calling data ranges using form control?
I've seen a QbF query that is active but the TS has a different question so I don't want to derail his thread, so apologies if I make another thread regarding QbF.
Anyway, here's my problem.
I have a query with a column that returns number of days per record. Using a form, I can query the records which has a specific number of days as based on my control field (i.e, all records that have "6" days). However, What I want to do now is to call records that fall within a range of number of days (i.e. all records that have "6 to 14" days).
I can do such in a query using >=6 AND <=14 in the query design view, but I tried using this in the form control and it does not work (or probably I missed something out).
Any thoughts or even best practice in calling data ranges using form control?