I have a query and im using between [Start} and [end] for my criteria giving the user a parameter to enter the dates they choose.
im using a field called datesubmitted and if anything is submitted on 1st of month or last day of month it wont pull into query.
so if i put 4-1-11 and 4-30-11 as dates i get 4-2-11 and 4-29-11
any help would be great.
im using a field called datesubmitted and if anything is submitted on 1st of month or last day of month it wont pull into query.
so if i put 4-1-11 and 4-30-11 as dates i get 4-2-11 and 4-29-11
any help would be great.