Question Locked

How do I create fieldnames from a Date in a View

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have five fields in a select statement;
Machine, JobNo, Customer, JobStartDate, JobFinishDate.

I wish to add more columns to the result showing the days (CurrentDate-7) to (CurrentDate + 60) as columns with the actual date as the caption of the column, formatted as 'dd/mm/yyyy' (Australian); in order to show an indicator if the job is active on that day...
e.g.
Mc, Job, Customer, Start, Finish, 23/03/2010, 24/03/2010, 25/03/2010...
M4322, HN01110, Delta Mining, 24/03/2010, 29/10/2010,_,*,*,...

Any and all help would be gratefully received.

2 replies

by tony hopkinson

crosstab is what you want to look up.

Me I'd try to find a way not to have do this.

This discussion is closed to new replies.