Search results

The zip code field includes 5 numbers plus a dash which is followed by 4 numbers. I want to use the format function to reformat the zip code field so the dash is removed and the result includes only 9 numbers. How can I do this ? ZIP CODE1 = 53918-6432 ZIP CODE2 = 539186432

FYI, my job is not in jeapordy. Quite the opposite.

Thanks everyone for your expert advise. It has been greatly appreciated.

Help !!!!!!!!!!!!!

We bill each customer four equal installment invoices. The installment data is stored in a table (please see file attachment). I need to assign an installment sequence number for each invoice in the table. Each customer would have installment sequence number of 1,2,3,4 without exception. How...

Counting Records Sequentially I created Query A which reads ARFILE Table. Query A has an INSTALL SEQ field which counts the INVOICE field in the ARFILE table as follows. The INVOICE field is a unique invoice number for each installment. INSTALL SEQ: DCount("INVOICE","ARFILE") The field...

We bill each customer four equal installment invoices. The installment data is stored in a table (please see file attachment). I need to assign an installment sequence number for each invoice in the table. Each customer would have installment sequence number of 1,2,3,4 without exception. How...

Is there a simple query expression that creates an autonumber field in the query. The field would work the same as an autonumber in a table where it sequentially assigns a unique number for each record and increases by 1 for each record ? I need to put this in a query rather than a table.

How can I merge the data from three text files into one text file ? I have three separate queries that each have completely different fields and field formats. I export each of these queries to three separate text files. How can I merge all records into one text file? I need a simple solution...

I need a solution that is not dependent on hard-coded language, such as using standard functions or expressions. I've tried using the advanced specifications, but have not found one that works.

I greatly appreciate your outstanding expertise. Thanks RuralGuy and raskew. You've solved this issue. I hope it's not asking too much to review my other inquiry in the "general" thread regarding Exporting Querys without Delimiters. Once again, thank you so much !

I'm creating a huge text file by exporting a query consisting of 25 fields. The text file must be formated so that each record consists of a single string including all 25 fields concatenated together. Each record must have a fixed length of 600. I've already converted the format of each field...

The following expression is very close, however if the day of the year is less than three digits I lose the leading zeroes that ensure a total field length of 13. Format(now(), "yyyyyHhNnSs") For example January 1, 2000 at 06:23:05 AM Incorrect Result: 20001062305 Correct Result...

I tried the following expression for July 9, 5:09:05pm and got a result that is close. Instead of Wednesday, the result should be the 191st day of the year 2008. Expression: Julian Date: Format(Now(),"yyyydddhhmmss") Incorrect Result: 2008Wed170905 Correct Result: 2008191170905 How can I...

How can I convert today's date to Julian Date and Military Time format. I want to use a standard function or expression, since I won't be using any hard-coded language. Time Stamp: Field Length 13, Format:YYYYDDDHHMMSS Example: April 11, 2000, 6:02:23pm = 2000102180223

Add Text Spaces :) I would like to thank all the respondents for your excellent recommendations. Thanks WayneRyan, raskew, MSAccessRookie, Alc !! The problem is solved.

Add Text Spaces I tried the following expression, however some results include 34 characters and others include 35. Trim([POLICY INSURED NAME]) & Space(35-Len([POLICY INSURED NAME])) How can I guarantee 35 characters in all records ?

I need a simple solution that uses a standard MS Access function or expression, since I won't be using any hard-coded language.

A query text field called "customer name" has a variable length. I want to convert "customer name" to a fixed length field including exactly 35 characters by adding spaces at the end of the field. How can I do this ?

Thank you sir.