Cross tab Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am want to create a cross tab query which will output the data for only
three months starting from the current month. I would want these months to be
headings of the report/query. However, I don't want to create reports over
and over again. I want something, that will resolve the issue through
parameters kinda thing. I don't know, if this can be done or not. Right now I
have the cross tab query for all the months, but I have to manually choose
the months to fit in the page. I hope I am making sense here.

Thanx in adv.
 
Most folks use three month that are LastMonth, TwoMonthsAgo, and
ThreeMonthsAgo because you rarely get a good picture in the middle of the
month.

To get the three months --
Current Month: Date()-Day(Date())
Last Month: [Current Month]-Day([Current Month])
Two Months Ago: [Last Month]-Day([Last Month])
 
Karl,

Thanx for the response. But, I don't think that will help. As I want the
query to get the numbers from coming up months. Because, I am dealing with
loan application, where they will approve in coming up months with the amount
the department has to deal with in those months.

--
depending on perspective, everything is beautiful!!!


KARL DEWEY said:
Most folks use three month that are LastMonth, TwoMonthsAgo, and
ThreeMonthsAgo because you rarely get a good picture in the middle of the
month.

To get the three months --
Current Month: Date()-Day(Date())
Last Month: [Current Month]-Day([Current Month])
Two Months Ago: [Last Month]-Day([Last Month])

wannabepro said:
I am want to create a cross tab query which will output the data for only
three months starting from the current month. I would want these months to be
headings of the report/query. However, I don't want to create reports over
and over again. I want something, that will resolve the issue through
parameters kinda thing. I don't know, if this can be done or not. Right now I
have the cross tab query for all the months, but I have to manually choose
the months to fit in the page. I hope I am making sense here.

Thanx in adv.
Click to expand...
Click to expand...
 
Ok, this SQL will do it.
SELECT Date()-Day(Date())+1 AS [This Month], DateAdd("m",1,[This Month]) AS
[Next Month], DateAdd("m",1,[Next Month]) AS [Third Month]

wannabepro said:
Karl,

Thanx for the response. But, I don't think that will help. As I want the
query to get the numbers from coming up months. Because, I am dealing with
loan application, where they will approve in coming up months with the amount
the department has to deal with in those months.

--
depending on perspective, everything is beautiful!!!


KARL DEWEY said:
Most folks use three month that are LastMonth, TwoMonthsAgo, and
ThreeMonthsAgo because you rarely get a good picture in the middle of the
month.

To get the three months --
Current Month: Date()-Day(Date())
Last Month: [Current Month]-Day([Current Month])
Two Months Ago: [Last Month]-Day([Last Month])

wannabepro said:
I am want to create a cross tab query which will output the data for only
three months starting from the current month. I would want these months to be
headings of the report/query. However, I don't want to create reports over
and over again. I want something, that will resolve the issue through
parameters kinda thing. I don't know, if this can be done or not. Right now I
have the cross tab query for all the months, but I have to manually choose
the months to fit in the page. I hope I am making sense here.

Thanx in adv.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top