I
Irshad Alam
I have table Named OutStationTab having the data as below field
EName - Text Field
OsDate - Date Field
OsAmt - Numeric field
I want to make a cross tab query in which
RowHeading- EName
Column Heading- Expr1: Format([OsDate],"dd-mm-yyyy")
Value- OsAmt
Note the data is entered from 15th Date of a month to 14th date of next
month. One Employee take 1 outstation charges only in a day.
I am able to make the crosstab query and its working perfect. Like I filter
the query (From 15-02-2010 to 14-03-2010), then made the CrossTab
query. It works perfect.
It does not display the date on colum in which no one is on outstation.
BUT my requirement is that to display like all the day like - 15/02 16/02
17/02 till.....14/03 . It should NOT miss any day inbetween the
period.
Please advise method to do above, so that all the date inbetween the start
and end date should display.
And also how to handle report. As the month changes and date count/column
also changes (like decrease/increase)
Regards
Irshad
EName - Text Field
OsDate - Date Field
OsAmt - Numeric field
I want to make a cross tab query in which
RowHeading- EName
Column Heading- Expr1: Format([OsDate],"dd-mm-yyyy")
Value- OsAmt
Note the data is entered from 15th Date of a month to 14th date of next
month. One Employee take 1 outstation charges only in a day.
I am able to make the crosstab query and its working perfect. Like I filter
the query (From 15-02-2010 to 14-03-2010), then made the CrossTab
query. It works perfect.
It does not display the date on colum in which no one is on outstation.
BUT my requirement is that to display like all the day like - 15/02 16/02
17/02 till.....14/03 . It should NOT miss any day inbetween the
period.
Please advise method to do above, so that all the date inbetween the start
and end date should display.
And also how to handle report. As the month changes and date count/column
also changes (like decrease/increase)
Regards
Irshad