Lou Early
Last Activity: Nov 16 '10, 02:43 PM
Joined: Nov 4 '10
Location:
-
Over character limit when exporting to excel
I have an access database table which I have to export to an excel sheet. One of the columns cells contain a lot of text. Over the display limit for an excel cell. So when I export to excel it doesnt show all of the text in a cell. It displays it in the bar at the top of excel but in the actual cell only a portion of the text is displayed. Is there a work around in excel to get the cell to expand further to show more characters? -
Well that was dumb
Yeah. It was the \ instead of /. I cant believe I overlooked something so stupid. Sorry to waste everyone's time. -
Screen Shot
UPDATE Greene_County_P roperty SET Greene_County_P roperty.ROW_Cos t_Foot = [ROW_Actual_Cost]\[ROW_Length], Greene_County_P roperty.ROW_Cos t_Acre = [ROW_Actual_Cost]\[ROW_Acres]
WHERE ((([Greene_County_P roperty]![ROW_Aquired])="T" And ([Greene_County_P roperty]![ROW_Aquired])="T"));...Leave a comment:
-
There are no Null values and all three fields are formatted as numbers. There are 21 total rows and the query works properly and updates 15 of those rows but returns the error on the remaining 6.Leave a comment:
-
Type Conversion Error
When attempting an update query as follows.
Field: ROW_Cost_Acre
Table: Greene_County_P roperty
Update To: [ROW_Actual_Cost]\[ROW_Acres]
I get a type conversion error. It calculates the correct value for some of them but the other get a type conversion error. This same query works fine in another database for another county with no problem.
The query is calculating the cost per acre from...
No activity results to display
Leave a comment: