Search results

Hi guys I'm kinda an intermediate Access developer.....but am still grasping a few things. And the one question I do have is what is the use of relationships when you can pretty much do everything anyway with queries, SQL statements, etc :confused:

Exactly what I need to do....but how would you do that from within Access? I'm trying to get this as automated as possible.... Thank by the way.

Hi I have a CSV file that is imported that is some info from a scanning application. All is working ok, but it is imported as showing a few little "squares" or blocks at the end of the fields.... I've search all over and its seems to be the TAB ASCII field being imported but how do I remove...

Hey Stopher I have another question. What would I do if the ODO goes over 1000000? And quite a few of their trucks go over that..... The statement you helped me with selects the highest ODO reading as the PrevOdo and then it screws the whole thing up.....? Any ideas?

you're a legend!

thanks for the reply....the reason I want to keep the date and not the time is due to the time not being necessary.... But if I kept both, how would I search for the date in a field like that?

I have a CSV file that is going to be imported into a DB. the CSV file has a field that has a date & time stamp and I need to be able to store this file as 2 seperate fields.... the field would look something like this: 5/10/2006 17:00 I would like to store the datestamp and possibly the...

stopher.... thats exactly what I was looking for. You mention that getting the Odometer reading would be the same idea but what would I use in stead of Datediff??? Is there something similar to Datediff but for numbers in stead of dates?

howdy all!! I'm sure its pretty easy but I've got no idea ho to do this.... I've got a DB that imports a CSV file with a few hundred records. I run some queries on the data and kick out some Excel reports. The question I have is that the CSV file has a date field which is in yymmdd format but...

That is kinda what I was thinking but how would I do it for each fleet_num (ie. truck number?) What I need to do is find out how many days or kilometres between "B" Services per fleet_num which is linked to tblFleet.fleet_num.... Not sure if you get my drift???:confused:

sorry FOFA......someone else replied to me and asked if I had a primary key!!! I answered to you by mstake.... i'm pretty much going mad trying this out though.... fofa, if you could help me on this one???? I'm going to have to join from one table to the next and show the most recent 5...

Hi FOFA I do have a primary key in the table. its "ID"

Hi guys bit of a newbie here....but could you pls help me on this one!!! Í have a table that looks kinda like this: SRVDate - Date/Time Fleet_Num - Text Odo - number ServiceType - Text ServicedBy - Text DiffOils - YES/NO Gearbox_Oils - YES/NO ValveAdjust -YES/NO I need to extact the fleet...

G'day Colin thanks for the reply here's the the list of fields: tblFleet id fleet_Num Fleet_type Bearing_Next Bearing_Last In_Yard tblService id SrvDate Fleet_Num Odometer ServiceType ServicedBy DiffOils GearBoxOils ValveAdjust What I need to do is get a list of each tblFleet.fleet_Num and...

Hi Guys I'm kind of a newbie to Access but am learning :D I've found myself stuck with a join statement I have 2 tables: tblFleet & tblService I need to find the most recent service date from tblService for each entry under tblFleet.... This is my code thus far, but it shows all the records...