Group Option Not selected but show up in Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that has 6 options to select. Then I created a query to return the values that were selected, going good. My question is the query returns the values that were selected obviously but some how I want all the options to show up in the query even if they were never selected. I am looking to export the query results and graph this information in Excel, I don't want to keep going back and re-selecting the source data if it keeps changing.
Basically is there a way to return the option value if it hasn't been selected
THANKS! Stacey
 
I'm not quite sure what you mean, Stacey, can you give
some more detail about the "options"--are they text boxes,
check boxes, ? Do you mean that you wish to filter the
recordset based on the explicitly-entered "options"? Some
additional generic detail about what your application is
about might also be helpful.

Kevin Sprinkel
-----Original Message-----
I have a form that has 6 options to select. Then I
Click to expand...
created a query to return the values that were selected,
going good. My question is the query returns the values
that were selected obviously but some how I want all the
options to show up in the query even if they were never
selected. I am looking to export the query results and
graph this information in Excel, I don't want to keep
going back and re-selecting the source data if it keeps
changing.
 
Back
Top