Closed

Edit MS Access DB

This project received 19 bids from talented freelancers with an average bid price of $85 USD.

Get free quotes for a project like this
Employer working
Project Budget
$10 - $30 USD
Total Bids
19
Project Description

Hi,

I have the Northwind MS Access database web form template. its sync with a sharepoint 2010 server through Access Service

database has 2 table "purchase" and "orders", i need to make a FIFO rule "First In Fist Out" in the report

example:

on 18/10/2016 we purchase a 10 k.g of meat and record saved in Purchase table

on 19/10/2016 we purchase a 20 k.g of meat and record saved in Purchase table

on 20/10/2016 Branch A ordered 8 k.g of meat and record saved in Order Tables

now i need to print a report the show me current level of meat in my warehouse but it must show me that

2 kg from the first purchase available

20 kg from the secound purchase available

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online