Help To Make Query By Time
Aug 28, 2006
Good day,
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.
any help is very appreciated..
Thanks in Advance
View Replies
ADVERTISEMENT
Aug 17, 2006
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
View 10 Replies
View Related
Mar 8, 2006
I've set up a query to calculate the difference between 2 time fields. I set the property to short time.
The thing is - when I run the query in a Select query, the times in the column which contains the difference, appear correctly : ie hh:mm, but when I run the same query in as a make table query, the time difference field (although I have set the property to short time) appear something like this:
0.664464564646
Can somebody please tell me how to make it that the time difference results field in my make table query appears as hh:mm??
Thanks in advance - nelld
View 1 Replies
View Related
Nov 23, 2006
Hi.
I'am trying to count: todays date -12 month.
So how I tell access that I want answer which date is year from this date?
Or how I must "write" 12 months in SQL?
View 2 Replies
View Related
Nov 4, 2014
I have a text box linked back to a table and I am needing to be able to make multiple entries at one time for this text box but when I enter the first number and hit tab all the other text boxes that are linked to this one in the table show the same number....
View 2 Replies
View Related
Jun 18, 2015
I want to be able to make row searches for multiple sets of characters at the same time.The default setting cancels a row if I have inputed a set that is not on that row.Something that could be used in a store or by a lawyer looking for specifics.So these are what I am looking for:
Primary
1.) I want any row with any of the words I type to show on the results.
2.) I want the rows with the most matches to show up first.
Secondary
1.) Recognize sets of characters that are close to what I type to make up for spelling errors and typos, prioritize those that are closest.
2.) To be able to choose the rows I want and add them to another list quickly where the summing cost will be calculated in the last raw (multiplying the price of a row by how many the customer wants.)
View 6 Replies
View Related
Oct 12, 2014
I want to make an application that reminder Radio Broadcaster to read ads based on airing hour.
I have a question , how to make reminder pop up based on selected hour or time and date of that advertisement.
View 3 Replies
View Related
Nov 3, 2014
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'));
how i get end time due to CHECKTYPE]=O
View 1 Replies
View Related
Nov 28, 2004
Hi,
I have a report that have a datebox(Short date) and a timebox(Short time) and also a box that contains numbers like 36:59 and so on. That number is hours and minutes, I would like to take the date, time and add my 36:59 and get a new date from that and put that in another box. The date and time is used as planned date and planned time for some work to happen. 36:59+planned time+planned date=should be planned finishing date and time. Does anyone know what I have to do, to make this happen ???
View 2 Replies
View Related
Jun 7, 2006
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.
View 14 Replies
View Related
Apr 5, 2013
First query = Sum Products:
Code:
SELECT Sum(Tab1.Inputs) AS SumOfInputs, Sum(Tab1.ValInp) AS SumOfValInp, Sum(Tab1.Outputs) AS SumOfOutputs, Sum(Tab1.ValOut) AS SumOfValOut, Products.Product, Products.VAT, Products.UM
FROM Tab1 INNER JOIN Produse ON Tab1.ProductID = Products.ProductID
GROUP BY Products.Product, Products.VAT, Product.UM, Tab1.ProductID;
Second query :
Code:
SELECT Nz([SumOfInputs],0)-Nz([SumOfOutputs],0) AS Stoc, Nz([SumOfValInp],0)-Nz([SumOfValOut],0) AS ValStoc, IIf([Stoc]=0,0,([ValStoc]/[Stoc])) AS CMP, [Sum Products].Product, [Sum Products].SumOfInputs, [Sum Products].SumOfOutputs, [Sum Products].SumOfValInp, [Sum Products].SumOfValOut, [Sum Products].VAT, [Sum Products].UM
FROM [Sum Products]
GROUP BY [Sum Products].Product, [Sum Products].SumOfInputs, [Sum Products].SumOfOutputs, [Sum Products].SumOfValInp, [Sum Products].SumOfValOut, [Sum Products].VAT, [Sum Products].UM
HAVING (((Nz([SumOfInputs],0)-Nz([SumOfOutputs],0))>0.09 Or (Nz([SumOfInputs],0)-Nz([SumOfOutputs],0))<-0.09));
I need to combine those two query sql code to make only one query.
View 3 Replies
View Related
May 23, 2006
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?
Any ideas?
This screen shot may help:
View 2 Replies
View Related
May 23, 2006
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 short time but the format is in AM/PM or medium time.
Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances?
Any ideas?
View 1 Replies
View Related
Nov 14, 2007
can't seem to be able to do so..
View 2 Replies
View Related
May 15, 2006
I have a little problem with making a query and would need your help.
I have the following temporary table that gets filled automatically with 2 records every day:
DATE | TIME | NAME | CODE
The first record will have the DATE, TIME, NAME ( always the same ) and the CODE that can be START or STOP.
What i need, is to put the 2 records from the same day in a single row to get something like that:
NAME | DATE_START | TIME_START | DATE_STOP | TIME_STOP | NAME
Until now i was able to make 2 different queries. One can give me the START info's, the other one the STOP info's.
My question is if there is a possibility to combine those 2 queries or to make one query to get the result i need.
View 2 Replies
View Related
Oct 31, 2007
I have 2 tables: first table has 4 columns:
/job code/project1/project2/project3/
job code is some digits, and in next columns are the job description (different for each project).
The second table has
/project name/job code/description/working hours/date/
I made the query what shows how many working hours was consumed for each project monthly
and my working codes, but I would like to have job descriptions after job code, If its project1
then the description should be taken from first table from the column "project1". Is it possible to do it with
query?
View 1 Replies
View Related
Dec 15, 2007
Hello,
How would I make this query:
I have with me a gene database. I have primary key as ID and another field, called Field2. It looks like this:
ID | Field2
1 BRCA1 (br1)
2 BRCA2 (br2)
3 APRE (apx)
I have several more ids like this in this database. I am fine with the first gene abbreviation, but the second one in the parentheses is redundant. I want them eliminated however it will take too long to go through and manually delete these redundant names.
Is there a way to make a query to erase the text in parentheses and the parentheses themselves?? I think it will go as an Expression in the query or perhaps I can use an Update query, but I am not sure beyond this point.
Please help. It is urgent. Thanks.
View 5 Replies
View Related
Dec 17, 2007
hello,
I am having some trouble here.
I have a gene database with several tables. One table is called GenesMain. The other is called temp (temporary table). The GenesMain has a little more information (more fields and pulling info from other tables in the db) than the temp table (which is the basic template with basic info)
When I find new genes from places like NCBI or other genetic databases, I make a temp table and put them in there. My hope is to update the GenesMain table with this info using an append query or update query.
The first time I run the database over a new batch of genes, I am fine making a temp table and producing a GenesMain table.
The 2nd time I run the database over a newly found set of genes (like a few days later or few months later), I can easily make a temp table.
I am having trouble now updating my GenesMain table to reflect this newly found information.
Does anyone know how to update my GenesMain table with the newly made info from the temp table? Thanks
View 4 Replies
View Related
May 8, 2007
Hi,
I am opening a query in Access which has two linked sql tables but it takes to long to open. Can I choose a method (ADO) opening that query? If not, is there a way to speed up the process?
thanks
View 1 Replies
View Related
Sep 12, 2005
I have to make a query using information out of an existing table. In the table there are two columns which I have to use in the query. I need to have the totals of these two columns. The table looks like this:
country amount1 amount2
A 2 3
B 4 6
C 5 2
D 5 3
What I want the query to look like is:
country amount1 amount2
A 2 3
B 4 6
C 5 2
D 5 3
16 14
As I am dutch, my english will not be perfect
Thank you in advance
View 6 Replies
View Related
Dec 22, 2005
When using a make table query, can you include an ID tag. in the output table? if so how
View 2 Replies
View Related
May 15, 2006
:confused: I am using a Make Table Query to filter a Linked Excel Table. Is there a way to cut/drop the first 8 characters of the text out of one of the fields as it creates the new table?
Field NameExcel DataFinal Data
Model_NameLATITUDE D600D600
Also, the final table has two Relationships with two other tables. When I run the Make Table Query once a week, I have to break the relationship to get it to run. Is there an easier way to dial with this?
View 2 Replies
View Related
May 19, 2006
Is there a way in a Make-Table query to tell the table to open when it's created? I would assume there is a function or SQL code that would do this, but I know very little SQL. Can anyone point me in the right direction? Thanks!
View 2 Replies
View Related
Dec 15, 2006
Hi, Is it possible to load the results of a query into a form? I have a form where Id like the results of a query to go into. Can it be done?
View 3 Replies
View Related
Dec 15, 2006
Hi, Is it possible to load the results of a query into a form? I have a form where Id like the results of a query to go into. Can it be done?
View 2 Replies
View Related
Aug 27, 2007
I have a database named NewUpdate.mdb. I have another database named MainDatabase.mdb. Almost all the tables in NewUpdate.mdb are linked tables that are in the MainDatabase.mdb file.
I've written a simple make-table query in NewUpdate.mdb that makes a backup of a table that is located in the MainDatabase.mdb file. (See code below.)
SELECT tblProviderRate.* INTO tblProviderRateSave
FROM tblProviderRate;
The only problem is that this new table is created in the NewUpdate.mdb file. I need the query to be stored in the NewUpdate.mdb file and the "new" table to be created/stored in the MainDatabase.mdb file.
This sound simple enough, but I'm drawing a blank as to what I need to do in order for this to occur. Can someone tell me what I'm leaving out??
Thanks,
CRhodus
View 2 Replies
View Related
