You ROCK!!
Thank You!
Joseppi4ever
Last Activity: Jun 7 '17, 09:45 PM
Joined: Oct 29 '14
Location: Edmonton, Alberta
-
And now I would change the Control Source of the Option Group to CATNo instead of Category?Leave a comment:
-
I know you are trying to point me in the right direction to a realization but I am just not getting what I need to do here.
I know I need to make the category field seem like a numerical value of 1 to 5 so that the right box shows as selected but I am not getting how to take the string currently in the category field and make it that value.
Is it an IIF or CASE statement that has to be written?Leave a comment:
-
Obviously, I am not a DBA nor a developer of any kind. If I were to add the extra field into the tblCategory so that it showed the simple values 1 thru 5 and reworked the query so it showed those values, how would I make the option group show the correct checked box?Leave a comment:
-
I appreciate the help and Yes, you have deduced my wishes correctly.
What you see in the report is my attempt at putting the option group in the report but I don't know how to link it to the "Category" filed in the query (qryISSIH) and have it display the correct category in the option group.Leave a comment:
-
OK. I've attached a small subset of the database I am trying to sort out. The report "INCIDENT REPORT" is based on QUERY "qryISSIH"
When you launch the report, you will be asked to enter an Case Number.
Use 17-0056, 17-0058, or 17-0059.
Ignore the next request for a Report Type (Just hit OK)
The report will populate and then you will see the Option Group on Page 2 of...Leave a comment:
-
I understand the concept but lack the practical experience to make it happen.
How do I make the option group in the report display the data contained in the database?Leave a comment:
-
OK - back to this old problem.
I now have an option group called Category created on my report which lists 5 separate choices (Check-boxes). I need one of the five check-boxes selected based on the field (Category) contained in my tblIncidents.
How do I link the tblIncidents.[Category] field to this option group on my report so that the correct Category is selected when the report is printed.Leave a comment:
-
replace one value with another in query result
I have inherited an MS Access 2003 database which is currently using multiple Yes/No fields to track specific categories of incidents. For example, the table currently has 9 separate category fields called Cat 1, Cat 2, Cat 3, .... Cat 9 that are Yes/No fields.
I want to replace these Yes/No fields with a more descriptive single field in order to more effectively manage the database.
For example, if a record currently... -
Convert database values to check boxes in report
I have a database field called "report_typ e" that has three possible values (Initial / Follow-up / Final) selected via drop down box.
I need to convert that selected value into a checked box on a report.
No activity results to display
Leave a comment: