I was able to use a Crosstab Query which gives me mostly what I
want... except that the query is unaware of months that have no value
for any vendor.. a minor problem, but it doesn't allow me to make a
static rpt very easily.
I think it will work though.
:Brandon:
--- In AccessDevelopers@yahoogroups.com, "torres0157" <[EMAIL PROTECTED]>
wrote:
> Brandon,
> If I am correct, the problem you are having is placing a missing
> month on your report with a blank or special character.
> "is this true"
>
> Mando....
>
>
> --- In AccessDevelopers@yahoogroups.com, "Brandon"
> Brandon,
>
> <[EMAIL PROTECTED]> wrote:
> > 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/
