Search results

MarkK, you rock! Thanks for your help. This seems to work for me but I'll continue to follow it: Shift Start: DateAdd("h",-5,(CLng((DateAdd("h",-1,[wo reportdate]))/0.5)*0.5))

Upon further looking, I noticed that I had a small mistake on some time stamps like: 7/30/2015 6:17:01 AM gave me: 7/30/2015 7:00:00 AM. It should have given me: 7/29/2015 7:00:00 PM. I changed the CLng function to Int (should be rounding down now). 7/30/2015 6:17:01 AM now gives me...

Perfect! Thank you very much!

Hello. I am working in a manufacturing environment and tracking machine failures. Each machine failure will come into my database with a time stamp like: 12/27/2016 4:33:10 PM I would like to associate a Shift to each one of these occurrences inside of a query. This will allow me to later...

Thank you. I originally tried to import the data as date/time but got conversion errors so I put everything in as text format. I was importing .csv files before. Today, I created new data tables and imported data as .xlsx files. I got no conversion errors while importing as date/time. In...

Text. Should change to Date/Time?

I loaded data in the table from 2015/08 - 2016/08. I am hoping to get the results of 2015/08 - 2016/07. When I enter: >= DateSerial(Year(Date()),Month(Date())-12,1) AND < DateSerial(Year(Date()), Month(Date()+1), 1 I get: No Data When I enter...

Thanks! This mostly worked but I get a little bit of a strange result. The data in my database includes Jan/2016 - Aug/2016. When I input like this: >=DateSerial(Year(Date()),Month(Date())-7,1) And <DateSerial(Year(Date()),Month(Date()+1),1), I get 7 months (Jan 2016 - July 2016)...

I should also note that in my data table, the format of [WO actual finish] is text. It looks like: 3/1/2016 2:30:00 PM.

Hello. I am using a query to sort data entries and label them with their corresponding year/month. The data is then going to Excel for analysis. Each year/month entry looks like "yyyy/mm". The access field is: Year/Mnth: Format([Labor_MBI.WO actual finish],"yyyy/mm") My question: I want...

Thanks. That did it. He was using UK English, while I'm using US English. I'm just not clear on why that effects the query that is coming from Access. Learned something new. Thanks again!

Hello. I am using an Access Query linked to Excel to do some analysis of data. When I refresh it (and at least 1 other person) the data comes through OK. For 1 person, 1 field is showing data that is NOT in the real actual query results. The field is: Year/Week: Format([actual...

In my application, I'm tracking breakdowns on manufacturing machines. Each occurrence has many data points (what is broken, when, who fixed, parts used, etc). We use yyyy/ww to show us trends (increasing or decreasing) to know if actions are making the machine performance more reliable. We...

Thank you! This seems to do the trick for me. Only 1 thing: My company is treating the week 12/28 - 1/3 as week 1 of 2016. I tried: Year/Week: Format([Actual Finish]-(Weekday([Actual Finish],2)-1),"yyyy/ww",2,0) & Year/Week: Format([Actual Finish]-(Weekday([Actual...

I'm fairly new to Access. I started playing with it about 1 year ago when our Access resource people left. I've really enjoyed learning and have stumbled across these forums a few times during my searches for answers. Thanks for your past and future help! and Happy 2016!

I think I understand his point is the same that I have ran into this morning (welcome in 2016! and sorry for re-opening such an old thread). In his example, I would prefer 1/1 & 1/2 to be displayed as 53/2004. I'm meeting the same problem and here is my example below. Here is my query...