Query parameters in a report

Is it possible to have two parameters in a query, where they pull the entered information together
i.e.information within a certain date and for a certain client for that Date.

Also be able to select null values in either or, or each parameter and retrieve all the information for all clients over all dates.

Create a Blankform in design mode and put 3 textboxes on it
set the nameproperty of first textbox to txtclient, secondtextbox to txtbegindate and name third one as txtenddate. set the format property of the txtbegindate and txtenddate text box to short date. Now open your form and enter data intoit and you can runyour query based on the form like
select datefield, client..etc
from table
where client Like [forms]![formname]![clienttextboxname] and datefield between [forms]![formname]![Begindate] and
dateadd("s",86399,[forms]![formname]![Enddate])

If you enter * in the client field and single date in begindate and enddate textbox you will get all client for singledate. if you enter client name you can get it for single client.
If you enter the minimum of date in your data in begindate and maximum of date in end date you can retrieve data for all period.

Hi, I tried this using the Like statement, but it won't return data for a date and client search, nor will it return data for just a date search.


HAVING (((Clients.CompanyName) Like [Forms]![Report Date Range]![Client] & "*"))AND ((([Time Card Hours].DateWorked) Like [Forms]![Report Date Range]![BeginDate] & "*" And ([Time Card Hours].DateWorked) Like [Forms]![Report Date Range]![EndDate] & "*"));

My form has three textboxes 1. BeginDate 2.EndDate 3.Client

I want to be able to do the following by just using the form to pull a report generated by the information entered.

a) Enter [Client] name, enter [BeginDate], enter [EndDate]
View a Clients info between the dates entered in the BeginDate and EndDate tectBoxes

b) Leave [Clients] blank, enter [BeginDate], enter [EndDate]
View all clients info btw'n the dates entered if [client] is left Null.

c) Leave [Clients], [BeginDate], [EndDate] empty.
View all clients if dates and [client] are left Null

d) Enter [Clients], leave [BeginDate] and [EndDate] empty
View all of entered clients info, irrespective of date.

Is it possible to retrieve the information I have outlined above using sql or would I be better using VB (not very good at VB)
I hope someone can Help.

Just try the attached MDB where in I have included some sample data and a form and report to answer your query.
Both version of MDB 97 and 2000 is included in zipformat.
Hope this works for your requirement.

I can't believe you did that, thats amazing, I can't thank you enough for taking the time and effort out of your busy day to do what you did for my not so intelligent ***. I really appreciate it, and if anything I have learned form your example.

Thanks again, It good to know there are truly great people out there.