N
navin
Hi All,
I have to create a database which will be used to create monthly
vendor scorecard. Users have to input vendor performance values in a
form for the month which will be saved in a table.
Below is the table structure:
Supplier#
SupplierName
Period (Jan, Feb etc)
On time (10%, 20 %...)
Rejection (100, 300...)
Once the data is entered, database will open a report, which will
display the output something like:
Period Jan Feb Mar Apr YTD Results
(Avg of current and previous months)
On time 10% 20%
15%
Rejection 100
300 200
Could anybody please suggest how to write a query to achieve the above
or any other suggestions. I have to get this done quickly but unable
to get the query.
Please help...
Thanks,
Navin
I have to create a database which will be used to create monthly
vendor scorecard. Users have to input vendor performance values in a
form for the month which will be saved in a table.
Below is the table structure:
Supplier#
SupplierName
Period (Jan, Feb etc)
On time (10%, 20 %...)
Rejection (100, 300...)
Once the data is entered, database will open a report, which will
display the output something like:
Period Jan Feb Mar Apr YTD Results
(Avg of current and previous months)
On time 10% 20%
15%
Rejection 100
300 200
Could anybody please suggest how to write a query to achieve the above
or any other suggestions. I have to get this done quickly but unable
to get the query.
Please help...
Thanks,
Navin