Recent content by TheYoungOne

haha @TheDocMan :D Well I'm doing my best to learn as fast as I possibly can, but I already get that enthusiasm thing! :cool:

Nice, I added those plus some from "Where" Till the end and now it works :) I'm learning

hey there, I'm new to access and SQL (VERY new), but since I have to deal with it a lot lately, I might need your help a little more than others :rolleyes: Keep your replies simple, I'm doing my best to understand them! Thanks and all the best, TheYoungOne

hello, I need to combine several "And" and "OR" conditions but can't seem to make it work. Conditions should be as followed: All 'PCK' on the 17th of December picked by either a DW, a RT or an OP What I have now doesn't consider the date constraint, so I'm guessing I'm missing some...

What does the 1020 stand for? I added it, and the query ran but there where no results I'll keep trying tho :cool:

good to know :D I thought thought I didn't post it in the first place :o

So far I've got this :cool: SELECT Format([dbo_ORDER_HISTORY]![OTH_GenDate],"dd/mm/yyyy") AS Datum, Format([dbo_ORDER_HISTORY]![OTH_GenDate],"Short Time") AS [Time], dbo_ROUTE_GROUP_ASSIGNMENT.ROUG_RefNr AS [Route Group], dbo_ROUTE.CARR_SCAC AS Route FROM ((dbo_ORDER_HISTORY INNER JOIN...

Hey guys, I'm a newbie when it comes to access, so please keep your answers simple :D I'm facing an issue with a query. I'd like to count how many releases have been made for one day, so within 24 hours. BUT, the new 'day' starts at 5 pm, going until 4:59 pm. :banghead: I appreciate your help...