Thank Rick, I haven't done anyting with the "Dynaset" parameter.
There are two tables attached to this query. THe Medication Stores Table,
and the Restock Meds Update table. The first of the two supplies the NDC
number as well as the Med (record) number. The second table holds the new
data from the form such as quantity to add, total cost (to get LIFO unit
price).
The update query does the calculation of the new unit price, and posts the
other two items plus a date. This update query is not part of the problem at
all.
Here's a look at the SQL code for the Query with the problem...
SELECT [MEDICATION STORES TABLE].[Med Number], [MEDICATION STORES
TABLE].[NDC Number], [MEDICATION STORES TABLE].[Name Strength form], [Restock
Meds Update Table].[Plus Quantity], [Restock Meds Update Table].[Total
Price], [Restock Meds Update Table].Date
FROM [MEDICATION STORES TABLE] LEFT JOIN [Restock Meds Update Table] ON
[MEDICATION STORES TABLE].[Med Number] = [Restock Meds Update Table].[Med
Number]
ORDER BY [MEDICATION STORES TABLE].[NDC Number]
WITH OWNERACCESS OPTION;
It looks straightforward to me, but I'm not an SQL expert. I can read it,
but I can't speak it as the saying goes.
I really do appreciate the time you have taken with this.