I am having difficulty preparing data for a report. Currently I have
a table with the following information:
Vendor, Year, Month
ABC Company, 05, JA
ABC Company, 05, FE
ABC Company, 05, AP
ABC Company, 05, JL
DEF Company, 05, JA
I want to create a report that has the vendor as the row data and the
months as the column data. Where there is a missing month there would
be a blank (or some other kind of indicator).
I tried to create another table to update and put all of the months
as a Y/n fields for each vendor, but have been unsuccessful. Now, I
think I could create queries for each month and then union the
queries together, but that seems to be a lot of work, suggesting that
there is an easier way.
I would appreciate any help you can give.
TIA,
:Brandon:
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
