Adding more than one item from the same field....

[TomJamieson]

I have a query that draws a product ID, some information about the product, and then a number of faults. The faults all come under one field name though: "Fault". (Funny that). Is there a way to include each fault in my report? When I choose "Fault" from the field list box, it just shows me the first fault in the query.

Any ideas? Or is this something I have to change in the query?

Thanks,
Tom

 

[Banana]

Does your query work correctly when you run it outside of reports? Also, I want to check if by many faults, you mean if you have several different faults in single record? If so, that is a normalisation problem that needs to be fixed first.

Otherwise, you're in same fix as I'm- reports cannot handle recordsets, which is why you can't select queries from controlsource as you could in forms.

A potential solution would be to create a custom field and concetnating all elements into it. However, I'm not sure how to code it myself. I've asked this sort of question over at this thread.

 

[TomJamieson]

It works fine outside of reports, but creates several records, each with exactly the same information in every field except the "Fault" field.

 

[Banana]

Then yes, you're indeed in same boat as I am.

I'm hoping to figure out how to loop through the recordset and add a entry to the textbox, unless someone else has better idea.

 

[Rich]

Use a subReport to display the Many items

 

[TomJamieson]

How do you create a subreport?

 

[Banana]

In design view, in the toolbox with all the controls (labels, textbox, checkbox), click on icon that looks like a recessed box; that's subreport. If you have wizard enabled, it'll help you through it.