Re: [MS_AccessPros] Help with Sub Query

 

Michael-

It's not clear what you're trying to do.  Do you need to split the data into two related tables?  What is the meaning of the 8 fields?

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Nov 21, 2014, at 3:58 AM, Sac City Plumbing saccity101@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___