How to change the name of field in append query? 1

[Fekri]

Hi,


I have a crosstab query which made for each month a field to show the value.
So, depend of my data in which date, these fields od month will be changed.
For example, If I have a data for 2 month, only 2 field will add in crosstab query.

Now, the problem is: I want to append this crosstab query to a table which should filed name "01" append to table field "January" and ....

but I don't know how to make this append query to append any field with name "01" to "January" and "02" to "February" and ....


thanks
Ali

 

[dhookom]

Provide the SQL view of your crosstab query. Your column heading expression probably uses a date field derivation. It would help to know your expression.

Also, can you share the structure of the table you want to append to?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Fekri]

Thanks,

But the thing which I didn't tell before,

In my country calendar is different, So I have to made for each month number, the specific name.
It means for example: Month "01" to be "Farvardin" instead of "January".

So can you tell me how this convert can be done by me.
Thanks
Ali

 

[dhookom]

We still don't know how "01" is derived. To get the Month name of a date, use something like Format([DateField],"mmmm"). If you don't like the result of this expression you can create a small lookup table that looks up your value to return the value you want.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Fekri]

Mmmmmmmmmmmmmm,


Nice Idea ,


Thanks
Ali