adding two query in one but getting duplicate records.
SELECT [qryReserveFolio Query].Product, [qryReserveFolio Query].Qty, qrySalesFolio.Qty
FROM [qryReserveFolio Query], qrySalesFolio;
can anyone help, as its showing duplicate values/ rows
SELECT [qryReserveFolio Query].Product, [qryReserveFolio Query].Qty, qrySalesFolio.Qty
FROM [qryReserveFolio Query], qrySalesFolio;
can anyone help, as its showing duplicate values/ rows