next dates in report

[adi32]

I have a report with a query and I want to give a date and in the report I want to have fields like headings with the next 10 days
Ex I give 1/1/04
And in the report I want to have
1/1/04 2/1/04………….10/1/04
I tried to add fields like [date]+1 [date]+2……. But it doesn’t work

 

[ColinEssex]

Might be way off here but can't you do this in a crosstab query?

Col

 

[Loolaa]

try using VBA, I know that this works


Private Sub PageHeaderSection_Print(Cancel As Integer, PrintCount As Integer)

Dim DateVar As Date

DateVar = InputBox("Enter Date")

Me!Text1 = DateVar
Me!Text2 = DateVar + 1
Me!Text3 = DateVar + 2
Me!Text4 = DateVar + 3

End Sub

L

 

[adi32]

ok thank you