How do I merge two Queries into one?

[tmartin]

Each of these word independently but want to combine them into whereis field into one



DoCmd.OpenForm "TransactionsForm", acNormal, "Query4Search", "[EmployeeID]=[Forms]![LoginForm]![cboUser]", acReadOnly, acNormal

DoCmd.OpenForm "TransactionsForm", acNormal, "Query4Search", "[Date] >= #" & Me.StartDate & "# AND [Date] <= #" & Me.EndDate & "#", acReadOnly, acNormal

Your help would be greatly appreciated
Tom

[orange]

You could review the info at this link and see if it helps.
Create your where clause with multiple criteria. Similar to his sWhere clause

(untested)

 Dim sWhere as string
sWhere =  "[EmployeeID]= " & [Forms]![LoginForm]![cboUser]  _
 & " AND  [Date] Between #" & Me.StartDate & "# AND   #" & Me.EndDate & "#"

[tmartin]

It worked great!
I also have another requirement to do a query for today's and 3 months of transactions. I looked at the Duration: DateDiff("d",[Date],Date())
I was trying to combine the EmployeeID with the DateDIff function to provide the output that I need. Can you give some insight on how you would approach it?
THanks again

Each of these word independently but want to combine them into whereis field into one

DoCmd.OpenForm "TransactionsForm", acNormal, "Query4Search", "[EmployeeID]=[Forms]![LoginForm]![cboUser]", acReadOnly, acNormal

DoCmd.OpenForm "TransactionsForm", acNormal, "Query4Search", "[Date] >= #" & Me.StartDate & "# AND [Date] <= #" & Me.EndDate & "#", acReadOnly, acNormal

Your help would be greatly appreciated
Tom

[orange]

You have the EmployeeID part and a generic method to deal with Dates.

So what exactly is the Date criteria. (Note: Date is a reserved word in access/vba)

Are you asking for >=Today and 90 days from today?
90 days from today is Date() + 90

or DateAdd("d",90,Date())
You should be able to use the previous answer to build a new sqlString.
see http://www.techonthenet.com/access/f...te/dateadd.php