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 AccessDevelopers@yahoogroups.com, "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 > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/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/
