Information not showing up...

[pwicr]

I have a report that I want to pull specific information from a specific record. I have already created two reports that do this but now I want a third that has different information.

Forms 1 & 2 pull the Serial Numbers and color
Form #3 I want it to pull the Dealer name and then find the address from a different table and put that in the report.

Does that make any sense to anyone? I think my head is about to explode!

 

[pbaldy]

That's kind of vague, but it sounds like you need to base your report on a query that joins tables together so you can get the related information.

 

[pwicr]

I've done that and my query is pulling all the information that I want. I just can't get the report to show the information.

 

[pbaldy]

Is the record source of the report the query?

 

[pwicr]

Now i have PART of the information showing.

I have the dealer name...I can pull up the address information but I'm having trouble with my Trim formula and I'm creating it exactly like all my others.

 

[pwicr]

Got it!!! happy dance!!!!

 

[pbaldy]

Glad you got it sorted out!