date qry to match other date qry (1 Viewer)

J

jedder18

Just Livin the Dream!

Local time

Today, 14:28

Joined

Mar 28, 2012

Messages

135

• Nov 3, 2014

• #1

running 3 queries together

1 qry has a date parameter of start/end date(running before the 3 are together)

Have a field in 1 of the 3 queries with a date field that I need to show being <= the date parameter...

How/where do I use this criteria?

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 14:28

Joined

Aug 30, 2003

Messages

36,124

• Nov 3, 2014

• #2

I would have the user enter the dates on a form, and have the queries get their needed parameters from there.

 

J

jedder18

Just Livin the Dream!

Local time

Today, 14:28

Joined

Mar 28, 2012

Messages

135

• Nov 13, 2014

• #3

this is to end up on a report...the dates are already entered in a form..they need to match on the report

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 14:28

Joined

Aug 30, 2003

Messages

36,124

• Nov 13, 2014

• #4

Then I'm not sure I understand the question. A criteria of:

<=Forms!FormName.TextboxName

should work.