Hello all,
I hope that someone can assist with my problem. I need to create a
query that might be too complex. I have a database that involves
vendors, buckets (0-30 days, 31-45 days, and so on.)I want to create a
query that will have the buckets as columns with totals of the entire
buckets and for each vendor. I have vendors that are complex also. for
example HP, Hewlett Packard, and Hewlett Packard/CTC could be the same
vendor. and IBM, IBM/ANT etc. all must be combined. There is several
ways that each vendor could be shown as example as above like the HP
and Hewlett Packard. I have tried a crosstab but I could not figure
out how to group each vendor into one row. If anyone knows how to
accomplish this please let me know how.
I want it to look similar to this format.
0-30 31-45 46-60 61-90 90+ total
Misc 1234.00 567899.00 6790.00 3456.00 345.00 sum
HP 5678.00 5765.00 67.00 567332.00 89.00 sum
IBM 6790.00 345.00 8655.00 78912.00 100.00 sum
Lenovo 567332.00 89.00 900.00 765.00 43.00 sum
Thanks
Jim Wagner
------------------------ Yahoo! Groups Sponsor --------------------~-->
1.2 million kids a year are victims of human trafficking. Stop slavery.
http://us.click.yahoo.com/.QUssC/izNLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
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/
