Hi all,
I'm trying to group records by year. Tried typing in the following in Design View:
Year: DatePart("yyyy",[SurveyDate]) into the Field row in Design view. It yields #Error all the way down.
Then I realized my SurveyDate field was a "Text" field, not Date/Time. Figured that's probably the problem. So tried to convert it to Date/Time and got the following error:
---"Microsoft Access can't change the data type. There isn't enough disk space or memory."
Did a search on this forum and found that this is a common problem with big databases (mine's 534,000 records). So I tried to create a new table with all the same fields -- but with SurveyDate as a Date/Time type, and append all the data from the old table into it.
HOWEVER!
I'm getting the following error:
---"Microsoft Office can't append all the records in the append query.
Microsoft Office Access set 534582 fields to Null due to a type conversion failure"
Any ideas? I wasn't sure how to do the other option suggested in that thread: creating a make table query and using the str() and lng() function to change the data type. [Here's a link to that thread: http://bit.ly/qvzdN7]
Help, o brilliant Access wizards!