[MS_AccessPros] Hard coding a character return in MS Access 2003 Query

 

I have a feild that a user now wants to split into two different fields in a report. I don't have the option of using two different fields in a table as it is one field.

For example 12345/67899 needs to look like:
12345/
67899

The lengths of the fields can vary for example I could have 1/3, or 12/123, or 1/ (yes thats a blank or null), and there might not be anything in the field at all.

In a query, how can I code a hard return after the "/", taking into account that there might not be a fraction (null) in the field.

Thanks in advance,
John F

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 8
• New Links 1
• New Files 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___