YES OR NO TO DATABASE?

[AJ]

What I've got; An excel spread sheet that contains all employee travel
criteria, with the headings: - Travelers; Travel Date(s); Cost Centre;
Division; Airline; Airport 1,2,3;4; Taxes; Standard Fare; Fare Offered; Fare
Accepted.

What I would like to achieve is to run reports that breakdown this data to
monitor company business travel e.g. 'how many times has MR X traveled within
the last month and what was the destination's?'

If I do create this database am I right in thinking that I will need to make
a table each for all of the above headings and set up queries to breakdown
the data? (Yes, I am a novice)

Any help will be greatly appreciated.

 

[KARL DEWEY]

You should have a table for Employee (Traveler) with a primary key -
autonumber - as EmpID, LName, FName, MI, Division, etc.
The second table Travel with multi-field primary key of EmpID and TvlDate.
Other fields would be Cost Centre, Airline, Depart, Destination, Fare, Tax,
Standard Fare, Fare Offered, Traveled.

I do not understand what you mean by "Airport 1,2,3;4" in your post. Is
this the routing of the traveler? IF so, I do not see the need to track this
kind of information.

Use a totals query with traveler information from employee table left joined
on EmpID to Travel table. From the Travel table use Destination and TvlDate
fields. For criteria use in the TvlDate column this --
Between (Date()-Day(Date()))+1 And DateAdd("m",1,Date()-Day(Date()))

This subtracts the day of the month from today (equals last day of last
month) and adds one day (equal first day of this month.
Then it add a monthe to the last day of last month.

 

[AJ]

Thanks for your response, we track the routing of the traveler to get the
best price when going out to tender, so it needs to be included.