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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query to expire old records
Hello I would like some suggestions on how to setup a query to add and expire records. My table would be setup like the one below Origin - Destination - Rate - Valid From - Valid To USA Germany 400 4-25-09 12-31-9999 As i get new rates i want the query to add the new...- blakebry
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Importing Data From Excel
I am kinda baffled. I have an excel file that I am importing to access. The column I am importing to is formatted as text. Some fields are text and some are numeric in this column. Access keeps converting the numbers from 8000398000 to something like 8.0004e+009 when I have the excel file...- blakebry
- Thread
- Replies: 3
- Forum: Data Management Tools general discussion
-
Action Queries
Hello I have several action queries that run one after the other using a macro. I do not want to have to press yes 10 times to complete the task. Is there a way to run the querys and have yes auto selected. Thanks- blakebry
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Option Group Null, Not Null, and All values
Hello I have found a what looks to be a solution from a previous thread on this forum, but my query returns no results. Can someone assist. I am trying to return results from a query based on field Tbl_Tracking. I have an option group of (1 In Transit 2 Arrived and 3 All) on form...- blakebry
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
