asked on

Ms Access Query Help

Previous asked question:
https://www.experts-exchange.com/questions/28265768/MS-Access-Query-Help.html?anchorAnswerId=39569316#a39569316

It works 1/2 way, need to see if i can see where the remaining problem is i have attached a Sample Database

the problem is in Query: qryFuelDataByVehicleByDriver
I made a table called: what qryFuelDataByVehicleByDriver should look like
that table is how qryFuelDataByVehicleByDriver should look like
the Query called qryFuelDataByVehicle works as needed.Previous asked question:
https://www.experts-exchange.com/questions/28265768/MS-Access-Query-Help.html?anchorAnswerId=39569316#a39569316

It works 1/2 way, need to see if i can see where the remaining problem is i have attached a Sample Database

the problem is in Query: qryFuelDataByVehicleByDriver
I made a table called: what qryFuelDataByVehicleByDriver should look like
that table is how qryFuelDataByVehicleByDriver should look like
the Query called qryFuelDataByVehicle works as needed.

Sample-Database.mdb

Blueice13085

ASKER

just seen a type error in sample database in the table called: what qryFuelDataByVehicleByDriver should look like the MPG that shows 80.30 should be 8.30

Kent Dyer

So.. Does this mean this is resolved?

Blueice13085

ASKER

No look at query "qryFuelDataByVehicleByDriver" and compare the data to table "what qryFuelDataByVehicleByDriver should look like" the data in the query "qryFuelDataByVehicleByDriver" needs to be the same as table "what qryFuelDataByVehicleByDriver should look like"

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial