Search results

I’ve got a six-character text field with values like: 354, 7237, 10438, some three characters long, some four characters long, and some five characters long. I need to run an update query to place sufficient “zeros” in front of each value to make it a six-character value. There are 8398 records...

I’ve got a six-character length text field with values like: 354, 7237, 10438, some three-characters, some four-characters, and some five-characters. I need to run an update query to place sufficient “zeros” in front of each value to make it a six-character value. There are 8398 records to...

I have a table of Inventory items with a field called Status. The various conditions of Status are "Needs Inspection," "In Progress," and "Finished." I need to develop a form with three fields, one for each condition, with each field giving me the total of records for that condition. How should...

You nailed it, Super! That did it! You are a SuperRock!

Just tried it. The field data is typically 3456 West Elm Street (ZIP 3456). I placed "New Address:Left([Address],(InStr(1,[Address],"(")-1))," (without the quotes, of course) and the query result was 3456 West Elm Street (ZIP 2345). What should I try next? :(

:confused: Here's the problem and I understand that a few folks have responded to this already and I appreciate their effort, but the problem is still unresolved. I have a text field in a table called [Address]with data like this: 234 Elm Street (ZIP 2345). In a query, I want to rename the field...

I also removed the $ and still got the "Data mismatch..." error in this query: Left([Address],Len([Address]-9)). ???

I know you're working hard at this, but I'm still getting the "Data mismatch..." message. My query expression is:Left$([Address],Len([Address]-9)). What dya think?

I tried this and I got a "Data type mismatch in criteria expression" error message. The data is in a text format. Why this?

Thanks, but I want to get rid of the nine right-most characters.

I have an Address field with data like "235 Elm Street (ZIP2345)." In a query, I want to trim off the nine right-most characters, the (ZIP2345). What's the trick with TRIM? I've tried New Address: RTrim([Address],9), but this isn't working. Sure appreciate any help. :mad:

Hoover... How 'bout you?

I have an Acccess 97 database application that is uploaded with mainframe data, which in turn relies on LapLink software to upload the data into a hand-held device (6-year old tablet PC). We're going to purchase a new tablet PC which has an USB port on the docking station. Instead of relying on...

You're suggesting the Microsoft DAO 3.5 Object Library? Or 3.6? Or something else?

I've got an unbound combo control on a form to be used as a name drop-down listing. The "ID" is an autonumber type, the name is text, however, it blows up at use: "Compile error: Variable not defined" on the dbInteger. Any ideas? Thanks for your help. Private Sub cboFindIt_AfterUpdate() On...

Just your basic, "garden-variety" txt file with data like so: JJ,ab,B35,N,375841,01/18/2005 JJ,ab,B35,N,322871,01/18/2005 JJ,ab,B84,P,387693,01/18/2005 JJ,ab,110F,P,335096,01/18/2005. Thanx for asking. Got an idea?

ODBC will not be needed. The txt file is on the C: drive through another operation. Thanx...

I need some code to import a text file from the Desktop and create a table called Invent. How? Thanx

I need some code to import a text file from the Desktop and create a table called Invent. How? Thanx

I need a query to import a text file from the Desktop and create a table called Invent. How? Thanx