Recent content by bmhuettinger

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...