[MS_AccessPros] Help with Sub Query

 

Trying to normalize data imported from a excel file produced each day

Primary Query:

SELECT Exceltbl.[Sh1ID], Exceltbl.[CoID], Exceltbl.[CustID], Exceltbl.[SOID], Exceltbl.[SpID], Exceltbl.[OrderDate], Exceltbl.[DueDate], Exceltbl.[EnterBy]
FROM Exceltbl

Sub Query to get distinct records, would top be easier?

SELECT DISTINCT Exceltbl.[SOID]
FROM Exceltbl;

Not sure how to joint the two together.   

Take care,
Michael

__._,_.___

---

Posted by: Sac City Plumbing <saccity101@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___