SQL OrderBy Question

  • Thread starter Thread starter TeeSee
  • Start date Start date
T

TeeSee

I have one master items table tblItems.PK is pkItemID (Autonumber).
And two other tables which are identical in structure and both are
linking tables in a M:M relationship. Both have fkItemID
(longInteger). One is tblIssues and the other tblReceipts. I would
like to create a report to detail all transactions for an item sorted
(ORDER BY) date. So since we would have tblIssues.TheDate and
tblReceipts.TheDate ..... How can I sort that?

Thank You
 
On Mon, 21 Dec 2009 12:38:12 -0800 (PST), TeeSee

I'm guessing you are concerned that Access (better: Jet) won't know
the difference between these two date field? It will.

-Tom.
Microsoft Access MVP
 
On Mon, 21 Dec 2009 12:38:12 -0800 (PST), TeeSee


I'm guessing you are concerned that Access (better: Jet) won't know
the difference between these two date field? It will.

-Tom.
Microsoft Access MVP





- Show quoted text -
Click to expand...

You guessed correctly Tom and thanks for the response.
 
Back
Top