In Progress

MS ACCESS REPORT

Hello experts,

we are looking for an expert in MS Access + SQL to write me a query to generate the following Report in MS Access attached DB:

The DB had three tables:

1- One has the arrival notice details

2- Other has the Ports Details and fees

3- for the Balance Values

the required report to be generated is as follow:

each port has its own 3 different fees and its currency...

based on the arraival notices in the arrival_reports table, each record has the port name, so we need the report to list the following details as follow:

Arrival_Date_EOSP Arrival_ShipName Arrival_PortName FinalValue PortCurrency

and all grouped by the currency with a total sum of the fund for each group..

the trick here is that (FinalValue) is a generated fields "not an actual existing fields in any of the tables" and it should be generated as the below:

most of the ports has one value>0, either on PortFunding1,PortFunding2 or PortFunding3 , while the other two values are 0

so in each record in each group in the above required report we should show (FinalValue) which is the the PortFunding value which is >0 and ignore the other two fields with value=0

if the arrival table has a port name which has more than ONE UNIQUE funding value in the Ports table, then we DO NOT SHOW IT IN THE REPORT, BUT WE SHOW IT IN ANOTHER LIST REPORT WE WILL USE TO LOOK ATER THIS PORT and to knwo which unique value we should consider....

so the over all idea is to get the total SUM for the funds need to be paid in each different currency based on the port fees {only the ports with UNIQUE ONE VALUE AND THE OTHER TWO VALUES are 0}

and we should be able to set the Start and End Date for this report to be compared with the Arrival_Date_EOSP in the Arrival Table.

And the other report to list the arrival records with ports have more than one unique value for the same selected start and end dates so we can refine these records...

then, for the first report and after getting the sum for the records in the 4 different currencies, you need to get the 4 opening balances values from table (OpeningBalance) where ACTIVE field=1 and subtract each currency sum from its opening balance value, for example total sum of USD group to be subtracted from OpeningBalance_USD and so on for the other 3 currencies...

** Please note that we need this report ASAP TODAY, so only experts and confident freelancers who understood the requirements fully are welcomed and considered ..

Good luck

Skills: Microsoft Access, SQL

See more: access sql report, write get paid today, sql get date, microsoft access experts, funding freelancers, expert microsoft access, currency table list, access group, sql microsoft access, microsoft access sql, report example, access experts, freelancers group, sql freelancers, report sql, ms access, group freelancers, access sql, access freelancers, access query table, generate report sql query, sql report write, access sql expert, report table, microsoft sql expert

About the Employer:
( 16 reviews ) Doha, Qatar

Project ID: #2524082

Awarded to:

mrbrave

Hi....There no DB attached....please send me DB to review.

$40 USD in 1 day
(9 Reviews)
4.0

3 freelancers are bidding on average $40 for this job

NourElDeen

Dear Sir, I'm Expert On Access and SQL. Best Regards, NourElDeen

$50 USD in 3 days
(53 Reviews)
5.3
mrexcel2012

Hi Iam a access developer since Access 97 and developed applications on client/server architecture purely using ms access database. You SQL Problem is solved. If you send the database, will create a query in that an More

$30 USD in 1 day
(0 Reviews)
0.0