Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inputting info from 3 tables into 1 report

Status
Not open for further replies.

jalge2

Technical User
Feb 5, 2003
105
0
0
US
Hey all.

I have 3 tables that have 1 cell of information in them. It's a total put together from a query.

I'm trying to find a way to get them onto a report but I'm having problems. The control source for each text box keeps coming back with errors.

I've tried to use the expression builder in the control source and that is what keeps getting me the error. I'm not sure what else to try.

Any thoughts or suggestions would be greatly appreciated.

Thanks.

Jason Alge
Jason.M.Alge@lowes.com

'There are three kinds of people: Those who can count and those who can't'
 
Are the 3 tables in the report's record source? If not, what are your control source expressions that don't work?
Are the 3 tables related?

Do you realize that tables don't have "cell(s)"?

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top