Parameters in Joins

[Guest]

Hi Guys...

I am trying to use a parameter in an inner join, which as you probably know
is not possible (or at least it seems to me to be impossible).

For example, let's say I have access prompt the user for a date [EndDate],
and generate a make table query based upon this input. I would also like to
take this EndDate and, within the same statement, execute an inner join to
return an appropriate foreign exchange rate as at that date (for example).

Can anyone suggest how I might go about doing this?

Many thanks in advance!

David

 

[Duane Hookom]

Why can't you use the parameter? What SQL have you tried and what error or
unacceptable results did you get?

If you can't figure this out, you may need to share your table structures.