Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Access Query
Message
De
28/06/2010 03:55:49
Rahul Murarka
Sys-Con Engineering
Kolkata, Inde
 
 
À
Tous
Information générale
Forum:
Microsoft Office
Catégorie:
Access
Titre:
Access Query
Versions des environnements
Microsoft Office:
Office 2007
Divers
Thread ID:
01470768
Message ID:
01470768
Vues:
69
Dear Sir/Madam

I Have Two Table of Transport Rates

1) TableA
Contains Rate from X to Location
Location Prices
A 11
B 22
C 33
D 44
E 55
F 66
G 77

2) TableB

Location Prices
A 88
B 99
H 111
I 222
J 333
K 444

After Query Result I require is

Location PricesA PricesB PriceDiff A-B (If A is Null Take it as 0)
A 11 88
B 22 99
C 33 ---
D 44 ----
E 55 ----
F 66 -----
G 77 ----
H ---- 111
I ----- 222
J ----- 333
K ---- 444
Thanks in Advance

Rahul
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform