I have a query that already goes out and retrieves a set phones by organization code but I'm looking at adding to the query so the user can select a date range to search by and need the code for this if someone can help.
The query (as it is right now) follows:
SELECT tblBilling2004.CustID, tblBilling2004.[CustCompany], tblBilling2004.BillingCode, tblBilling2004.SerialNumber, tblBilling2004.MobileNumbers, tblBilling2004.[Date of Call], tblBilling2004.[Time of Call], tblBilling2004.Duration, tblBilling2004.[Rate/Min], tblBilling2004.[Total Cost of Call]
WHERE (((tblBilling2004.BillingCode) Like ("B*") Or tblBilling2004.BillingCode) Like ("P*")))
ORDER BY tblBilling2004.BillingCode;
I Have another query that allows the user to select a serial number to search for but wasn't sure how to do a user selected date range. That code is:
WHERE MobileNumber Like "*" & [Enter PhoneNumer] & "*";
Looking for something that allows the users to enter a date range such as: