Oaktree
MrExcel MVP
- Joined
- Jun 20, 2002
- Messages
- 8,120
- Office Version
- 365
I have an MS Query that pulls several attributes, including what is called the transmission date (i.e. the date the entry was processed). When I try to edit the query to change (literally change, not add/delete) transmission date to transaction date (the date the entry actually occurred), one of the other fields is repeated, causing the columns to be off by one (what used to be column CG is now CH, etc.)
I am just going to edit query, double clicking on the field name returned, changing it to "transaction date", and doing the same for a criterion.
Any ideas as to what would be causing this or, better yet, how to fix it?
Thanks! ray:
I am just going to edit query, double clicking on the field name returned, changing it to "transaction date", and doing the same for a criterion.
Any ideas as to what would be causing this or, better yet, how to fix it?
Thanks! ray: