Help with adding the values in two columns in a query.

[HTFC]

Hi all,



Bit of a newbie here to both this forum and access as a whole.

As soon as I got home today I was greeted by this problem by my second job. So because of this please help and let me get to bed!

There are two columns from two tables, one called fd_goals and another called fd_goalsnew. What I need to do is in a new column in the design view maybe (I am sure this is where it goes) is write some formula to add the two together.

I can do this using a text box in a report but I need that text box to be the lead sorting box and ascend in order - another area I need to study.

I am so sure that it is using the formula sum or total but I am getting so tired that I can hardly concentrate any more.

Thanks in advance for any help.

[HTFC]

I also ment to put that I have searched the forum already but cannot find an answer although as stated, I am so tired that I am probably missing the blatently obvious. If so I apologise in advance.

[Bob Fitz]

Try this in the "Field" row (that's the first line) of the third column:

TotalGoals:Nz([fd_goals],0) + Nz([fd_goalsnew],0)

This is untested but it should add the two fields together in a third column called "TotalGoals". The Nz() function will convert any Null values to 0.
I hope you feel better for the sleep

[HTFC]

Genius, thank you so much - I really appreciate it! I got the code but would never have got the Null values in a million years.

[Bob Fitz]

Genius, thank you so much - I really appreciate it! I got the code but would never have got the Null values in a million years.

Thanks for the compliment, but I am no genius. I've just spent too much time nosing around various Access forums and learnt something along the way that you didn't know until now. Glad to help.