B
BlueWolverine
Hello,
MS ACCESS 2003 on XP Pro.
I have a question regarding either form or report design, I am not sure
which is more appropriate for what I am doing.
(I wrote a really complicated macro in Excel to do this but I think Access
can do it with less code and much faster)
Here it goes:
I need a printable to PDF document that looks like this.
--------------------------------
| Heading for PAge1 only|
--------------------------------
--------------------------------
| Category 1 |
--------------------------------
Record1
Record2
Record3
Record4
RecordN
--------------------------------
|Category 2 |
--------------------------------
Record N+1
Record N+2
Record N+M
Etc.
The idea is that a Category has a group of records that go with it.
I don't really want to change the format of the document, because the
easiest way I thought to do it is.
Record1|Cat|ID1|ID2|ID3|ID4
Record2|Cat|ID1|ID2|ID3|ID4
RecordX|Cat|ID1|ID2|ID3|ID4
etc where the Category repeats, but this changes the format, which is
already in use, and I am just trying to streamline.
Any ideas? By all means request clarifications.
Thank you so much.
MS ACCESS 2003 on XP Pro.
I have a question regarding either form or report design, I am not sure
which is more appropriate for what I am doing.
(I wrote a really complicated macro in Excel to do this but I think Access
can do it with less code and much faster)
Here it goes:
I need a printable to PDF document that looks like this.
--------------------------------
| Heading for PAge1 only|
--------------------------------
--------------------------------
| Category 1 |
--------------------------------
Record1
Record2
Record3
Record4
RecordN
--------------------------------
|Category 2 |
--------------------------------
Record N+1
Record N+2
Record N+M
Etc.
The idea is that a Category has a group of records that go with it.
I don't really want to change the format of the document, because the
easiest way I thought to do it is.
Record1|Cat|ID1|ID2|ID3|ID4
Record2|Cat|ID1|ID2|ID3|ID4
RecordX|Cat|ID1|ID2|ID3|ID4
etc where the Category repeats, but this changes the format, which is
already in use, and I am just trying to streamline.
Any ideas? By all means request clarifications.
Thank you so much.