O
Oscar
I have a table that corresponds week ending dates with periods and
quarters tblPeriodDates. We do not use the dates in access because we
determine our own boundries for quarters (ie some week ending dates may
fall in a different quarter than the majority of the week so we want it
grouped in the previous quarter).
Anyway, I have a report I would like to calculate on a quarterly basis
and whenever I calculate it I would like it to ask me what quarter I
would like to see the data for. We have our tblPeriodDates formatted
so quarter 2 of 2006 would look like 2-06. So if I wanted to see
quarter 2 of 2006's results I would type in 2-06. However, since this
report is generated by many different queries and reports it asks me
what quarter about seven times and I have to type it in seven times.
Is there a way I can create a form or something that will send the 2-06
to all my queries so I only have to tell it once?
Thanks!
quarters tblPeriodDates. We do not use the dates in access because we
determine our own boundries for quarters (ie some week ending dates may
fall in a different quarter than the majority of the week so we want it
grouped in the previous quarter).
Anyway, I have a report I would like to calculate on a quarterly basis
and whenever I calculate it I would like it to ask me what quarter I
would like to see the data for. We have our tblPeriodDates formatted
so quarter 2 of 2006 would look like 2-06. So if I wanted to see
quarter 2 of 2006's results I would type in 2-06. However, since this
report is generated by many different queries and reports it asks me
what quarter about seven times and I have to type it in seven times.
Is there a way I can create a form or something that will send the 2-06
to all my queries so I only have to tell it once?
Thanks!