Search results for query: *

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 "...

Thanks a bunch.

Thank you very much.

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, now it makes a lot more sense, thanks a bunch. You really know this stuff. I have some final questions. So from my understanding, there are two stages happening here. One is that qry_cur_resource is 'filtered' for preferred information. Another is that qry_cur_pier takes this preferred...

Thanks for your reply! I'm still a bit confused about which happens after which. "CurrentDB.QueryDefs is a collection object which contains one entry for each defined query, keyed by the name of the query, which in this case, is 'qry_cur_pier'." What does QueryDefs mean? And why is...

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...