dominicdunmow
Technical User
Hi there,
I receive a monthly flat file xls - formatted as below:-
Customer Time Value
A Q42005 £1000
A Q22006 £2000
B Q12006 £500
B Q42006 £3000
I have a crosstab query which converts this into a spreadsheet format as below.
Customer Q42005 Q12006 Q22006 Q42006
A £1000 £2000
B £500 £3000
My problem is that I need to get this into a form showing 1 customer at a time so that others can enter a resource figure against order (which is the straight forward bit)
The difficulty occurs as the flat file has different orders each month in different time periods, so the time field headings in the form will be different each time.
Is there a solution to create the form "on the fly" each time?
Thanks
Dominic
I receive a monthly flat file xls - formatted as below:-
Customer Time Value
A Q42005 £1000
A Q22006 £2000
B Q12006 £500
B Q42006 £3000
I have a crosstab query which converts this into a spreadsheet format as below.
Customer Q42005 Q12006 Q22006 Q42006
A £1000 £2000
B £500 £3000
My problem is that I need to get this into a form showing 1 customer at a time so that others can enter a resource figure against order (which is the straight forward bit)
The difficulty occurs as the flat file has different orders each month in different time periods, so the time field headings in the form will be different each time.
Is there a solution to create the form "on the fly" each time?
Thanks
Dominic