A
Access Joe
Hi all,
I'm really in a rutt and am hoping someone can help out. Similar to what
you see with an online mortgage calculator, I need to come up with a way to
create an automatically updating summary field based on cetain answers to
questions.
I have a database that tracks success rates for a certain pharma drug. The
more patients that are cured, the higher the success rate %. My database
also tracks a whole variety of different items, and I want the user to be
able to enter in a desired parameter and immediately see the results. For
instance, they are going to want to see success rate %'s based on specific
factors: (i.e. "Show me the Success rate% for the Left Side"; "Show me the
Success rate % for all Caucasions"; "Show me the Success rate % for all
Females"; "Show me the Success rate % for all Caucasions who are femlaes";
etc.).
I know that reports can display summaries, and , if based off a query, can
prompt a user with questions. BUT, a - there are way too many possible
factors (and hence, would prompt way too many unnecessary parameters), and b
- the users will be using a switchboard to move around the DB and will never
actually see and/or modify the design view of a query.
Does anyone know how I can create a 'criteria' form that will also display a
consistently updating total based on their choices, similar to what a regular
online calculator would do? I am fairly good with Access, but don't know too
much about coding, macros, etc. Any detailed help would sincerely be
appreciated.
Thank you,
Joe
I'm really in a rutt and am hoping someone can help out. Similar to what
you see with an online mortgage calculator, I need to come up with a way to
create an automatically updating summary field based on cetain answers to
questions.
I have a database that tracks success rates for a certain pharma drug. The
more patients that are cured, the higher the success rate %. My database
also tracks a whole variety of different items, and I want the user to be
able to enter in a desired parameter and immediately see the results. For
instance, they are going to want to see success rate %'s based on specific
factors: (i.e. "Show me the Success rate% for the Left Side"; "Show me the
Success rate % for all Caucasions"; "Show me the Success rate % for all
Females"; "Show me the Success rate % for all Caucasions who are femlaes";
etc.).
I know that reports can display summaries, and , if based off a query, can
prompt a user with questions. BUT, a - there are way too many possible
factors (and hence, would prompt way too many unnecessary parameters), and b
- the users will be using a switchboard to move around the DB and will never
actually see and/or modify the design view of a query.
Does anyone know how I can create a 'criteria' form that will also display a
consistently updating total based on their choices, similar to what a regular
online calculator would do? I am fairly good with Access, but don't know too
much about coding, macros, etc. Any detailed help would sincerely be
appreciated.
Thank you,
Joe