How can I keep using the same report design but use different tabl

[Guest]

I have created several report designs for the same letter for mailings and
everytime I create a new table for certain regions or shows I have to create
another report but containing the same information how do I use the currect
report design but use a different table? Any clue?

 

[Jeff Boyce]

?You create a new table for each region/show? Are you keeping the same data
in each table?

If so, you may be better off using a spreadsheet.

If you want Access to do what it can do best, consider using ONE table, and
adding a field or so to help you identify which region/show...

Then, when you want to do labels (or any other reports) for a specific
region/show, first create a query that lets you select the records for
(only) that region/show. Then base your report on that query.

If you need to select a different region/show for each report/label set,
turn the query into a parameterized query, which will prompt you for the
selection criterion. Access HELP can help on this.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Need help with report design"

 

[Guest]

I work with databases for specific calendar year for instance right now I'm
working with calendar year 2003, I import that into access then after
removing what I don't need I then create a query with specific criteria once
done I create a report and use the table of that completed 2003 year. Should
I be using tables for my reports or query? Basically, i'm asking if theres
away to pull the information you need from that report design with a click of
a button?

 

[Jeff Boyce]

Please re-read my response.

If it seems like I'm not "telling you the answer", it may be because doing
it the way you ask is not a good idea...

Even though you import Excel data into a (hopefully temporary) table, you
and Access are not limited to working with the design that comes from Excel.
To get the best use of Access features, append each year's Excel data into a
well-normalized table structure (see earlier suggestion).

Then create a query against that (more permanent) structure (i.e., table or
tables) -- see earlier...

Then create a single report against that query (see earlier...).

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Need help with report design"