C
cjay85
Hi,
I am fairly new to Access and am creating a database for a helpline
for a local charity. The database has a simple form for data entry
included fields where the user types in information and where they use
drop down boxes.
I now have a few problems that I have having with the database.
1 :: I want to create a rule that means that if the user tries to skip
a field when entering data an error message is shown. This includes
drop down menus.
2 :: When creating reports the user can enter what type of information
that they want listed. For example if they want to see all the phone
calls they have received from a docter it lists all the records that
this is the case. Is there a way that access can automatically count
the amount of fields that the query has produced?
3 :: Is there a way when creating reports to have the data shown in
percentage form. For example is there a way when seeing all the phone
calls they have received from a docter Access can calculate what
percentage this is compared to the whole amount of records that the
database holds.
Many thanks for all your help.
Chris
I am fairly new to Access and am creating a database for a helpline
for a local charity. The database has a simple form for data entry
included fields where the user types in information and where they use
drop down boxes.
I now have a few problems that I have having with the database.
1 :: I want to create a rule that means that if the user tries to skip
a field when entering data an error message is shown. This includes
drop down menus.
2 :: When creating reports the user can enter what type of information
that they want listed. For example if they want to see all the phone
calls they have received from a docter it lists all the records that
this is the case. Is there a way that access can automatically count
the amount of fields that the query has produced?
3 :: Is there a way when creating reports to have the data shown in
percentage form. For example is there a way when seeing all the phone
calls they have received from a docter Access can calculate what
percentage this is compared to the whole amount of records that the
database holds.
Many thanks for all your help.
Chris