I appreciate your responses...Yeah its one of those things where the boss wants his database a certain way and pretty much thats how it was structured when I got there and there is alot of data. This report is pulled weekly per state to calculate job cost vs estimates. This same boss wants...
Even though all form/queries are the same every state has their own forms. You select the state and you enter data for that state. Yes there is a subreport that calculates.
First let me say that this is my first posting and Iam new to Access so be nice and patient.
I have the same report I run indivually for all 50 states but 3 of the states give me Error Msg 2147217900 & Error 94 Invalid Use Of Null.
Does anyone have a clue why only certain states react like this?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.