Search results

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

:banghead: Hoping to get some help with this one. We have a company that designed a Quality system for us, but didn't build any of the reports, so I have been left trying to figure out the different queries to run these reports. Here is my latest issue: the company built a quality table...

Thanks everybody. We ended up updating the driver on my computer, and will have to do the same with all users of the system eventually. Once the driver was updated, the dates formatted to date/time fields instead of text fields. Thanks again...Now on to my next issue..... :)

You were correct, they have used DateTime2(7) as the datatype. Is there a way you know of that can convert that, which is now a text field into a date/time field? Thanks for your help!

The company that is designing our program said they had never seen it happen either. I will ask what field type they have selected for the date/time field. If I run a query to convert the dates to a date/time field in my ODBC database, would that automatically run to update the dates since...

Our company is pushing out a company wide production & quality system, this is going across 4 different sites. In the SQL server tables, the date/time field shows up as a date/time field, however, in my ODBC linked table access database, the date/time field somehow got switched to a text field...