Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set DataType in a Query Expression

Status
Not open for further replies.
kire1971

kire1971

Technical User
May 13, 2003
6
US
I'm defining a new field in a query using the expression below. I would like it to be stored as a memo field. Right now it defaults to a text field with a 255 character limit upon export.

OSM-Description: IIf([Links + Coupons.Description] Is Null,"",Replace([Links + Coupons.Description],"233","762"))

Is there a simple parameter to add to the expression or another way to make this a memo field?

Thanks.
 
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
523
strongm
strongm
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
3K
combo
combo
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
322
mikrom
mikrom
combo
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
417
combo
combo
serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
960
serino
serino

Part and Inventory Search

Sponsor

Back
Top