Search results

Thanks MStef! But I tried that method b4, I cannot work. But thx for making an effort to generate a solution for me though!

omg thanks for that link Rabbie!!! it really helps! SELECT username, DateValue(logtime) AS Date_Clocked FROM NGAC_SYSTEMLOG WHERE logtime IN (SELECT logtime FROM NGAC_SYSTEMLOG WHERE logtime BETWEEN #9/1/2005# AND #9/30/2005#) AND (logtime < #9/23/2005# OR logtime > #9/25/2005#) GROUP BY...

i tried both () and [] brackets, but the same error still occur, sad

I had tried it be4, cannot =[ I use the [] brackets to indicate subqueries

thx rabbite, but i got a new problem again =\ Please have a look at the query below: SELECT * FROM( SELECT username, DateValue(logtime) AS Date_Clocked FROM NGAC_SYSTEMLOG WHERE (logtime BETWEEN #9/1/2005# AND #9/30/2005#) GROUP BY username, DateValue(logtime)) WHERE (Date_Clocked <...

thx rabbie, but the working solution is 'where (logtime Not between #3/22/2005# and #10/17/2005#) AND (logtime not between #1/1/2006# and #2/25/2006#')'. I tried your solution but it doesnt exclude the records in the 2nd range, so i tried my luk by replacing the OR keyword by AND inbetween the 2...

yea but im currently developing a software that can select the records when logtime is not between 3/22/2005 and 10/17/2005, but also between 1/1/2006 and 2/25/2006. I know this is troublesome, but I tried 'logtime<#3/22/2005# or logtime>#10/17/2005# or logtime< #1/1/2006# or #2/25/2006#', but...

thank you, but issit possible to select all the rows out of 2 date range?

that columnname for my date field is logtime, but thx for telling me that, i appreciated your reply

hi, how do I select my data where the date is beyond the date range specified? For instance, I wan to select all the rows except the rows that are between 3/22/2005 to 10/17/2005. Is it possible to select the query? I tried the condition 'where date < #3/22/2005# and date > #10/17/2005#', but it...

it's ok i did it

hi I am making a late report of each employee's data and I calculated for each individual day by having late for how long, but I would like to make another column which displays the total amount of time late. This is currently what I have now: My SQl looks like this: SELECT username...

thank you so much! Just exactly what I need! I slip off the Group By keywords, and im not pretty good with using SQL

hi, I have a table that looks like this: And I wan to query my data that looks like this so that I can display the start time and the end time of each distinct date and in every user: How can I do lidat? I appreciate anyone who is able to help me, and this is an access database