Calculation using a calculated field

[Tobias]

Hello,

I am in need of some guidance.

I have a budget database that tracks purchases. I have a query that
totals each persons purchase and I have a field in that query that
uses that SUM to determine the amount remaining in that person's
budget. It works but when I run the query it prompts me for the
name(which I want) and it prompts me for the Sum amount(which I do not
want it to do) and it doesnt matter what I put in that box it still
comes out with the correct amount remaining. - How can I get it to
not prompt for the SUM amount? I think it does this because the
query has not run and it has not been provided with the amount until
after you hit Enter.

I would also like the amount remaining displayed on a form when that
persons budget is selected. I am not sure where to start with this
one.
I appreciate any help you all can provide.
Thanks,
Tobias

[Bob Quintal]

Tobias <to*****@gmail.comwrote in
news:11*********************@z9g2000hsf.googlegrou ps.com:

Hello,

I am in need of some guidance.

I have a budget database that tracks purchases. I have a query
that totals each persons purchase and I have a field in that query
that uses that SUM to determine the amount remaining in that
person's budget. It works but when I run the query it prompts me
for the name(which I want) and it prompts me for the Sum
amount(which I do not want it to do) and it doesnt matter what I
put in that box it still comes out with the correct amount
remaining. - How can I get it to not prompt for the SUM amount?
I think it does this because the query has not run and it has not
been provided with the amount until after you hit Enter.

I would also like the amount remaining displayed on a form when
that persons budget is selected. I am not sure where to start
with this one.
I appreciate any help you all can provide.
Thanks,
Tobias

For anybody to help you, you'll have to post the SQL of the query.
Open the query, change to SQL view, copy and paste the SQL into a
message.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com