Not allowing general users to enter ad hoc data would be a good start to fixing your problem. I am not sure if your data is normalized, but that would help this kind of situation as well.
You already have the answer to your question. You just need to fix the data. Creating temporary tables to clean up and group you data is probably what you need to do short term to get your cross tab done.
Short of cleaning up your data, you could add a new field to the vendor table and group on that field. This field would be linked to a new table with your single vendor names. Creating this structure would be the quickest/easiest solution in most cases.
TJ
luvmymelody <[EMAIL PROTECTED]> wrote:
You already have the answer to your question. You just need to fix the data. Creating temporary tables to clean up and group you data is probably what you need to do short term to get your cross tab done.
Short of cleaning up your data, you could add a new field to the vendor table and group on that field. This field would be linked to a new table with your single vendor names. Creating this structure would be the quickest/easiest solution in most cases.
TJ
luvmymelody <[EMAIL PROTECTED]> wrote:
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
Please zip all files prior to uploading to Files section.
Yahoo! Shopping
Find Great Deals on Holiday Gifts at Yahoo! Shopping
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
