select statement syntax

[twcman]

what is the proper syntax for this select statement using an access database:

SELECT tlkpDonorLevel.DonorLevelID, [Lower] & " to " & [Upper] AS Range
FROM tlkpDonorLevel;

I am combining the two fields from a record to make one variable. Lower and Upper are the field names.

 

[jitter]

It seems like what you have would work fine. Is it returning an error or something?

 

[tlbroadbent]

I assume [Lower} and [Upper} are numeric. If so, you'll need to use the following syntax to convert them to text strings.

SELECT
tlkpDonorLevel.DonorLevelID,
CStr([Lower]) & " to " & CStr([Upper]) AS Range
FROM tlkpDonorLevel; Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[tlbroadbent]

Whoops! This is the SQL Server forum. You should use the following instead of what I said in the previous post.

SELECT
tlkpDonorLevel.DonorLevelID,
LTrim(Str([Lower])) & " to " & LTrim(Str([Upper])) AS Range
FROM tlkpDonorLevel; Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.