Hi, can anyone advise where I am going wrong with attached query.
I just want the waiting time between two sets of time but I don't seem to be able to get the right figures.
I have tried to change the property of the query variable by going into the feild properties for the calculated feild but cannot find the Date/Time property listed. What am I doing wrong please. (using Access 97)
Also how would I get the Avarage waiting time for a particular day in the same query.
I have finger print machine and i already connect to it and get all log.then i tray to get data and here is the code that im using
SELECT Format(CHECKINOUT.CHECKTIME,"dd/mm/yyyy") AS CDate, IIf([CHECKINOUT.CHECKTYPE]=I,Format(CHECKINOUT.CHECKTIME,"hh:nn:ss ampm")) AS StartTime, Format(CHECKINOUT.CHECKTIME,"hh:nn:ss ampm") AS EndTime, USERINFO.USERID, USERINFO.Name, CHECKINOUT.CHECKTYPE FROM CHECKINOUT INNER JOIN USERINFO ON CHECKINOUT.USERID=USERINFO.USERID WHERE (((Format([CHECKINOUT].[CHECKTIME],"dd/mm/yyyy"))='10/04/2014'));
Hello buddies :D, do you have any idea how to make this work?
To select data that falls within this criteria of date range between cboDate and cboDate2 (fields on my form). The date in [tblJobDetails]![timeIn] come in this format "08/17/06 10:24 AM", but the cboDate/cboDate2 (takes in date only e.g 08/17/06) what i am after is to evaluate specific hard coded time in addition to the date entered, i.e. even tho, i haven't entered time on the cboDate/cboDate2, I want specific time hard coded where e.g If i select a date range of 08/17/06 and 08/18/06 on my cboDate and cboDate2 it should really be evaluating: 08/17/06 8:00 AM to 08/18/06 8:00 AM.
This is the criteria i curentlly have on my query in design view tha works perfect in selecting date only. ([tblJobDetails]![timeIn]>=[Forms]![frmPendingJobs]![cboDate] Or [tblJobDetails]![timeIn]>=[Forms]![frmPendingJobs]![cboDate] Is Null) And ([tblJobDetails]![timeIn]<=[Forms]![frmPendingJobs]![cboDate2] Or [tblJobDetails]![timeIn]<=[Forms]![frmPendingJobs]![cboDate2] Is Null) How can I incorporate 8:00am to 8:00am into my cboDate and cboDate2. What can i do to make this happen? Your kindness will be greatly appreciated http://www.naijaryders.com/forums/images/smilies/thankyou.gif
I have a link table with a field in GMT time. I want to convert the times to local time in a query. I know that I should use DateAdd, but I am just wondering how to know summer and winter time. On the summer our local time is +2 GMT and on winter +1.
I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network.
The link works fine but the time formats are different.
On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format
However on PC 2, opening the same database via the network, the time format is still shorttime but when you read the time within the code it comes out in AM/PM format. Also, when the defaul tiem should be #20:00:00# but this changes to #8:00:00 PM#
Weirdly though, when you just open the table, the times are in the correct shorttime format.
Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances?
Ok, this might need to be in the macro section or something, but just incase, I have a query that I want to run at about 10pm every night (when everyone has gone home) , to make it even more complicated it queries from sage and creates a table each night (that i want to overwrite the old table) and it will need to enter in the sage login information :(
Does anyone know how to do this as to be honest, it has me at a bit of a loose end, I guess it would be a macro, but I have no idea of the commands used
I have a table that consists of [employee], [scheduledate], [starttime] and [endtime]. I need to query this table to get the total of all employees working during a certain period of time (ex. 1400 - 2200). I have been pondering this for quite a while and have yet to come up with something.
Any help you can provide would be greatly appreciated.
I have a query with the fields dtDate (Date/Time in Short Date format), NC "Number of Chats" (Long Integer), and TCT "Total Chat Time"(Date/Time in hh:nn:ss format) from tblChats. Each date will have multiple NC and TCT values. This query is totaling them by date with the following SQL.
SELECT DISTINCTROW tblChat.dtDate, Format$([tblChat].[dtDate],'Short Date') AS ChatDate, Sum(tblChat.TCT) AS SumOfTCT, Sum(tblChat.NC) AS SumOfNC FROM tblChat GROUP BY tblChat.dtDate, Format$([tblChat].[dtDate],'Short Date') HAVING (((tblChat.dtDate)>=Date()-7)) ORDER BY tblChat.dtDate;
The query works fine. Now my question.
I would like the query to figure the average time per chat for each day.
as the topic says, i'm a beginner playing around w/ access and i tried to make a query that used 2 tables, but the problem is that when i try to view the query, (since i'm using fields from 2 diff tables may be why) none of the data shows up and all of the fields are blank.
i'm trying to create a query that runs off 2 tables in order to better organize my data. so what i'm trying to do is (with the invoice database i'm trying to create) get some fields from table1 to automaticallly roll over to table2 on the query because table1 and 2 use a different invoice numbering system but some of the values are identical for the y/n fields.
does anyone know how i can fix my query so that i can make it that it merges 2 tables together and still shows the data?
I have a table with many records each record has specific time. I would like to make query by time to see how many transaction has been done every 10 minutes.
I made a query its show me only one period. how to see all others period.
For example:
Start Time--End Time -- Amount (Total of amount for the period) 10:00:00 -- 10:10:00 -- 2000 10:10:01 --- 10:20:00 -- 1500
and for all other period :
I have attached the file with the data table and query.
I am using access to store logged maintenance actions. There are two 12 hour shifts and I want to create a report that the crews can show to the oncoming crew of all maintenance performed over the last shift. For example, the day shift is from 4am to 4pm and the night is 4 pm to 4am, and I want the night shift to hand day shift a report with all records from the last day 4pm-4am.
Here is the where clause in my query, I can't seem to get it to work, but I'm not too familiar with dates and times in Access.
WHERE (((tblMSL.Date)=Date() Or (tblMSL.Date)=(Date()-1)) AND ((tblMSL.Time) Between #16:0:0# And #4:0:0#))
Hi Everyone, I have a database that I enter time for in the form of military time, I would like to make a query to count the number of entrys in the PM,AM, And NIGHT. For instance if a record has a time of anywhere between 700 or 2299 I would like it to be in the AM catagory, then I would like to total up the number of AM records. Any help would be great. Thanks.
the part of statement highlighted in red ...is the value for the filed value_settled whose data type is yes/no..
now i am confused with thise highlighted part..will it assign the 0 to G_value_os or first use the original value of G_value_os to insert the value into database... please help me...
hi this is my first post. This is probably so basic you will think i am stupid but your help would be appritiated. I have a very simple database which displays the questions stored in a table in a form . The recipent answers the questions generaly yes or No. On answering yes or no i wish to attach values (hidden) to thier answers and then based on the answers produce a simple set of bar charts. I have tried but do not know how to assign the values to the questions . i would then like to produce 5 bar charts 1 for each of the catogories and one as a total (as an overall and also in sub groups of which there are 4 each of which has a field with a specific prefix either b,c,r,s dependant on the type of question. )
What I have is a table with three columns: Name, Start, End (the last two being a start time and end time column in 24 hour format). What I need to do is calculate the time interval in minutes between the start and ending times (this has been done already and quite easily). What I find myself stuck on is when the ending time exceeds 00:00 and the start time is before this. IE: 23:30 start, 00:30 end, which is 60 minutes (duh). I wind up getting a 23 hour time.
Is there a way that I can code up a query (has to be a query as the rest of the DB results rely on the correct minutes per person)? Appreciate any help in this
Ive found alot of reference to using dates to find records but not time, I need a query to pull up records entered on that day before lunch time and another query will pull the records entered after lunch.
receipt date is date/time field receipt time is date/time field
to get records for that day i use date() which works but cannot get the time part to work??
I have a database that stores information for lab testing. Each time a tech does a "step" in the test process he logs it in the table, using an input form. There are different categories, for example preparation, testing, analysis, etc, and each of those steps take time. I have the form autopopulate the date and time with NOW() evertime the form is updated. What i want to do is calculate the time it takes to do each in days. I can easily get how many days it was from now since they logged the test, =NOW()-TestDateTime. What I want to do is get the number of days it took to do each step, ie the number of days between each event. Is there a way to do this?
I have an attendance database and I connect the time attendance machine db to my access db, what i am trying to do is to generate a report that shows the time in and time out for specific date. the type of attendance db is date/time.
Please see the attached screenshot db from attendance machine.
an also some time there is duplicate entry, I need to get the first and the last entry only for specific date.
May I know some to construct any functions or query string that can track the no. of records that mean certain criteria in the run time.
Basically I want to track the records in a subform (in datasheet view). Should the no. of records is 0, then I can disallow user from saving it onto the table for better record keeping.
I have two queries which are slightly different. One of the queries takes way too much time and resources and I'm wondering if anyone could explain me why, and if possible, how to fix it.
This query is slow.
Unseen Movies SELECT "General Info"."Title", "Additional Info"."Subtitles" FROM "General Info" INNER JOIN "Additional Info" ON "General Info".id="Additional Info".id WHERE ("General Info"."Seen" = 0) ORDER BY "General Info"."Title";
This query is fast.
Unseen Movies With SubTitles SELECT "General Info"."Title", "Additional Info"."Subtitles" FROM "General Info" INNER JOIN "Additional Info" ON "General Info".id="Additional Info".id WHERE (("Additional Info"."Subtitles" IS NOT NULL) AND ("Additional Info"."Subtitles"<>'') AND (("General Info"."Seen" = 0))) ORDER BY "General Info"."Title";
