Queries
in [Access]
|
Time function Hi, I have field 'start_time' and 'duration_time' in minute. Do you know how to get a 'End-Time' by adding 'start_time' + 'duration_time'? I tried to do that, but the result is wrong. Any other function to get that? Thank you in advance. Rgds, KFT -- Message posted via AccessMonster.com http://www.ac... 31 Mar 2010 22:11
hubs i have a table like carrier service equipment price comment hubs imdl 48 200 current hubs imdl 48 500 hubs OTR 48 2899 now i need a query which can extract unique rows(for uniqueness, the fields considered should be carrier,service,equipm... 31 Mar 2010 09:52
回覆: How could I SELECT the max of 2 different fields? Thank you. It works. I just thought there would be something like Greatest() in Oracle but I think there is not. "Allen Browne" <AllenBrowne(a)SeeSig.Invalid> �b�l�� news:OrGKBy$yKHA.6140(a)TK2MSFTNGP05.phx.gbl �����g... Select Max(A_Date) AS MaxA, Max(B_Date) AS MaxB IIf(MaxB > MaxA, MaxB, MaxA) AS MostR... 31 Mar 2010 05:28
Using a Yes/No field to trigger a calculation in another field - J I have a billing form that was created from a query based on the table that all these fields are from. In this billing query is where all these calculations are happening so they can be displayed on the billing form. TotalTuitions is a field that exists in my main table and it is calculated in t... 31 Mar 2010 01:09
Refering to lowest record in select subquery HI All, In the subquery below how would I refer to the lowest 3 orderID? Thanks in advance for any help SELECT Orders.CustomerID, Orders.OrderDate, Orders.OrderID FROM Orders WHERE Orders.OrderID IN (SELECT TOP 3 OrderID FROM Orders AS Dupe ... 30 Mar 2010 16:08
Oldest and Most Recent dates in header I have a report that I need to modify so put the oldest and most recent dates in the header. I want to look at a specific field and find the oldest date in the report results and also the most recent date in the report results. I don't know how to do this. Anyone? thanks, Crockett ... 30 Mar 2010 15:01
Instr parsing with a comma delimited string Hi all - I'm using the InStr function to parse a comma delimited text field for use in a parameter query. It works like a charm, except that the data in the field is very small and it's splitting by character. For example, here's the function I'm using in the query SQL (I snipped the rest of the SQL for ... 31 Mar 2010 11:00
Return Random Sampling from Query If I have a first query that returns 3000 records, is there a way to build a second query based upon the first to pull a random sampling of say 225 records from it? QB ... 30 Mar 2010 16:08
make-table I have a Make table Query when the Query is completed I am ask do I want to Make table which I then need to click yes to make the table is there a way I can create a Marcro or VB code that will automate this? The queries are very large. I am new to Access please can anyone help with this? ... 30 Mar 2010 11:39
Many tables I have a dozen parts books which have their own database and each has the same structured table for their data. In each database, I have linked tables to all other database tables which allows me to compare data. From time to time I need to query all databases to see whether they contain say, a part number or... 30 Mar 2010 02:54 |