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!

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

Auto Generate Report

Status
Not open for further replies.
Pamy

Pamy

MIS
Oct 15, 2002
29
SG
Hi,
I have a few tables and i would like to create 1 report for all. The problem is some of the tables have different field as a result, the report generate error "Missing fields". How can i overcome this?

 
Sort by date Sort by votes
Hi

One idea, make a series of queries basd on you tables, in the queries, make a common set of column names, base you report on the queries Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
604
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
588
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
747
dhookom
dhookom
monkeysee
  • Locked
  • Question
Muti Page Report 1
Replies
5
Views
552
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
595
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top