Dynamic Access Form

F

famlea3

I have a combination of 3 tables I am using to track investment
information. One table is the main info table, then I have a "Real
Estate Risk Rate", and an "Other Risk Rate" Table. I am trying to
figure out how to create a dynamic option in the form so when the user
is filling in the data, he can select on either "Real Estate" or
"Other" to activate the appropriate risk rate subform.

I am also trying to figure out how to create a query that will
calculate NPV and IRR. I know I need to get the data into an array,
but I am not sure how to do that. These values would be calculated
from a seperate table that reflects Cashflow over time.

Any ideas?

Thanks!
Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Uninstall and install Publisher 365 0
Dynamic Naming of Form Button 3
Calculation Based on Dynamic Variables (What-if Scenario) 0
Append Crosstab Query to Existing Table 0
Create a chart from a table in word thats dynamic 0
Black Lines appearing over table borders 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Set up and printing a 4-up mail merged postcard 0

Top