Error - Undefined function'[Str$]' in expression while running que

V

VC

Windows XP Pro
MS Office 2002 (XP)

Getting this error message in a database I've used for years without
problems. Have unistalled office, rebooted, and reinstalled. Same problem.

H-E-L-P !!!
 
V

VC

Included all references mentioned in Browne artricle, but same problem.

Here's the SQL:

SELECT [- Catalog Masters].Title, [- Catalog Masters].Ounces, [- Catalog
Masters].Lbs_Oz, [- Catalog Masters].Grams, [- Catalog Mailer
Weights].MediaEnvSmall_Grams, [- Catalog Mailer Weights].MediaEnvSmall_Oz, [-
Catalog Mailer Weights].MediaEnvLarge_Grams, [- Catalog Mailer
Weights].MediaEnvLarge_Oz, [- Catalog Mailer Weights].FlateRateEnv_Grams, [-
Catalog Mailer Weights].FlateRateEnv_Oz,
IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[MediaEnvSmall_Oz]+0.5)) & " oz")
AS SmallMailer, IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[FlateRateEnv_Oz]+0.5)) & " oz")
AS FlatRateEnv
FROM [- Catalog Masters], [- Catalog Mailer Weights]
ORDER BY [- Catalog Masters].Title;
 
P

Pete

Exclude the square brackets, i.e. Str$. Square brackets are used to indicate
fields and are used when punctuation or spaces have been used in field names
(which is not good practice).
--
Peter Schmidt
Pert, Australia


VC said:
Included all references mentioned in Browne artricle, but same problem.

Here's the SQL:

SELECT [- Catalog Masters].Title, [- Catalog Masters].Ounces, [- Catalog
Masters].Lbs_Oz, [- Catalog Masters].Grams, [- Catalog Mailer
Weights].MediaEnvSmall_Grams, [- Catalog Mailer Weights].MediaEnvSmall_Oz, [-
Catalog Mailer Weights].MediaEnvLarge_Grams, [- Catalog Mailer
Weights].MediaEnvLarge_Oz, [- Catalog Mailer Weights].FlateRateEnv_Grams, [-
Catalog Mailer Weights].FlateRateEnv_Oz,
IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[MediaEnvSmall_Oz]+0.5)) & " oz")
AS SmallMailer, IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[FlateRateEnv_Oz]+0.5)) & " oz")
AS FlatRateEnv
FROM [- Catalog Masters], [- Catalog Mailer Weights]
ORDER BY [- Catalog Masters].Title;


Allen Browne said:
Could be a problem with references:
http://allenbrowne.com/ser-38.html

If that's not it, switch your query to SQL View, copy the SQL statement, and
post in a reply.
Click to expand...
Click to expand...
 
D

Duane Hookom

Try remove the []s and $.
SELECT [- Catalog Masters].Title, [- Catalog Masters].Ounces,
[- Catalog Masters].Lbs_Oz, [- Catalog Masters].Grams,
[- Catalog Mailer Weights].MediaEnvSmall_Grams,
[- Catalog Mailer Weights].MediaEnvSmall_Oz,
[- Catalog Mailer Weights].MediaEnvLarge_Grams,
[- Catalog Mailer Weights].MediaEnvLarge_Oz,
[- Catalog Mailer Weights].FlateRateEnv_Grams,
[- Catalog Mailer Weights].FlateRateEnv_Oz,
IIf([Ounces]>0,Str(Int([Ounces]/16)) & " lbs " &
Str(Round([Ounces]-(Int([Ounces]/16)*16)+[MediaEnvSmall_Oz]+0.5)) & " oz")
AS SmallMailer,
IIf([Ounces]>0,Str(Int([Ounces]/16)) & " lbs " &
Str(Round([Ounces]-(Int([Ounces]/16)*16)+[FlateRateEnv_Oz]+0.5)) & " oz")
AS FlatRateEnv
FROM [- Catalog Masters], [- Catalog Mailer Weights]
ORDER BY [- Catalog Masters].Title;

--
Duane Hookom
Microsoft Access MVP


Pete said:
Exclude the square brackets, i.e. Str$. Square brackets are used to indicate
fields and are used when punctuation or spaces have been used in field names
(which is not good practice).
--
Peter Schmidt
Pert, Australia


VC said:
Included all references mentioned in Browne artricle, but same problem.

Here's the SQL:

SELECT [- Catalog Masters].Title, [- Catalog Masters].Ounces, [- Catalog
Masters].Lbs_Oz, [- Catalog Masters].Grams, [- Catalog Mailer
Weights].MediaEnvSmall_Grams, [- Catalog Mailer Weights].MediaEnvSmall_Oz, [-
Catalog Mailer Weights].MediaEnvLarge_Grams, [- Catalog Mailer
Weights].MediaEnvLarge_Oz, [- Catalog Mailer Weights].FlateRateEnv_Grams, [-
Catalog Mailer Weights].FlateRateEnv_Oz,
IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[MediaEnvSmall_Oz]+0.5)) & " oz")
AS SmallMailer, IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[FlateRateEnv_Oz]+0.5)) & " oz")
AS FlatRateEnv
FROM [- Catalog Masters], [- Catalog Mailer Weights]
ORDER BY [- Catalog Masters].Title;


Allen Browne said:
Could be a problem with references:
http://allenbrowne.com/ser-38.html

If that's not it, switch your query to SQL View, copy the SQL statement, and
post in a reply.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


Windows XP Pro
MS Office 2002 (XP)

Getting this error message in a database I've used for years without
problems. Have unistalled office, rebooted, and reinstalled. Same
problem.

H-E-L-P !!!
Click to expand...
Click to expand...
Click to expand...
 
V

VC

Yikes!

Suggestion from Pete and Duane seemed like a red herring, but was useful
because then I then noticed that the Str$ function was somehow enclosed in
square brackets, "[Str$]". Removed the square brackets from the function and
problem solved:

OLD (and BAD):

SELECT [- Catalog Masters].Title, [- Catalog Masters].Ounces, [- Catalog
Masters].Lbs_Oz, [- Catalog Masters].Grams, [- Catalog Mailer
Weights].MediaEnvSmall_Grams, [- Catalog Mailer Weights].MediaEnvSmall_Oz, [-
Catalog Mailer Weights].MediaEnvLarge_Grams, [- Catalog Mailer
Weights].MediaEnvLarge_Oz, [- Catalog Mailer Weights].FlateRateEnv_Grams, [-
Catalog Mailer Weights].FlateRateEnv_Oz,
IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[MediaEnvSmall_Oz]+0.5)) & " oz")
AS SmallMailer, IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[FlateRateEnv_Oz]+0.5)) & " oz")
AS FlatRateEnv
FROM [- Catalog Masters], [- Catalog Mailer Weights]
ORDER BY [- Catalog Masters].Title;

NEW, FIXED:

SELECT [- Catalog Masters].Title, [- Catalog Masters].Ounces, [- Catalog
Masters].Lbs_Oz, [- Catalog Masters].Grams, [- Catalog Mailer
Weights].MediaEnvSmall_Grams, [- Catalog Mailer Weights].MediaEnvSmall_Oz, [-
Catalog Mailer Weights].MediaEnvLarge_Grams, [- Catalog Mailer
Weights].MediaEnvLarge_Oz, [- Catalog Mailer Weights].FlateRateEnv_Grams, [-
Catalog Mailer Weights].FlateRateEnv_Oz,
IIf([Ounces]>0,Str$(Int([Ounces]/16)) & " lbs " &
Str$(Round([Ounces]-(Int([Ounces]/16)*16)+[MediaEnvSmall_Oz]+0.5)) & " oz")
AS SmallMailer, IIf([Ounces]>0,Str$(Int([Ounces]/16)) & " lbs " &
Str$(Round([Ounces]-(Int([Ounces]/16)*16)+[FlateRateEnv_Oz]+0.5)) & " oz") AS
FlatRateEnv
FROM [- Catalog Masters], [- Catalog Mailer Weights]
ORDER BY [- Catalog Masters].Title;


Duh. The error message was, in fact, telling me exactly what was wrong.
Too bad I didn't believe it.

Question for all: How could this have happened, if no changes were made to
the database? I even tried out a year-old backup and got the same error.


Try remove the []s and $.
SELECT [- Catalog Masters].Title, [- Catalog Masters].Ounces,
[- Catalog Masters].Lbs_Oz, [- Catalog Masters].Grams,
[- Catalog Mailer Weights].MediaEnvSmall_Grams,
[- Catalog Mailer Weights].MediaEnvSmall_Oz,
[- Catalog Mailer Weights].MediaEnvLarge_Grams,
[- Catalog Mailer Weights].MediaEnvLarge_Oz,
[- Catalog Mailer Weights].FlateRateEnv_Grams,
[- Catalog Mailer Weights].FlateRateEnv_Oz,
IIf([Ounces]>0,Str(Int([Ounces]/16)) & " lbs " &
Str(Round([Ounces]-(Int([Ounces]/16)*16)+[MediaEnvSmall_Oz]+0.5)) & " oz")
AS SmallMailer,
IIf([Ounces]>0,Str(Int([Ounces]/16)) & " lbs " &
Str(Round([Ounces]-(Int([Ounces]/16)*16)+[FlateRateEnv_Oz]+0.5)) & " oz")
AS FlatRateEnv
FROM [- Catalog Masters], [- Catalog Mailer Weights]
ORDER BY [- Catalog Masters].Title;

--
Duane Hookom
Microsoft Access MVP


Pete said:
Exclude the square brackets, i.e. Str$. Square brackets are used to indicate
fields and are used when punctuation or spaces have been used in field names
(which is not good practice).
--
Peter Schmidt
Pert, Australia


VC said:
Included all references mentioned in Browne artricle, but same problem.

Here's the SQL:

SELECT [- Catalog Masters].Title, [- Catalog Masters].Ounces, [- Catalog
Masters].Lbs_Oz, [- Catalog Masters].Grams, [- Catalog Mailer
Weights].MediaEnvSmall_Grams, [- Catalog Mailer Weights].MediaEnvSmall_Oz, [-
Catalog Mailer Weights].MediaEnvLarge_Grams, [- Catalog Mailer
Weights].MediaEnvLarge_Oz, [- Catalog Mailer Weights].FlateRateEnv_Grams, [-
Catalog Mailer Weights].FlateRateEnv_Oz,
IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[MediaEnvSmall_Oz]+0.5)) & " oz")
AS SmallMailer, IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[FlateRateEnv_Oz]+0.5)) & " oz")
AS FlatRateEnv
FROM [- Catalog Masters], [- Catalog Mailer Weights]
ORDER BY [- Catalog Masters].Title;


:

Could be a problem with references:
http://allenbrowne.com/ser-38.html

If that's not it, switch your query to SQL View, copy the SQL statement, and
post in a reply.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


Windows XP Pro
MS Office 2002 (XP)

Getting this error message in a database I've used for years without
problems. Have unistalled office, rebooted, and reinstalled. Same
problem.

H-E-L-P !!!
Click to expand...
Click to expand...
Click to expand...
 
D

Duane Hookom

I don't use the $ in string functions. I believe it's there for backward
compatibility.

I think the []s were added by the naming convention gods who you angered by
starting a table/query name with a "-" and your liberal use of spaces in
names ;-)

--
Duane Hookom
Microsoft Access MVP


VC said:
Yikes!

Suggestion from Pete and Duane seemed like a red herring, but was useful
because then I then noticed that the Str$ function was somehow enclosed in
square brackets, "[Str$]". Removed the square brackets from the function and
problem solved:

OLD (and BAD):

SELECT [- Catalog Masters].Title, [- Catalog Masters].Ounces, [- Catalog
Masters].Lbs_Oz, [- Catalog Masters].Grams, [- Catalog Mailer
Weights].MediaEnvSmall_Grams, [- Catalog Mailer Weights].MediaEnvSmall_Oz, [-
Catalog Mailer Weights].MediaEnvLarge_Grams, [- Catalog Mailer
Weights].MediaEnvLarge_Oz, [- Catalog Mailer Weights].FlateRateEnv_Grams, [-
Catalog Mailer Weights].FlateRateEnv_Oz,
IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[MediaEnvSmall_Oz]+0.5)) & " oz")
AS SmallMailer, IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[FlateRateEnv_Oz]+0.5)) & " oz")
AS FlatRateEnv
FROM [- Catalog Masters], [- Catalog Mailer Weights]
ORDER BY [- Catalog Masters].Title;

NEW, FIXED:

SELECT [- Catalog Masters].Title, [- Catalog Masters].Ounces, [- Catalog
Masters].Lbs_Oz, [- Catalog Masters].Grams, [- Catalog Mailer
Weights].MediaEnvSmall_Grams, [- Catalog Mailer Weights].MediaEnvSmall_Oz, [-
Catalog Mailer Weights].MediaEnvLarge_Grams, [- Catalog Mailer
Weights].MediaEnvLarge_Oz, [- Catalog Mailer Weights].FlateRateEnv_Grams, [-
Catalog Mailer Weights].FlateRateEnv_Oz,
IIf([Ounces]>0,Str$(Int([Ounces]/16)) & " lbs " &
Str$(Round([Ounces]-(Int([Ounces]/16)*16)+[MediaEnvSmall_Oz]+0.5)) & " oz")
AS SmallMailer, IIf([Ounces]>0,Str$(Int([Ounces]/16)) & " lbs " &
Str$(Round([Ounces]-(Int([Ounces]/16)*16)+[FlateRateEnv_Oz]+0.5)) & " oz") AS
FlatRateEnv
FROM [- Catalog Masters], [- Catalog Mailer Weights]
ORDER BY [- Catalog Masters].Title;


Duh. The error message was, in fact, telling me exactly what was wrong.
Too bad I didn't believe it.

Question for all: How could this have happened, if no changes were made to
the database? I even tried out a year-old backup and got the same error.


Try remove the []s and $.
SELECT [- Catalog Masters].Title, [- Catalog Masters].Ounces,
[- Catalog Masters].Lbs_Oz, [- Catalog Masters].Grams,
[- Catalog Mailer Weights].MediaEnvSmall_Grams,
[- Catalog Mailer Weights].MediaEnvSmall_Oz,
[- Catalog Mailer Weights].MediaEnvLarge_Grams,
[- Catalog Mailer Weights].MediaEnvLarge_Oz,
[- Catalog Mailer Weights].FlateRateEnv_Grams,
[- Catalog Mailer Weights].FlateRateEnv_Oz,
IIf([Ounces]>0,Str(Int([Ounces]/16)) & " lbs " &
Str(Round([Ounces]-(Int([Ounces]/16)*16)+[MediaEnvSmall_Oz]+0.5)) & " oz")
AS SmallMailer,
IIf([Ounces]>0,Str(Int([Ounces]/16)) & " lbs " &
Str(Round([Ounces]-(Int([Ounces]/16)*16)+[FlateRateEnv_Oz]+0.5)) & " oz")
AS FlatRateEnv
FROM [- Catalog Masters], [- Catalog Mailer Weights]
ORDER BY [- Catalog Masters].Title;

--
Duane Hookom
Microsoft Access MVP


Pete said:
Exclude the square brackets, i.e. Str$. Square brackets are used to indicate
fields and are used when punctuation or spaces have been used in field names
(which is not good practice).
--
Peter Schmidt
Pert, Australia


:

Included all references mentioned in Browne artricle, but same problem.

Here's the SQL:

SELECT [- Catalog Masters].Title, [- Catalog Masters].Ounces, [- Catalog
Masters].Lbs_Oz, [- Catalog Masters].Grams, [- Catalog Mailer
Weights].MediaEnvSmall_Grams, [- Catalog Mailer Weights].MediaEnvSmall_Oz, [-
Catalog Mailer Weights].MediaEnvLarge_Grams, [- Catalog Mailer
Weights].MediaEnvLarge_Oz, [- Catalog Mailer Weights].FlateRateEnv_Grams, [-
Catalog Mailer Weights].FlateRateEnv_Oz,
IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[MediaEnvSmall_Oz]+0.5)) & " oz")
AS SmallMailer, IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[FlateRateEnv_Oz]+0.5)) & " oz")
AS FlatRateEnv
FROM [- Catalog Masters], [- Catalog Mailer Weights]
ORDER BY [- Catalog Masters].Title;


:

Could be a problem with references:
http://allenbrowne.com/ser-38.html

If that's not it, switch your query to SQL View, copy the SQL statement, and
post in a reply.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


Windows XP Pro
MS Office 2002 (XP)

Getting this error message in a database I've used for years without
problems. Have unistalled office, rebooted, and reinstalled. Same
problem.

H-E-L-P !!!
Click to expand...
Click to expand...
Click to expand...
 
D

David W. Fenton

I don't use the $ in string functions. I believe it's there for
backward compatibility.
Click to expand...

I think they exist not just for backward compatibility. The standard
string conversion functions return a variant and the $ versions
return a string. This means the former are safe with Nulls, while
the latter are not.

If it's important that you return the strictest possible data type,
you should use the $ versions. I also seem to recall there was some
kind of performance advantage with the $ versions.

FWIW, I don't use any of them. But the A97 help files explains their
purpose thus:

Some functions have two versions: one that returns a Variant data
type and one that returns a String data type. The Variant
versions are more convenient because variants handle conversions
between different types of data automatically. They also allow
Null to be propagated through an expression. The String versions
are more efficient because they use less memory.

Consider using the String version when:

· Your program is very large and uses many variables.
· You write data directly to random-access files.

....and then goes on to list all the $ functions:

Chr$
ChrB$
*Command$
CurDir$
Date$
Dir$
Error$
Format$
Hex$
Input$
InputB$
LCase$
Left$
LeftB$
LTrim$
Mid$
MidB$
Oct$
Right$
RightB$
RTrim$
Space$
Str$
String$
 
C

charlie

royd\ DeVito
Duane Hookom said:
I don't use the $ in string functions. I believe it's there for backward
compatibility.

I think the []s were added by the naming convention gods who you angered
by
starting a table/query name with a "-" and your liberal use of spaces in
names ;-)

--
Duane Hookom
Microsoft Access MVP


VC said:
Yikes!

Suggestion from Pete and Duane seemed like a red herring, but was useful
because then I then noticed that the Str$ function was somehow enclosed
in
square brackets, "[Str$]". Removed the square brackets from the function
and
problem solved:

OLD (and BAD):

SELECT [- Catalog Masters].Title, [- Catalog Masters].Ounces, [- Catalog
Masters].Lbs_Oz, [- Catalog Masters].Grams, [- Catalog Mailer
Weights].MediaEnvSmall_Grams, [- Catalog Mailer
Weights].MediaEnvSmall_Oz, [-
Catalog Mailer Weights].MediaEnvLarge_Grams, [- Catalog Mailer
Weights].MediaEnvLarge_Oz, [- Catalog Mailer Weights].FlateRateEnv_Grams,
[-
Catalog Mailer Weights].FlateRateEnv_Oz,
IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[MediaEnvSmall_Oz]+0.5)) & "
oz")
AS SmallMailer, IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[FlateRateEnv_Oz]+0.5)) & "
oz")
AS FlatRateEnv
FROM [- Catalog Masters], [- Catalog Mailer Weights]
ORDER BY [- Catalog Masters].Title;

NEW, FIXED:

SELECT [- Catalog Masters].Title, [- Catalog Masters].Ounces, [-
Catalog
Masters].Lbs_Oz, [- Catalog Masters].Grams, [- Catalog Mailer
Weights].MediaEnvSmall_Grams, [- Catalog Mailer
Weights].MediaEnvSmall_Oz, [-
Catalog Mailer Weights].MediaEnvLarge_Grams, [- Catalog Mailer
Weights].MediaEnvLarge_Oz, [- Catalog Mailer Weights].FlateRateEnv_Grams,
[-
Catalog Mailer Weights].FlateRateEnv_Oz,
IIf([Ounces]>0,Str$(Int([Ounces]/16)) & " lbs " &
Str$(Round([Ounces]-(Int([Ounces]/16)*16)+[MediaEnvSmall_Oz]+0.5)) & "
oz")
AS SmallMailer, IIf([Ounces]>0,Str$(Int([Ounces]/16)) & " lbs " &
Str$(Round([Ounces]-(Int([Ounces]/16)*16)+[FlateRateEnv_Oz]+0.5)) & "
oz") AS
FlatRateEnv
FROM [- Catalog Masters], [- Catalog Mailer Weights]
ORDER BY [- Catalog Masters].Title;


Duh. The error message was, in fact, telling me exactly what was wrong.
Too bad I didn't believe it.

Question for all: How could this have happened, if no changes were made
to
the database? I even tried out a year-old backup and got the same error.


Try remove the []s and $.
SELECT [- Catalog Masters].Title, [- Catalog Masters].Ounces,
[- Catalog Masters].Lbs_Oz, [- Catalog Masters].Grams,
[- Catalog Mailer Weights].MediaEnvSmall_Grams,
[- Catalog Mailer Weights].MediaEnvSmall_Oz,
[- Catalog Mailer Weights].MediaEnvLarge_Grams,
[- Catalog Mailer Weights].MediaEnvLarge_Oz,
[- Catalog Mailer Weights].FlateRateEnv_Grams,
[- Catalog Mailer Weights].FlateRateEnv_Oz,
IIf([Ounces]>0,Str(Int([Ounces]/16)) & " lbs " &
Str(Round([Ounces]-(Int([Ounces]/16)*16)+[MediaEnvSmall_Oz]+0.5)) & "
oz")
AS SmallMailer,
IIf([Ounces]>0,Str(Int([Ounces]/16)) & " lbs " &
Str(Round([Ounces]-(Int([Ounces]/16)*16)+[FlateRateEnv_Oz]+0.5)) & "
oz")
AS FlatRateEnv
FROM [- Catalog Masters], [- Catalog Mailer Weights]
ORDER BY [- Catalog Masters].Title;

--
Duane Hookom
Microsoft Access MVP


:

Exclude the square brackets, i.e. Str$. Square brackets are used to
indicate
fields and are used when punctuation or spaces have been used in
field names
(which is not good practice).
--
Peter Schmidt
Pert, Australia


:

Included all references mentioned in Browne artricle, but same
problem.

Here's the SQL:

SELECT [- Catalog Masters].Title, [- Catalog Masters].Ounces, [-
Catalog
Masters].Lbs_Oz, [- Catalog Masters].Grams, [- Catalog Mailer
Weights].MediaEnvSmall_Grams, [- Catalog Mailer
Weights].MediaEnvSmall_Oz, [-
Catalog Mailer Weights].MediaEnvLarge_Grams, [- Catalog Mailer
Weights].MediaEnvLarge_Oz, [- Catalog Mailer
Weights].FlateRateEnv_Grams, [-
Catalog Mailer Weights].FlateRateEnv_Oz,
IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[MediaEnvSmall_Oz]+0.5))
& " oz")
AS SmallMailer, IIf([Ounces]>0,[Str$](Int([Ounces]/16)) & " lbs " &
[Str$](Round([Ounces]-(Int([Ounces]/16)*16)+[FlateRateEnv_Oz]+0.5))
& " oz")
AS FlatRateEnv
FROM [- Catalog Masters], [- Catalog Mailer Weights]
ORDER BY [- Catalog Masters].Title;


:

Could be a problem with references:
http://allenbrowne.com/ser-38.html

If that's not it, switch your query to SQL View, copy the SQL
statement, and
post in a reply.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


Windows XP Pro
MS Office 2002 (XP)

Getting this error message in a database I've used for years
without
problems. Have unistalled office, rebooted, and reinstalled.
Same
problem.

H-E-L-P !!!
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Undefined function 'concatenate' in expression 0
Undefined function 'Left' in expression 2
How do I fix Access Error undefined function "CStr$" in expressio 1
Undefined Function 'instr' in Expression 2
Undefined function 'Left' in expression 11
Undefined function Trim in Expression 1
Undefined function '[Right$]' in expression in a query after upgra 8
Undefined function 'replace' in expression 1

Top