G
Guest
Tp pull a monthly report I have under criteria of Query: "Between
[BeginningDate] And [EndingDate]". When Prompted I can enter Beginning, then
End Date. I would like to also include an option where I can leave the
beginning date blank and End date blank to pull all records. I have a
similar Query that pulls all parts of CLient Names: Like "*" & [Enter Client
Name, Leave Blank for All] & "*".... When I am trying to get this to work for
my dates, I either Pull All records no matter the date ranges I enter, Or, I
pull no records....
I would also like to know if I can prompt it to ONLY enter a month, Jan or
01 for January. Currently the Date is default date (), formated
(01/31/2007).
[BeginningDate] And [EndingDate]". When Prompted I can enter Beginning, then
End Date. I would like to also include an option where I can leave the
beginning date blank and End date blank to pull all records. I have a
similar Query that pulls all parts of CLient Names: Like "*" & [Enter Client
Name, Leave Blank for All] & "*".... When I am trying to get this to work for
my dates, I either Pull All records no matter the date ranges I enter, Or, I
pull no records....
I would also like to know if I can prompt it to ONLY enter a month, Jan or
01 for January. Currently the Date is default date (), formated
(01/31/2007).