Count down please HELP

[Jaharul]

Hi All

I want to subtract a rolling form which is updated daily against a budgeted figure but i jus cant get it to work please help. Its basically like a stock system when an item is sold the quantity in stock is reduced.

Many thanks to the helper.

 

[miccysoft]

give us more details ie cell references and we will take a look

 

[Jaharul]

Its basically done on MS Access. I got two tables one containing a budget stating the number of flights that can be taken over the year. The table contains data showing an upto date record of how many flights are being taken. Ihave created a query linking these two tables together and have created a report but i cant get the budgeted figure to decrease as the other table is updated. Is that any clearer?

 

[miccysoft]

yep much but im not sure. when im helping with access im a little out of my depth

 

[Jaharul]

Ooooooooo thanks for your help anyway.

 

[bat17]

In the query create a new field and take one value form the other, something like:-
Balance:[field1]-[field2]


HTH

Peter

 

[Jaharul]

it dont work bat

 

[bat17]

In what way doesn't it work? not the figures you expected? some sort of error message?
Can you give a bit more detail of what you are doing and post the SQL of your query please

Peter

 

[Jaharul]

basically i put all my requied fields in the query n add another two fields as u told me to and the error message which came up said that the query does not a specified expression

 

[bat17]

Can you post the SQL for your query, without the exrtra fields, and let me know which are the two fields you want to do the maths on please.

Peter