Hello everyone
My problem is i am using a crosstab query in access,
here is my scenario
i am letting user to enter a date and the output should be the successive 3 months amount. say if i enter 4/1/07 then i should get
AprAmt MayAmt JuneAmt
------------------------------------------------
instead i am getting output as
JanAmt FebAmt MarAmt AprAmt MayAmt JunAmt .......DecAmt
----------------------------------------------------------------------------------------------------
How can i avoid the empty columns which a user dont care about.
(I am using the Crosstab query)