Help to design a report.

  • Thread starter Thread starter TA
  • Start date Start date
T

TA

Dear all,
I am too new with Access2K and coding for VBA so I need
your help. I need to do a report yearly for all agency
from Agency#050 to Agency#900 and by monthly from Jan. to
Dec. for the year from 2000 to the future (like this year
2003)
I need pull out all info. to 1 page of report like below:

Report all Agency for the Year 2002
Agency Jan. Feb. Mar. ... Nov. Dec.
050 10 2 9 20
100 15 8 5 19
....
850 56 5 78 82 11
900 1 43 12 61 37

How to I write a code in VBA? like assign var ?
Thank you all for your help,
TA
 
It would really help to know how your data is stored. I suggest you use a
crosstab query that has
Row Headings of
Year([DateField])
Agency
Column Heading
Format([DateField], "mmm")
Value
Sum or Count or whatever of whatever field
 
Hi Duane,
Data I stored in SQL2K server, using Access2K link to it.
All of data stored with char. field. How to I initial var.
in order to call to print the report? I am trying to do
crosstab query right now as your sugession.
Again, thank you.
Best Regards,
TA
-----Original Message-----
It would really help to know how your data is stored. I suggest you use a
crosstab query that has
Row Headings of
Year([DateField])
Agency
Column Heading
Format([DateField], "mmm")
Value
Sum or Count or whatever of whatever field

--
Duane Hookom
MS Access MVP


TA said:
Dear all,
I am too new with Access2K and coding for VBA so I need
your help. I need to do a report yearly for all agency
from Agency#050 to Agency#900 and by monthly from Jan. to
Dec. for the year from 2000 to the future (like this year
2003)
I need pull out all info. to 1 page of report like below:

Report all Agency for the Year 2002
Agency Jan. Feb. Mar. ... Nov. Dec.
050 10 2 9 20
100 15 8 5 19
...
850 56 5 78 82 11
900 1 43 12 61 37

How to I write a code in VBA? like assign var ?
Thank you all for your help,
TA
Click to expand...


.
Click to expand...
 
Come on back after you have the crosstab query created or if you are having
trouble with this. Are you saying your date field is not a date/time field?
If it is a character field, you may need to convert it to a date type.

--
Duane Hookom
MS Access MVP


TA said:
Hi Duane,
Data I stored in SQL2K server, using Access2K link to it.
All of data stored with char. field. How to I initial var.
in order to call to print the report? I am trying to do
crosstab query right now as your sugession.
Again, thank you.
Best Regards,
TA
-----Original Message-----
It would really help to know how your data is stored. I suggest you use a
crosstab query that has
Row Headings of
Year([DateField])
Agency
Column Heading
Format([DateField], "mmm")
Value
Sum or Count or whatever of whatever field

--
Duane Hookom
MS Access MVP


TA said:
Dear all,
I am too new with Access2K and coding for VBA so I need
your help. I need to do a report yearly for all agency
from Agency#050 to Agency#900 and by monthly from Jan. to
Dec. for the year from 2000 to the future (like this year
2003)
I need pull out all info. to 1 page of report like below:

Report all Agency for the Year 2002
Agency Jan. Feb. Mar. ... Nov. Dec.
050 10 2 9 20
100 15 8 5 19
...
850 56 5 78 82 11
900 1 43 12 61 37

How to I write a code in VBA? like assign var ?
Thank you all for your help,
TA
Click to expand...


.
Click to expand...
Click to expand...
 
Hi Duane,
I am done with query report as you sugession.
It is perfect. Again thank you very much. I own you a
lunch !:)
TA
-----Original Message-----
Come on back after you have the crosstab query created or if you are having
trouble with this. Are you saying your date field is not a date/time field?
If it is a character field, you may need to convert it to a date type.

--
Duane Hookom
MS Access MVP


TA said:
Hi Duane,
Data I stored in SQL2K server, using Access2K link to it.
All of data stored with char. field. How to I initial var.
in order to call to print the report? I am trying to do
crosstab query right now as your sugession.
Again, thank you.
Best Regards,
TA
-----Original Message-----
It would really help to know how your data is stored. I suggest you use a
crosstab query that has
Row Headings of
Year([DateField])
Agency
Column Heading
Format([DateField], "mmm")
Value
Sum or Count or whatever of whatever field

--
Duane Hookom
MS Access MVP


Dear all,
I am too new with Access2K and coding for VBA so I need
your help. I need to do a report yearly for all agency
from Agency#050 to Agency#900 and by monthly from
Click to expand...
Jan.
to
Dec. for the year from 2000 to the future (like this year
2003)
I need pull out all info. to 1 page of report like below:

Report all Agency for the Year 2002
Agency Jan. Feb. Mar. ... Nov. Dec.
050 10 2 9 20
100 15 8 5 19
...
850 56 5 78 82 11
900 1 43 12 61 37

How to I write a code in VBA? like assign var ?
Thank you all for your help,
TA


.
Click to expand...
Click to expand...


.
Click to expand...
 
Low carb please...

--
Duane Hookom
MS Access MVP


TA said:
Hi Duane,
I am done with query report as you sugession.
It is perfect. Again thank you very much. I own you a
lunch !:)
TA
-----Original Message-----
Come on back after you have the crosstab query created or if you are having
trouble with this. Are you saying your date field is not a date/time field?
If it is a character field, you may need to convert it to a date type.

--
Duane Hookom
MS Access MVP


TA said:
Hi Duane,
Data I stored in SQL2K server, using Access2K link to it.
All of data stored with char. field. How to I initial var.
in order to call to print the report? I am trying to do
crosstab query right now as your sugession.
Again, thank you.
Best Regards,
TA
-----Original Message-----
It would really help to know how your data is stored. I
suggest you use a
crosstab query that has
Row Headings of
Year([DateField])
Agency
Column Heading
Format([DateField], "mmm")
Value
Sum or Count or whatever of whatever field

--
Duane Hookom
MS Access MVP


Dear all,
I am too new with Access2K and coding for VBA so I need
your help. I need to do a report yearly for all agency
from Agency#050 to Agency#900 and by monthly from Jan.
to
Dec. for the year from 2000 to the future (like this
year
2003)
I need pull out all info. to 1 page of report like
below:

Report all Agency for the Year 2002
Agency Jan. Feb. Mar. ... Nov. Dec.
050 10 2 9 20
100 15 8 5 19
...
850 56 5 78 82 11
900 1 43 12 61 37

How to I write a code in VBA? like assign var ?
Thank you all for your help,
TA


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top