Newbie question on calculated fields

[Nick Xylas]

Help! I am new to Access (I had done a training course, but the new
job I have just started is the first time I have used it in a work
setting, and my boss knows less than I do, so it is no use asking him).
I work for a small firm of realtors/property managers and the
President of the company wants me to create an Access database of all
his rental properties so that he can keep track of who is behind in
their rent payments.

What I have tried to do is create a table for each property manager
showing all their properties, then create a subdatasheet (using another
table called Rent Payments) for each property showing monthly rental
payments for the property. I want the last fild to automatically
calculate the balance using the formula "=[Previous Balance]+[Rent
Amount]+[Eviction]+[Bounced Check Fee]+[Late Fee]-[Amount Paid]", but
you can't seem to put calculated fields in subdatasheets like that. Is
there any way to get around this? I know this is probably a really
basic question, but as I say, I am new to Access and have been thrown
in at the deep end somewhat! And I don't want to tell the boss that I
can't do it, cos I can't afford to lose my job!

 

[Guest]

no, tables are not for calculations, only for straight data. use a query.
your query can even look exactly like the table if you want but with an
additional field that calculates the data. should be simple enough, but post
it if you need further help (ie, you need to get to that query from the
original table). hope this helps and you keep your job.

-ih

 

[Kevin3NF]

One table for property managers, not one table for each....

Use forms for data-entry and display, not tables and sub-datasheets.

I would hazard a guess that there is a template on Microsoft.com that has
something similar...search for "access templates" and have a look around at
what is available...


--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

 

[Kevin3NF]

http://office.microsoft.com/en-us/templates/CT011359381033.aspx

Access templates....

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

One table for property managers, not one table for each....

Use forms for data-entry and display, not tables and sub-datasheets.

I would hazard a guess that there is a template on Microsoft.com that has
something similar...search for "access templates" and have a look around
at what is available...


--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

Help! I am new to Access (I had done a training course, but the new
job I have just started is the first time I have used it in a work
setting, and my boss knows less than I do, so it is no use asking him).
I work for a small firm of realtors/property managers and the
President of the company wants me to create an Access database of all
his rental properties so that he can keep track of who is behind in
their rent payments.

What I have tried to do is create a table for each property manager
showing all their properties, then create a subdatasheet (using another
table called Rent Payments) for each property showing monthly rental
payments for the property. I want the last fild to automatically
calculate the balance using the formula "=[Previous Balance]+[Rent
Amount]+[Eviction]+[Bounced Check Fee]+[Late Fee]-[Amount Paid]", but
you can't seem to put calculated fields in subdatasheets like that. Is
there any way to get around this? I know this is probably a really
basic question, but as I say, I am new to Access and have been thrown
in at the deep end somewhat! And I don't want to tell the boss that I
can't do it, cos I can't afford to lose my job!