how to name field to include a date range...

[susan]

i created a query to calculate the $ variance between 2 run dates - i got the
results i wanted but i want to name the column heading to include the run
dates...

here's the variance calculation in my query:
ACT/FCST Variance: [3 - qry_second run date_Total ACT/FCST]-[2 - qry_first
run date_Total ACT/FCST]

3 - qry_second run date_Total ACT/FCST: this gives the Total ACT/FCST #
from the query that pull second run date
2 - qry_first run date_Total ACT/FCST: from first run date

my end result shows title of "ACT/FCST Variance" like i named it BUT i want
it to include the first and second run dates...so for example if i am running
data between 5/1/08 and 4/1/08...i want the title to show "ACT/FCST Variance
5/1/08 and 4/1/08" (or whatever 2 other dates I am using). how can i do that?

is this possible? please help!!!
THANKS,
susan

 

[John Spencer]

I know of no way to change field names in a query on the fly. Where would you
get the run dates anyway?

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

 

[susan]

The run dates are already in my source table, when i run the query, i have a
parameter set up to ask for the 2 dates.

I know of no way to change field names in a query on the fly. Where would you
get the run dates anyway?

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

i created a query to calculate the $ variance between 2 run dates - i got the
results i wanted but i want to name the column heading to include the run
dates...

here's the variance calculation in my query:
ACT/FCST Variance: [3 - qry_second run date_Total ACT/FCST]-[2 - qry_first
run date_Total ACT/FCST]

3 - qry_second run date_Total ACT/FCST: this gives the Total ACT/FCST #
from the query that pull second run date
2 - qry_first run date_Total ACT/FCST: from first run date

my end result shows title of "ACT/FCST Variance" like i named it BUT i want
it to include the first and second run dates...so for example if i am running
data between 5/1/08 and 4/1/08...i want the title to show "ACT/FCST Variance
5/1/08 and 4/1/08" (or whatever 2 other dates I am using). how can i do that?

is this possible? please help!!!
THANKS,
susan

 

[John Spencer]

Depending on the query (you didn't post it), you should be able to add the
parameters to the SELECT clause and see them as field results.

SELECT [Enter End Date], RunDate
FROM SomeTable
WHERE RunDate = [Enter End Date]

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

The run dates are already in my source table, when i run the query, i have a
parameter set up to ask for the 2 dates.

I know of no way to change field names in a query on the fly. Where would you
get the run dates anyway?

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

i created a query to calculate the $ variance between 2 run dates - i got the
results i wanted but i want to name the column heading to include the run
dates...

here's the variance calculation in my query:
ACT/FCST Variance: [3 - qry_second run date_Total ACT/FCST]-[2 - qry_first
run date_Total ACT/FCST]

3 - qry_second run date_Total ACT/FCST: this gives the Total ACT/FCST #
from the query that pull second run date
2 - qry_first run date_Total ACT/FCST: from first run date

my end result shows title of "ACT/FCST Variance" like i named it BUT i want
it to include the first and second run dates...so for example if i am running
data between 5/1/08 and 4/1/08...i want the title to show "ACT/FCST Variance
5/1/08 and 4/1/08" (or whatever 2 other dates I am using). how can i do that?

is this possible? please help!!!
THANKS,
susan

 

[John W. Vinson]

i want to name the column heading to include the run
dates...

Don't confuse data STORAGE with data PRESENTATION.

You can use textboxes in the header of a Report with control sources like

=[Enter start date:]

using whatever you have used as a parameter for your query. It is not
necessary or appropriate to set the fieldnames of a query for this purpose.