Hi!
I'm a student currently learning how to use access and I have a question about a certain query I'm trying to create that my instructor, unfortunately, does not know how to solve.
I'm creating a query that is linked to a form with toggle buttons relating to fields in a customer table (tblCustomer). The form has toggle buttons on it for each field in tblCustomer (see first image attachment). A button on a form runs a query with all tblCustomer fields but only returns data for the fields that are selected on the form (second and third image attachments show the design view of the query and the query results after pressing the button on the form). As you can see, there are a lot of blank fields which I need to be omitted captions and all in order to create a report.
Do you know how to go about omitting the columns and still allowing the columns to function if I needed?
This is fairly urgent for me as I have an important presentation tomorrow with this database. This aspect is not necessary, but I would really love to really learn and try something new.
Thank you for any and all help!
Jonathan
PS: I realize that I am supposed to post an introduction about myself as I am a new member. Unfortunately I'm running low on time and sleep so I will create this tomorrow. Excited to become a part of this forum.
I'm a student currently learning how to use access and I have a question about a certain query I'm trying to create that my instructor, unfortunately, does not know how to solve.
I'm creating a query that is linked to a form with toggle buttons relating to fields in a customer table (tblCustomer). The form has toggle buttons on it for each field in tblCustomer (see first image attachment). A button on a form runs a query with all tblCustomer fields but only returns data for the fields that are selected on the form (second and third image attachments show the design view of the query and the query results after pressing the button on the form). As you can see, there are a lot of blank fields which I need to be omitted captions and all in order to create a report.
Do you know how to go about omitting the columns and still allowing the columns to function if I needed?
This is fairly urgent for me as I have an important presentation tomorrow with this database. This aspect is not necessary, but I would really love to really learn and try something new.
Thank you for any and all help!
Jonathan
PS: I realize that I am supposed to post an introduction about myself as I am a new member. Unfortunately I'm running low on time and sleep so I will create this tomorrow. Excited to become a part of this forum.