Search results for query: *

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

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

Wow too easy!!!!!!!!!! Thanks

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

Okay Finally got it to work. I was missing a () somewhere so the query was not responding. Here is what i was trying to pull off. Thanks to all of you!!!! SELECT Tbl_Tracking.Origin, Tbl_Tracking.Destination, Tbl_Tracking.[Actual ETA], Tbl_Tracking.[Schedule ETA]...

I think out of frustration I could not explain yesterday. thread705-1207666 I found some helpful information from this thread but cannot make it work. I am basically trying to do the same thing. Here's what I have. A table with a field called Actual Eta. This field has a date in it or is...

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