I have two tables linked both with [Date] as a field. But on the list box I have duplicate dates. If you click on one date it gives me data from one table and click on the other duplicate date I get data from the opposite table.
How can I combine?
Try to load the date from both tables using Floor() function
Floor(Date) as Date
And format the result as a Date
Date(Floor(Date)) as Date
One table is a ODBC Connect using SQL select and the as function doesn't seem to work?
You will need to do that function in a preceding load. If you Google this
function you will find plenty of explanations.
Hope that helps.
Can you share the script you tried?
Is that now working for you? This post has lots about preceding loads, if you are requiring it:
Reading about preceding loads cracked it thank you
Thanks Jessica, but to be fair Sunny or Rob's answers were correct - my contribution was just a slight tweak on top.
Retrieving data ...