I have a query that worked in Access. I used this to fill a dataset. I have two tables. I don't want all fields. I also have a custom column using AS to build its value (FileAttributes.DOCNUMSORT & ':' & DOCTABLE.PAGENUMSORT & ':' & DOCTABLE.ID AS TT). Thank you in advance for you help!
SELECT CAPTION, DOCTABLE.Msg1, DOCTABLE.Msg2, DOCTABLE.Msg3, DOCTABLE.Export, DOCTABLE.DOCNUMSORT, DOCTABLE.PAGENUMSORT, DOCTABLE.FILENAME, DOCTABLE.FILEPATH, DOCTABLE.id, DOCTABLE.Parent, DOCTABLE.Attrange, DOCTABLE.PageCount, DOCTABLE.DOCID, FileAttributes.DOCID, FileAttributes.DOCNUMSORT, FileAttributes.FILENAME, FileAttributes.TOIMAGE_STATUS, FileAttributes.IsDupe, FileAttributes.ERROR_MESS, FileAttributes.MEDIA, FileAttributes.Parent, FileAttributes.Attach, FileAttributes.Attrange, FileAttributes.ATTACHRANGE, FileAttributes.Attchids, FileAttributes.SourceType, FileAttributes.id, FileAttributes.PRINTSTATE, FileAttributes.TOIMAGE, FileAttributes.PageCount, FileAttributes.PSTFileName, FileAttributes.PSTName, FileAttributes.PSTID, FileAttributes.To, FileAttributes.cc, FileAttributes.bcc, FileAttributes.SenderName, FileAttributes.SenderAddress, FileAttributes.Subject, FileAttributes.Header, FileAttributes.Body, FileAttributes.BodyFormat, FileAttributes.CreationTime, FileAttributes.CreationTimeGMT, FileAttributes.EntryID, FileAttributes.InternalMessageID, FileAttributes.HTMLBody, FileAttributes.Importance, FileAttributes.LastModificationTime, FileAttributes.MessageClass, FileAttributes.ReceivedTime, FileAttributes.ReceivedTimeGMT, FileAttributes.Recipients, FileAttributes.ReplyRecipients, FileAttributes.RTFBody, FileAttributes.NUMATTCH, FileAttributes.PRIORITY, FileAttributes.Sent, FileAttributes.SentOn, FileAttributes.SentOnGMT, FileAttributes.Unread, FileAttributes.SourceName, FileAttributes.Source, FileAttributes.SourceFolder, FileAttributes.lSourceType, FileAttributes.ParentID, FileAttributes.FileCreationTime, FileAttributes.FileCreationTimeUTC, FileAttributes.FileDirectoryName, FileAttributes.FileExtension, FileAttributes.FileFullName, FileAttributes.FileIsReadOnly, FileAttributes.FileLastAccessTime, FileAttributes.FileLastWriteTime, FileAttributes.FileSize, FileAttributes.Title, FileAttributes.Author, FileAttributes.Company, FileAttributes.Comments, FileAttributes.Category, FileAttributes.Keywords, FileAttributes.Manager, FileAttributes.LastAuthor, FileAttributes.DateLastPrinted, FileAttributes.DateLastSaved, FileAttributes.Revision, FileAttributes.IsShared, FileAttributes.CustomFields, FileAttributes.DestMD5Hash, FileAttributes.SourceFileName, FileAttributes.SourceFilePath, FileAttributes.Status, FileAttributes.HERITAGE, FileAttributes.TextBody, FileAttributes.Created_By, FileAttributes.Recipient, FileAttributes.DocDate, FileAttributes.DocTitle, FileAttributes.DocType, FileAttributes.Description, FileAttributes.Attorney_Notes, FileAttributes.HotDoc, FileAttributes.Doc_Rating, FileAttributes.UserDate1, FileAttributes.UserText1, FileAttributes.UserText2, FileAttributes.UserText3, FileAttributes.UserMemo, FileAttributes.DOCNUMSORT & ':' & DOCTABLE.PAGENUMSORT & ':' & DOCTABLE.ID AS TT **I seperated the FROM to show the break easily **
FROM FileAttributes LEFT OUTER JOIN DOCTABLE ON FileAttributes.DOCNUMSORT = DOCTABLE.DOCNUMSORT WHERE (DOCTABLE.PAGENUMSORT = 1 OR DOCTABLE.PAGENUMSORT IS NULL) ORDER BY FileAttributes.DOCNUMSORT ASC