View Crosstab Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a crosstab query to show the last 12 weeks of transactions and I want to display it on a form. However, each week the field names will change so if I create the form with this weeks data it's OK but next week I'll get Name? in the oldest weeks field and the latest weeks data is missing. How can I create the form so it doesn't care what the field names are? I'm sure I'm missing something but I just can't figure out how to do this. Can anyone help?

Thanks

Karen
 
Karen,

You need to permanenetly name the columns to Week1, Week2,
etc. in the query and the form. Then just change the
labels on the form to indicate the actual weeks.
-----Original Message-----
I've created a crosstab query to show the last 12 weeks
Click to expand...
of transactions and I want to display it on a form.
However, each week the field names will change so if I
create the form with this weeks data it's OK but next week
I'll get Name? in the oldest weeks field and the latest
weeks data is missing. How can I create the form so it
doesn't care what the field names are? I'm sure I'm
missing something but I just can't figure out how to do
this. Can anyone help?
 
Thanks John. I was beginning to think that was the answer but hoping not. I've got fixed field names for my query now. Any suggestions on the best way of renaming labels with the week number

Karen
 
Forms!YourFormName!Label1 = StartingWeekNumber
Forms!YourFormName!Label2 = StartingWeekNumber + 1
Forms!YourFormName!Label3 = StartingWeekNumber + 2
etc.
Put it in the Form_Load procedure
-----Original Message-----
Thanks John. I was beginning to think that was the
Click to expand...
answer but hoping not. I've got fixed field names for my
query now. Any suggestions on the best way of renaming
labels with the week number?
 
Back
Top