Recent content by JefJFitz

I have a report that displays either #REF or #NAME for some of the fields (but not all) when I open it up in print preview. If I switch to design view and then back to print preview it corrects the error and everything displays correctly. Odd thing is that until yesterday, everything was working...

That is the norm. All inventory tanks are measured every day and a record exists for each tank. I used the formula that you gave me and it worked to perfection. Gave me exactly what I was trying to accomplish. Also took your advice on naming convention and redid the entire db. Thank you for...

I will try that. Thank you so much!

I have attached a simplified version of the database named QueryTesting that I am working with no proprietary information. It should give you a basic understanding of what I am attempting to do. Table INVENTORY DATA contains the daily inventory information for a set of five different storage...

I have attached a simplified version of the database that I am working with no proprietary information. It should give you a basic understanding of what I am attempting to do. Table INVENTORY DATA contains the daily inventory information for a set of five different storage tanks from the...

I have an Access table that shows inventory for a set of storage tanks by day. Each tank has it's own record for every day. What I would like to do is write a query (that will feed into a report) that will calculate the daily inventory delta by tank. I have no clue how to do that. Can anyone...

Hello, my name is Jeff and I am employed by an oil refinery in the United States. I got exposed to Access about 25 years ago when we installed some yield accounting software that used it for data storage. I wouldn't consider myself a power user...guess I know just enough to be dangerous. I...