|
||||||
Access MVP (2010-2015) |
You import a spreadsheet and you noticed in some of your fields you have a little box with a question mark in it (see image below). This is a Carriage Return (Alt+Enter in Excel).
To remove create an UPDATE query and run against the offending field… UPDATE YourTable SET FieldContainingCarriageReturn = […] 5,763 total views Simple UPDATE query… UPDATE YourTable SET YourTable.YourField1 = "Your Value"; Update a field in your table with values from another field in your table… UPDATE YourTable SET YourTable.YourField1 = [YourField2]; Update a field based on a field on your form… Note: The form must be open to perform this action! TEXT UPDATE YourTable SET YourTable.YourField1 […] 519 total views, 1 views today |
Have an Access... ential you want to share? Drop me a line!
Note, all tips are moderated before posting. |
||||
|
Copyright © 2024 Access… entials - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
