tool required to convert

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 [email protected]
--->[email protected] 05/12/2006 18:25:43 Local

Output should be:

xyz [email protected] 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
 
S

strive4peace

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

*
 
Top