hiding check boxes

[EHOWE]

I have a form where a person is enter a users name what system they are
working on, where in that system and case number. Then they have several
check boxes for any errors that they have occured per case number. Then I
have another form where they can enter a workers name and date range. I have
figured out how to bring up one worker at a time and the time constraints.
Each worker should have about 50 cases. I ultimately want to show each case
but only show the errors that occured in that case. I am using a query to
pull my info into the report. I am new and need easy specific instructions.
Thanks for any help.

 

[Duane Hookom]

Please share your table structure. I fear your table(s) are un-normalized but
you have only hinted at this.

 

[EHOWE]

I am unsure what you are looking for. I have several tables that were made
by a co-worker. When I made the report I used the wizard. Please let me
know what you are looking for.

Thanks
EHowe

 

[Duane Hookom]

"table structure" is the significant table and field names as well as the
field types. It wouild help to see some sample records as well as how these
should display in your report.

 

[EHOWE]

..We are actually are pulling from several different tables. They are all
very basic.
The error detail table is very basic with the field name the same as the
error for example user entry error data type has yes/no.
Format Yes/no,
Required No
Indexed No
Lookup-Display Control Check Box

Hope that is what you are looking for.

EHowe

 

[Duane Hookom]

"field name the same as the error" You are storing data values in field
names. If you can't or won't change your table structure, I would create a
union query based on this table and then base a report or subreport on the
union query.

 

[EHOWE]

I am basing the report on a query.

"field name the same as the error" You are storing data values in field
names. If you can't or won't change your table structure, I would create a
union query based on this table and then base a report or subreport on the
union query.

 

[Duane Hookom]

Basing a report on a query is typical. Do you have any comments regarding my
suggestions?

 

[EHOWE]

I can not change the tables because we have several other reports we are
running off of them. I still need help hiding the check boxes.

 

[Duane Hookom]

Do you have any comments regarding "If you can't or won't change your table
structure, I would create a union query based on this table and then base a
report or subreport on the union query."

Do you understand what this would do? Do you know how to create a
normalizing union query? If not, please (again) provide your field names and
how these should appear in your report.

 

[EHOWE]

I think I have a union query already set-up this is what my report looks like
so far--------------------------
Error Detail Report
----------------------
Person Creating Error
------------------------
Date Case # Where in System What system (then list all
poss
error)

 

[Duane Hookom]

I don't think you understand union queries. A union query has at least one
occurance of " UNION " in the SQL view. Look it up in Help if you need some
direction.

It still looks like your report is based on a record source with field names
that are error names. Please review my replies and requests for the types of
information that I would need to provide additional assistance. I don't want
to continue asking for the same stuff.