M
Melo
Hi!
I've created a query that is based on a couple of tables. They are linked
together with simple join links.
I would like insert in my query a colomn "Financial_period" wich comes from
a Financial_period_calendar table.
The structure looks like this:
Start_date (date type)
End_date (date type)
Financial_Period (number)
In my main table, I have a field called "activity_date" and I would like to
add to my report in what Financial_period that
activity has occured... I know I could use a temporary table, but was
wondering if there was anyway I could do it in one
single step?
Thanks for your help!
Mel
I've created a query that is based on a couple of tables. They are linked
together with simple join links.
I would like insert in my query a colomn "Financial_period" wich comes from
a Financial_period_calendar table.
The structure looks like this:
Start_date (date type)
End_date (date type)
Financial_Period (number)
In my main table, I have a field called "activity_date" and I would like to
add to my report in what Financial_period that
activity has occured... I know I could use a temporary table, but was
wondering if there was anyway I could do it in one
single step?
Thanks for your help!
Mel