Changing a textbox source (1 Viewer)

[lipin]

I have a crosstab query and a make table query that runs off the crosstab. It is run to show the daily data for a week at a time. The user enters start date and end date on the crosstab.

I need a report off the table made with the 2nd query that shows each days data. The column names change each time the query is ran, because the dates change with each run.

How do I get textboxs on the report to reference the new dates? Have looked at other posts on dynamic controlsource for textboxes and looked at sample database but still don't understand the sytax.

The column names are changing with each run- how do you set the report to be dynamic as well?

 

[uncle-lai]

See if you can get any idea from this sample.

Here is a link to some information that might help too:

http://support.microsoft.com/default.aspx?scid=kb;en-us;210004


Peter

 

[yessir]

how did you make the report in that sample?

 

[uncle-lai]

Basically it's a report that displays records in columns, group by [Color]. For the Headings I used a sub-report that draws the [Size]'s, which also displayed in columns, and I placed the sub-report on a position that matched the columns in the main report. All queries are simple select queries.

Peter