I have a union query (below)that is giving me some odd results and I think it may be that the date on transactions is not being recognized properly (eg sorting by date is unpredicatable, seems to be treating it as text)
SELECT “EncounterSalesExported” AS Operation,MYOBSellAcct AS Acct,Day,EncounterSales as Total,AccountName from EncounterSalesbyAcctNo
UNION Select
“MYOBImportedSales” AS Operation,AccountNumber AS Acct,[Date by Day] As Day,TotalMYOBSale AS Total,AccountName from MYOBSalesbyAcctNo
UNION select
“MYOBReceipts” As Operation,AccountNumber As Acct, Date as Day,TotalReceived as Total, AccountName from MYOBReceiptsbyAcctSummary;
Is there a way I can format the date field (Day in this query) as say short date to ensure that is not the problem
TIA
Steve