Parameter in Table Name

  • Thread starter Thread starter TedChicago
  • Start date Start date
T

TedChicago

I have a list of members froma variety of campuses. I would like to generate
a table by campus. I have a query with the Campus Name as a parameter. How
can I get the Campus Name as part of the name of the Table?
 
Don't do it. You want only one table of members. If a member can only be from
ONE campus, then you could have a campus field in the one table. However if a
member could possibly be from more than one campus, you will need at least
one other table (Campuses) in a one-to-many join with the Members table.

With a Campus field, or a Campus table, you can run a query when you need to
find which members are in which campus.
 
Ted,

That's not what a database does. You should not need a table for each
campus, a query will suffice. The only possible use I could think of for a
table of each would be if you were creating separate databases to be used
only on that specific campus. Other than that, you are breaking database
normalization rules. Have a look at this tutorial:

http://www.accessmvp.com/Strive4Peace/Index.htm

for an understanding of why.
 
no entiendo ingles solo hablo castellano por favor mandelo en castellano
Click to expand...

Este grupo es por preguntas (en Ingles) sobre la programma Microsoft Access.
Si tienes preguntas sobre esa programma puedes usar
microsoft.public.es.access.
 
I can understamd that. Now, how can I get that parameter in the title of a
report (without doing it manually each time the report is generated)?
 
Ted,

Is this what you are looking for?

Make sure the field that has the name in in the Query/Table that is the
RecordSource of the report. Under Sortings and Groupings group on Campus.
In the Group Header on the report, in a text field place...

="Campus " & [NameOfFieldInQuery]

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Back
Top