Error on Access Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following in a field:
=[Section] & " / " & [Row] & " / " & [Seats]
and the response is "#Name?" when it should be something to the affect of:
"LO-D / A / 1, 3"

If I only put: =" / " & [Row] & " / " & [Seats]
it works fine, and if I put [Section] in its own field, it works fine.
Nothing is misspelled...I've tried it on several occassions. What am I
missing?
 
Hi Stephanie.

Reports have a propety named Section, and I think you have confused Access
by using a field with the same name.

Create a query, so you can alias the field with a different name.
For example, type this into the Field row in your query:
SecName: [Section]
Save the query.
Set the report's RecordSource property to this query.
Then try this in your text box:
=[SecName] & " / " & [Row] & " / " & [Seats]

It would also be worth checking the Name of this text box. It must not be
the same name as one of the fields. Try giving it a name like:
txtSectionRowSeats

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

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

message
news:[email protected]...
 
Back
Top