Recent content by Jul

Here is the sql for my query: SELECT qryQAMeasures.ActualDateUTC, qryQAMeasures.LineID, qryQAMeasures.ProductFamilyCode, qryNEWESTProductFamilyStandards.SheetMin, qryNEWESTProductFamilyStandards.WidthMin, qryNEWESTProductFamilyStandards.LengthMin, qryQAMeasures.Name, qryQAMeasures.Value...

I agree, I am not happy with the field names, unfortunately, we hired a company to build this database for us and those are the names the gave fields and I am not allowed to change them. So I now have to figure out how to make things work. Here is one of the ways I was trying to calculate...

I have a query that I am trying to build, that joins 2 other queries together. There is one field named "Value" and the actual values in that field are populated based on a field named "Name". So in the Name field, I want to pull "Sheet Length*", "Sheet Width" and "Sheet Count" and have the...

It worked! Thank you so much for your help!

I'm sorry for the confusion. Attached is a couple screen shots of what I have right now. Thanks again!

Thank you! I will give it a try. One question I have though, I have a pop up form, right now where we can select the brand # and it filters my data table that contains the link to just that brand. Do I need a different form rather than the table? I was hoping I could have it open to the...

I have a linked table in my access database, that is an excel file with built in links to PDF's by item. In my access database, I created a form where I select the item number and it opens that item in the table so I can click on the link to the PDF for that item. However, the links won't...

Re: Start Date and End Date with specific times I'm sorry if it seemed like I was asking the same question. I was actually trying to ask 2 different questions. One was to use criteria to get just that specific information and the other was to go back in history and figure out the correct...

Is there a way to build a field that is based on a date range? So, I want to say that everything from 6:45am yesterday to 6:45am today is considered yesterday's date. I work in a manufacturing facility and everything we report on is bases on 6:45am-6:45am being a day. So right now, we have a...

Start Date and End Date with specific times I am trying to write a query, which will pull all records from a start date that is user defined, with a specific time and an end date that is user defined with a specific time. For example, I want all records with a [Start Date] say, 10/29/2017 and...

Is there a way, I can force any entry between 6:45am yesterday and 6:45am today to equal the date of yesterday and have this calculate every day, even going back in history?

This worked flawlessly!

I believe by some miracle, I may have figured it out. Thank you!

I work in a mill, and our shifts run from 6:45am to 6:45pm. Our production dates, recording dates are from 6:45am until 6:45am the next day, we are a 24hour operation. How do I write in a query that I want to pull information from 6:45am yesterday to 6:45am today? I have a sample field that...

This worked PERFECTLY!!!! THANK YOU, THANK YOU, THANK YOU!!!!!