Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: shenlingstyle
- Order by date
-
What does 'UPDATE LINKS' do?
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 "...- shenlingstyle
- Thread
- Replies: 1
- Forum: SQL
-
-
Writing a SQL statement to link fields from 3 tables.
Thank you very much.- shenlingstyle
- Post #3
- Forum: SQL
-
Writing a query statement for dates
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...- shenlingstyle
- Thread
- Replies: 3
- Forum: SQL
-
Writing a SQL statement to link fields from 3 tables.
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...- shenlingstyle
- Thread
- Replies: 2
- Forum: SQL
-
What does this code mean?
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...- shenlingstyle
- Post #5
- Forum: SQL
-
What does this code mean?
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...- shenlingstyle
- Post #3
- Forum: SQL
-
What does this code mean?
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...- shenlingstyle
- Thread
- Replies: 5
- Forum: SQL
