Getting "Invalid bracketing of name" error.

[bradp1979]

There are 2 textboxes for the input, but they're on a different form. The two textboxes are on frmEvent, on a subform, and I need the total to be in a column within a textbox on a different form, FrmClient.

Right now It's almost right. When I have data in both the text boxes on frmEvent, it does show on frmClient, but it shows incorrectly. For example, if I have 2 in one text box, and 30 in the other, it shows "230" on frmClient.

[June7]

Post the expression you are using. Apparently it is concatenating because both values are seen as strings. The + is a valid concatenation operator (holdover from ancient BASIC).

What do you mean by column of textbox? Textbox does not have columns.

[bradp1979]

Come to think of it, it's probably not necessarily columns, but rather a string of information taken form the query.

The expression I'm using is: Cars Parked: [Actual#CarsGarage] & [Actual#CarsOutside] - I can't use + for some reason. When I do, I don't get anything under "Cars Parked."

Here is the textbox and the formatting thereof:

[June7]

& is concatenation operator, regardless if data is text or number or date, it will concatenate, not perform arithmetic.

Review posts 6 and 12.

Expression in textbox:

= Nz([Actual#CarsGarage], 0) + Nz([Actual#CarsOutside], 0)

[bradp1979]

Perfect. You rock!!

Now it works perfectly.

Out of curiosity, what does "Nz" do?

[June7]

Did you review the Allen Browne link?

Nz() is an Access function that provides an alternative value if a field is null.

[bradp1979]

I did, and now I understand. What made you choose Nz as opposed to the IIf (MyField is Null, 0, MyField)?

[June7]

I showed textbox expression, simpler. However, if you need to use this calculated value in another calc, the IIf() approach might be safer, otherwise:

= Val(Nz([Actual#CarsGarage], 0) + Nz([Actual#CarsOutside], 0))