Search results

I tried but no luck. I have no idea how to join the ODBC table with the custom table since the date and time field are one field on our server which is why I have to separate the two fields using MID function (Example: 2020110911494471) I think my ask is to ambitious and most likely I won't...

Thanks I will give this a try.

Here is some sample data. I should have mentioned that this is pulling from ODBC connected to our server. This is what I have for our dayshift numbers (7AM - 3PM) and it's working as intended. SELECT PR1_AUDITS_CURR.WSKUSKUSKUID, PR1_AUDITS_CURR.FROM_LOAD_ID...

Hi All! I am trying to figure out if there is a way to query a certain set time across multiple days. Example we have three shifts (Days 7AM - 3PM, Afternoons 3PM - 11PM and Nights 11PM - 7AM) I want to pull the records for each shift and count the quantity of boxes received. Right now I have...