access 2007 query

[sadiyakhan]

DATES £ CASH £ CREDIT INBOUND OUTBOUND TOTALS
01/02/2010 £20.98 £20.00 £20.00 £10.00 ------
02/02/2010 £20.00 £20.00 £303.00 £30.00 ------

Hi,

In access 2007 , how can i get the total of cash, credit, inbound, outbound, in totals colunm but in same row . not at the bottom , paticular day transaction total in same row.

[nico5038]

Put the algorithm in a query like:

Select cash + credit + inbound + outbound as Total from tblX;

Nic;o)

[sadiyakhan]

hi,

A box appears asking for Enter parameter value , now what is that?

Thank you.

[nico5038]

You're using a field name that's not in the table/query. So in general it's a typo...

Nic;o)