Search results

Got it! Thanks everyone! Txt file attached.

hi - thanks for the response. I've exported my report into Excel and have a created a "corrected" column next to the incorrect data. I've also shown the expression that I'm currently using in access to get the incorrect data. I'm unable to attach an Excel spreadsheet, however. Were you...

I have a query that shows the open order quantity by month and a table that show projected ship pounds (based on production capacity). I also have a query that totals the amount of backlog pounds (previous month or earlier). I need to be able to add the backlog pounds to the current month...

Plog, I'm beyond grateful for your efforts. I'm running the queries now; at first blush there's an issue with the raw data (from our machine) that's creating 1st passes in the middle of rolling schedules so it errantly creates new groups when it should continue on...I may have a follow up...

there are several rows of data where the formatted speed is 0 - the crux of the issue is that there are a lot of records within each pass (like, somewhere in the neighborhood of 300-400 on average). Is there something wrong with the format of the data?

Good morning - thanks for the feedback. I've attached the table as an .txt for now...if there's a different preferred format, let me know Essentially, every time the Pass = 1 and the Speed is 0, a new group starts, regardless of how many passes there are...sometimes only 3, sometimes as many...

Good morning all, I'll do my best to explain the issue... We have manufacturing machine that exports a lot of data about how long it takes to complete each "pass" and the speed of the machine at any given interval when running coils of material. If I limit the time increment to only minutes and...

So I feel dumb...after taking the time to create 24 separate queries of data (because I'd already spent 3 days trying to solve the issue), I inadvertently discovered that the query field name was actually "sumofSUMOFlbs" (because the query was a totals query of a subtotals query). Unbelievable...

Thank you for the replies...my query works fine. I use it for several other reports (with specific month criteria) with no issues. Aside from the "(Adjusted)" in the query name, all of the fields and formulas were taking from other solutions on this site. (Also, I don't have a field name the...

Good morning, Yes, I agree re: the nz(). I took it off shortly after my initial post here for simplicity's sake. I've doubled-checked my fields and properties. The only thing that I could think that may possibly be an issue is that [mth] is actually a calculated Month() field itself and may...

For now, a report. But I would like to be able to use this for form controls, as well.

Pardon me. I should have said I'm getting #error results.

Thank you, Minty. Unfortunately, I'm still getting an error message. I even tried it without the NZ()

Good evening, I have 3 tables of monthly usage data that is updated daily using "rolling 12 month" criteria. I'd like a summary form that shows MTD, as well as the previous 11 months usage for each of the 3 categories (tables). Since the month names will change every month (rolling 12), I...

That did it!!!! Genius! I do have one other issue now, however, and let me know if this if I'm circumventing any forum rules, but because I've used so many nested replace() to accommodate 27 scenarios, my expression is "too complex". I think I can get a maximum of 18 total functions before i...

Thanks - I think I understand both the split function and the Public Function for the module, but I don't see how to connect the dlookup ("inside the loop") to assign value to the newly split alpha-codes. I'm assuming a table (which I have [ProcessRunTimes]) but I'm not sure what that would...

I wish. We're a large manufacturing facility and this data is downloaded straight from the system that operates mills and furnaces and machines of all kinds...I think the likelihood of getting anyone to reprogram the system to output "access friendly" data is akin to me figuring out how to...

when I add the sum() to the expression I get an error message that my query doesn't include the specified expression "order" as part of the an aggregate function. What is a good way for me to include the table? I have a field [RemainingProcess] and the data looks like this: AE,FR,SS,QC,PCK...

Good afternoon! I have a field in a linked table that contains several alpha-codes for machine processes (this table is downloaded from our company system, not a table that I created or can modify). Each of these alpha-codes has a corresponding number of days for processing. I've used a...