Well I have some code behind a MS Access database, it looks like this:
Dim UTCOffset As Integer
UTCOffset = 4
If cmbGMSXtime.Value = "Standard Time (EST)" Then
UTCOffset = 5
End If
.QueryDefs("UPDATE_LINKS").SQL = _
" UPDATE LINKS SET LINKS.ARR_TIME = [LINKS.ARR_TIME] - " & UTCOffset & "/24 "...
Hi, I'm a beginner in writing SQL statements.
Well basically I have a database with a date field. The data shows up like "11/23/2003 1:11:00 AM". The field is called START_DATE.
How can I write a query statement to extract all records that refer to tomorrow, December 15th, 2005?
Thanks all...
Hi, I'm a beginner to databases and querying so hope you can help me out!
I have 4 tables involved: FLIGHT_LEG, FLIGHT_DATE_GEN, ACTIVE_SCENARIO, SCENARIO
The problem is that the FLIGHT_DATE_GEN table doesn't have a scenario field (which I want). Each record should have a corresponding...
Hi, I'm analyzing a program made with MS Access. It has a whole bunch of tables and queries already made, and a form with lots of code behind it. I'm looking through and I'm not sure what the following means:
With CurrentDb
.QueryDefs("qry_cur_pier").SQL = _
" SELECT DISTINCT...
