If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Double Results in Query
New to Access
I am trying to create a query that returns data from 2 tables. one table can have multiple entries on one day per person and the other table will only have one entry per person. 2 tables are DataEntry - will have multiple entries per day per person CallLog - one entry per person per day SELECT DataEntry.OrderTakenBy, DataEntry.Company, DataEntry.Date, DataEntry. Category, DataEntry.ShortCode, DataEntry.ContactName, DataEntry.PositionTitle, DataEntry.PostDateExt, DataEntry.FirmPreview, DataEntry.AllorProgramCodes, DataEntry.Units, DataEntry.value, DataEntry.MarketingCode, CallLog.TotalCalls, CallLog.AvgTalkTime, CallLog.TotalTalkTime FROM DataEntry INNER JOIN CallLog ON DataEntry.Date = CallLog.Date WHERE (((DataEntry.Date)=[Enter Date])); Any help would be greatly appreciated. Cheers Keiron |
Thread Tools | |
Display Modes | |
|
|