Recent content by billz260

Thanks, unfortunatly I don't know much about programming but I used the logic and figured it out by using the Qry Builder. Thanks!

I created a Qry (also tried with a table) that pulled all the active days of all location for the year. I then tried a comparison Qry between it and a select location with and IIF statment that I thought would produce "0" for the days represented in the "ALL DAYS" set of data. But in the...

I'm trying to do the same thing but with callender days. I need to fill in the days that don't have any activity with a "0" so the std dev calculates correctly. And it won't be as simple as creating a table with Jan 1 - Dec 31, most of the activity will be on callendar work days only which...

In the Columns setting you have "4", but the report is ounly outputting two columns? Can you help explain? I'm having trouble getting more than 2 columns to print on my sub report. Never mind, I see it's only taking two colums to report the amount of info you have in your table. I added...

Bump!!!!please!!!

This may or may not work for you all, it's working for me :) Create your query with the data output you need for your stacked bar chart. Create an .xls file and IMPORT that data into it, then create the chart you need based off of that data set in .xls. Then all you have to do is click...

DOH! Now I feel like a friggin retard! I am still new and probably need some formal training. Although, we are moving my creation to an SQL server so I guess I will be learning how to do stuff right as we re-create it in developer. THanks again fella's!!

DH: IIf([MRPCn] Not Like "B3*" and [MRPCn] not like "B90",[Open_Delivery_Qty],0) Worked...

Well, MRPCn is a identifier, the differnt codes mean different part families. I am trying to build a bar chart based upon open qty's for different ranges of the MRPCn fields, They are some logical order but since they include a letter and numbers, I guess ranges won't work. All this info in...

Yes, but what if you need to have multiple cases? Trying to return the order qty depending on the type of line item. This works... SSS: IIf([MRPCn] Like "B3*",[Open_Delivery_Qty],0) But this doesn't, I need to have multiple arguments in my statment. I can't seem to get this to work w/ out...

Where is the code located? I have A2002, does that mean i will not find it? I am new to using code in my Access DB's, and I need to learn. I just couldn't find where the code was, not in the table or the report. I didn't see any modueles or macros. I need a bigger flashlight... thanks...

Rich, you timline is exactly what I need but I can't figure out how you are controlling that blue box on the report. How does it know where to start and what is telling how long to be? It's perfect but I dunno how to re-create it. Thanks Sent you a PM...

I as well am working on Gantt type charts for progress reporting on various orders we have. I have some ideas from others on this site. Will try to post my results when I am happy with them...