Time and Billing Template - Budget

[Tammy Wright]

Does anyone know how I can calculate how much of the budget is remaining?
There are no payments or invoices involved in this.

I would like to take the Total Amount that shows in the Client Subform and
subtract it from [ProjectTotalBillingEstimate] which is in the Project Table.
The amount that shows in the Client Subform is generated from an already
established query called "Hour By Project." So I don't know if it's possible
to get a total from a table and a query that are not related.

Any help? Thanks.

 

[Paul Ballou]

What program is the template being used ?

--
Paul Ballou
MVP Office
http://office.microsoft.com/home
http://www.freeserifsoftware.com/
http://www.ballousgiftshop.com

 

[Tammy Wright]

Access

What program is the template being used ?

--
Paul Ballou
MVP Office
http://office.microsoft.com/home
http://www.freeserifsoftware.com/
http://www.ballousgiftshop.com

Does anyone know how I can calculate how much of the budget is remaining?
There are no payments or invoices involved in this.

I would like to take the Total Amount that shows in the Client Subform and
subtract it from [ProjectTotalBillingEstimate] which is in the Project
Table.
The amount that shows in the Client Subform is generated from an already
established query called "Hour By Project." So I don't know if it's
possible
to get a total from a table and a query that are not related.

Any help? Thanks.

 

[Paul Ballou]

I think it might be possible to get the best response. You might post in an
Access Newsgroup
news://msnews.microsoft.com/microsoft.public.access
<--Outlookexpress

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx <-- Web
Interface

--
Paul Ballou
MVP Office
http://office.microsoft.com/home
http://www.freeserifsoftware.com/
http://www.ballousgiftshop.com

Access

What program is the template being used ?

--
Paul Ballou
MVP Office
http://office.microsoft.com/home
http://www.freeserifsoftware.com/
http://www.ballousgiftshop.com

Does anyone know how I can calculate how much of the budget is
remaining?
There are no payments or invoices involved in this.

I would like to take the Total Amount that shows in the Client Subform
and
subtract it from [ProjectTotalBillingEstimate] which is in the Project
Table.
The amount that shows in the Client Subform is generated from an
already
established query called "Hour By Project." So I don't know if it's
possible
to get a total from a table and a query that are not related.

Any help? Thanks.

 

[Tammy Wright]

This question refers to the Access Template called Time and Billing. Maybe
someone who is familiar with this template can help as this question is
specific to the design of this particular template.

I think it might be possible to get the best response. You might post in an
Access Newsgroup
news://msnews.microsoft.com/microsoft.public.access
<--Outlookexpress

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx <-- Web
Interface

--
Paul Ballou
MVP Office
http://office.microsoft.com/home
http://www.freeserifsoftware.com/
http://www.ballousgiftshop.com

Access

What program is the template being used ?

--
Paul Ballou
MVP Office
http://office.microsoft.com/home
http://www.freeserifsoftware.com/
http://www.ballousgiftshop.com

Does anyone know how I can calculate how much of the budget is
remaining?
There are no payments or invoices involved in this.

I would like to take the Total Amount that shows in the Client Subform
and
subtract it from [ProjectTotalBillingEstimate] which is in the Project
Table.
The amount that shows in the Client Subform is generated from an
already
established query called "Hour By Project." So I don't know if it's
possible
to get a total from a table and a query that are not related.

Any help? Thanks.