In Access, if I re-arrange columns in a table, will my queries get messed up? Or are the query relationships linked only to the column header and it doesn't matter where in the table the column lies? Thank you!
Three answers:
zombie
2010-08-19 20:37:55 UTC
depends how did you write the query, if you have mentioned the column name in the queries then it won't mess it up but if you just wrote by the order then it will.
Michael J
2010-08-19 20:36:33 UTC
Yeah queries are always looking at column names, I don't think it will be any problem to rearrange them.
IXL@XL
2010-08-19 20:35:59 UTC
Short answer is No. Queries will not be affected by changing table layout.
ⓘ
This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.