Hi Jim, It seems you have been trying to resolve this for quite some time now. I am not sure I will be much help but will try. You need to create some way to your vendors, i.e. HP vendors will have a vendor number between one and 99, IBM will have vendor number between 100 and 199 so on and so forth. With this method you will be able to categorize vendors. You are not clear as to how you determine your "buckets". Are these field entries? Are they resolved from a date? I don't think you need a cross tab query. I believe the problem is identifying and categorizing (grouping) your vendors.
Glenn P. Jones IHS Have a Merry Christmas -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sent: Thursday, 08 December, 2005 19:04 To: [email protected] Subject: [AccessDevelopers] Re: maybe too complex query but need help The type of question you are asking about having the "buckets" as you call them sounds like something a CrossTab Query might be able to do. Look up "CrossTab Query" in the help file, or use the "CrossTab Query Wizard" to achieve the result. HTH! Alienwebmaster --- In [email protected], "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! Groups Links ------------------------ 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/
