Help with simple vba

[mejia.j88]

upon running the query, #Error is shown in the column End_of_lot (i changed it from End to avoid trouble),



one question: what exactly is the last part of the sql that says As EndOfLot?

[Robeen]

'EndOfLot' is the new name I gave to the Column that has the "Yes" or "No". I'm saying give me the data from that column in the table and name the column header 'EndOfLot'.
You can call it whatever you want - but not the same name as the field itself [Access will tell you there is a 'circular reference'].

In your Label Report - go to the field that is giving you that error - right-click and go to Properties.
Click the 'Data' Tab.
From the Drop Down in the 'Control Source' row - select your 'EndOfLot' field [or whatever you decide to name it].

Now - run your report and make sure it is working.

If the report is not working . . . is your Query itself running? On its own?

[mejia.j88]

the #error is in the query under the column EndOfLot when i view it in datasheet view.

thanks,

[Robeen]

hmm . . . this usually means that there is a data-type mismatch . . .
You have a Boolean [True/False] field and I am trying to force a String into there.

Ok - try this:
Take the IIF statement off your End_Of_Lot field.
Put it back to just the actual field name.

Now - create a new field to the right and put something like this in there:
EndOfLot_Text: IIF(End_Of_Lot = 0, "Yes", "No")

Where I had:
End_Of_Lot = 0
make sure you have the name of your actual end-of-lot field.

then you'll have to point your report to the new field you created.

Hope this works!

[RayMilhon]

In the report in the textbox where it is displaying the -1,0 change the control source to =IIF([myend],"Yes","False") Sorry but I just can't use reserved words as field names.

[mejia.j88]

Thank you all so much for your help!

[Robeen]

Which solution did you end up using?

I liked Ray's suggestion. It seemed a lot more direct and simple than what I was suggesting! I wish I had thought of approaching it that way!