repair expression in access 2003

[keepout]

I fired up my db in access 2007. it has an expression

=[Title] & " & " &[title01]

when running the db in access 2003, the expression fails with $#Name or something like that.
If I enter title01 it works fine, if I use Title it works fine.

The expression is verbatim from the access 2003 help page.

=[FirstName] & " " & [LastName] Displays the values of the FirstName and LastName fields, separated by a space.

Running the 2003 db in access 2007, it works fine. My confidence in M$ isn't up there where I'm ready to use JUST a 2007 DB.
I tried the SAVE as access 2003 db from 2007. And this is what happened. My expression is now useless.

Any way to repair this DB so I can once again run it in access 2003 ?

 

[tina]

if you copied/pasted the expression straight from your database, then you
need to add a space after the last ampersand, as

=[Title] & " & " & [title01]

hth


I fired up my db in access 2007. it has an expression

=[Title] & " & " &[title01]

when running the db in access 2003, the expression fails with $#Name or
something like that.
If I enter title01 it works fine, if I use Title it works fine.

The expression is verbatim from the access 2003 help page.

=[FirstName] & " " & [LastName] Displays the values of the FirstName and
LastName fields, separated by a space.

Running the 2003 db in access 2007, it works fine. My confidence in M$ isn't
up there where I'm ready to use JUST a 2007 DB.
I tried the SAVE as access 2003 db from 2007. And this is what happened. My
expression is now useless.

Any way to repair this DB so I can once again run it in access 2003 ?

 

[Chris2]

I fired up my db in access 2007. it has an expression

=[Title] & " & " &[title01]

when running the db in access 2003, the expression fails with $#Name or
something like that.
If I enter title01 it works fine, if I use Title it works fine.

The expression is verbatim from the access 2003 help page.

=[FirstName] & " " & [LastName] Displays the values of the FirstName and
LastName fields, separated by a space.

Running the 2003 db in access 2007, it works fine. My confidence in M$ isn't
up there where I'm ready to use JUST a 2007 DB.
I tried the SAVE as access 2003 db from 2007. And this is what happened. My
expression is now useless.

Any way to repair this DB so I can once again run it in access 2003 ?

keepout,

=[Title] & " & " &[title01]

There is an extra ampersand between the quotes.

Try:

=[Title] & " " & [title01]


Sincerely,

Chris O.

 

[keepout]

I fired up my db in access 2007. it has an expression

=[Title] & " & " &[title01]

when running the db in access 2003, the expression fails with $#Name or
something like that.
If I enter title01 it works fine, if I use Title it works fine.

The expression is verbatim from the access 2003 help page.

=[FirstName] & " " & [LastName] Displays the values of the FirstNameand
LastName fields, separated by a space.

Running the 2003 db in access 2007, it works fine. My confidence in M$isn't
up there where I'm ready to use JUST a 2007 DB.
I tried the SAVE as access 2003 db from 2007. And this is what happened. My
expression is now useless.

Any way to repair this DB so I can once again run it in access 2003 ?

keepout,

=[Title] & " & " &[title01]

There is an extra ampersand between the quotes.

Try:

=[Title] & " " & [title01]

It fixed itself. the 'extra ampersand' is between the quotes used by the expression to tell access to print the '&' verbatim as text same as it prints the 'space' between the quotes. The quotes are how you add text tothe expression.
the finished product = title & title01