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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Memo displayed in Reports

Status
Not open for further replies.
ptiernan

ptiernan

IS-IT--Management
Apr 29, 2003
55
GB
I have an Access 97 database that has a form with a field that is in Memo format.

The problem that I am having is that I am unable to show this memo field in a report. I am getting the erorr message "Can't include Memo or OLE Object when you select unique values".

Can anyone help.
 
Sort by date Sort by votes
Do you have to have unique values in your sql. It sounds like you have distinct row set in your SQL. I don't know why this would be a problem, but that's what it looks like the problem is.

Mark P.
Providing Low Cost Powerful Point of Sale Solutions.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Teri Bridges
  • Locked
  • Question
Reports Combobox-List box
Replies
1
Views
410
dhookom
dhookom
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
511
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
575
dhookom
dhookom
breezett93
  • Locked
  • Question
What should be multiple reports is becoming one report with multiple pages 1
Replies
13
Views
364
dhookom
dhookom
RonMcIntire
  • Locked
  • Question
Adding variables to a control in a footer 1
Replies
4
Views
286
sxschech
sxschech

Part and Inventory Search

Sponsor

Back
Top