Passing Parameters from a Form to execute specific queries

  • Thread starter Thread starter Bernice
  • Start date Start date
B

Bernice

I'm using Access 2000.
I have a series of tables named Bus 1-T-1-Mon - Bus27-T-27-
Fri. I would like to have a form were the user will select
a bus number, day of the week, start time and stop time.

I would like to concatenate bus number and day of week to
determine which table to access (Bus 1-T-1-Mon - Bus27-T-
27-Fri) based on pre-defined queries/reports.

This would eliminate about 79 reports that are duplicated
just based on table name.

Any help would be greatly appreciated.

Thanks,
Bernice
 
I could be wrong without knowing more, but it sounds like you have badly
strayed from normalized database design. Creating a table for each
bus/day/time does not seem like the way to do it.

A tble for bus numbers, a separate table for schedules, would work better.

Before you invest much effort in your databse, you may want to step back and
rethink your basic design.

Rick B



I'm using Access 2000.
I have a series of tables named Bus 1-T-1-Mon - Bus27-T-27-
Fri. I would like to have a form were the user will select
a bus number, day of the week, start time and stop time.

I would like to concatenate bus number and day of week to
determine which table to access (Bus 1-T-1-Mon - Bus27-T-
27-Fri) based on pre-defined queries/reports.

This would eliminate about 79 reports that are duplicated
just based on table name.

Any help would be greatly appreciated.

Thanks,
Bernice
 
Rick,

I realize that this table design is no where close to
normalized. I inherited this project over when the
previous developer left the company.

I was attempting to do something without a database
redesign but may not be able to do this.

Thanks,
Bernice
 
Back
Top