R
Robert_L_Ross
I have a form with a StartDate and EndDate (formatted to Short Date).
In my query, I want to query for records that are 'valid' per the dates on
my form.
If the StartDate is left empty and the EndDate is present, I should get all
records with end dates <= the EndDate.
If the StartDate is present and the EndDate is left empty, I should get all
records with start dates >= StartDate.
Obviously, if boht dates are present I should get records with start date
If both StartDate and EndDate are left empty, I should get all records.
I can get these scenarios to work independently, but I can't seem to get
them to work all at the same time. Add to this problem that I'm also using a
method to check other fields.
Any ideas?
In my query, I want to query for records that are 'valid' per the dates on
my form.
If the StartDate is left empty and the EndDate is present, I should get all
records with end dates <= the EndDate.
If the StartDate is present and the EndDate is left empty, I should get all
records with start dates >= StartDate.
Obviously, if boht dates are present I should get records with start date
=StartDate and end date <=EndDate.
If both StartDate and EndDate are left empty, I should get all records.
I can get these scenarios to work independently, but I can't seem to get
them to work all at the same time. Add to this problem that I'm also using a
method to check other fields.
Any ideas?