Row Numbers In Join Query

  • Thread starter Thread starter PC User
  • Start date Start date
P

PC User

I've seen a number of posts discussing the coding a query from a
single table to generate row numbers. However, my situation is that I
have a join query with two tables joined by their common ID. I can't
seem to get it to work. Has anyone done this before?

Thanks,
PC
 
For those of you who can use this information, someone has helped me
figure it out.

===================================
Sequence: (SELECT Count(Index.InventoryID) AS TempID
FROM tblChemicalInventory AS Index
WHERE ((Index.InventoryID <= tblChemicalInventory.InventoryID) And
(Index.BusinessID = [Forms]![frmMain]![ctlGenericSubform].[Form]!
[BusinessID])))
===================================

PC
 
Back
Top