access summery reports

[Joost]

Hi,

I have a msaccess database with more then 50 tables. Each table exist of the
history off a specific truck data.
(deparute date, arrival date, destination etc.). My boss ask me to give a
summery report off all the latest truck details.

How can this be done

Thanks anyway

[Br]

Joost <no****@home.nl> wrote:

Hi,

I have a msaccess database with more then 50 tables. Each table exist
of the history off a specific truck data.
(deparute date, arrival date, destination etc.). My boss ask me to
give a summery report off all the latest truck details.

How can this be done

Thanks anyway

Dude, please don't post the same thing (or remarkably similar) more than
once. Thanks.
(see other thread for an answer)
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

[Bruce Rusk]

To ensure summery reports, make sure the data is from the months of June
through August. This can be done with a simple date filter.
"Joost" <no****@home.nl> wrote in message
news:db**********@news6.zwoll1.ov.home.nl...

Hi,

I have a msaccess database with more then 50 tables. Each table exist of
the history off a specific truck data.
(deparute date, arrival date, destination etc.). My boss ask me to give a
summery report off all the latest truck details.

How can this be done

Thanks anyway

[Tim Marshall]

Joost wrote:

Hi,

I have a msaccess database with more then 50 tables. Each table exist of the
history off a specific truck data.
(deparute date, arrival date, destination etc.). My boss ask me to give a
summery report off all the latest truck details.

You've got some answers, but someone there needs his or her butt kicked
HARD for having separate tables for each truck.

You should add a new column to each of these tables and put the tag
number or other identifier you use for each truck in it. Then use
append queries to combine all 50 tables into ONE table.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me