Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Effective date of prices
Message
De
06/01/1999 08:32:04
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Effective date of prices
Divers
Thread ID:
00173090
Message ID:
00173090
Vues:
71
I have a problem that I originally thought was simple, but somehow became complicated....

I have two tables, both of which are out of my control, that stores invoices in one and the product cost that is effective from a certain date in another.

The structures are similar to:

Invoices - inv no, inv date, part no, quantity, etc...
Price list - part no, price, effective date

What I need to do, preferably in a query or set of queries, is to find the invoice value of all invoices between a certain period. This means that I must determine the correct value of each product when it was sold.

Any ideas, even the solution, would be gratefully received.


Jason
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform