tool required to convert

  • Thread starter Thread starter subha
  • Start date Start date
S

subha

Hi ,

Can Someone help me out to Create a tool in Access which Converts
Unaligned data to aligned data in Access.

example of unaligned data:

xyz (e-mail address removed)
--->[email protected] 05/12/2006 18:25:43 Local

Output should be:

xyz (e-mail address removed) 05/12/2006 18:25:43

file consist of lotsa data and which are not in order, please do help
me to get above output in Access.

thanks in advance,
subha
 
The TRIM function removes leading and trailing spaces

CombinedField -->
trim(nz(field1))
& " "
& trim(nz(field2))
& " "
& trim(nz(field3))

nz converts a null to zero or empty string (or whatever you
specify in the optional second parameter)

trim will throw an error if the expression to trim is null


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
Back
Top