G
Guest
I have a query with 63 fields. When I try to add a field to the query, it
changes all the "Totals" from "Group by" to "Expression" then it prevents me
from entering any information to the fields form the form or from the query
spread sheet. (The form information is pulled from the query. I keep
restoring the database from a backup file while I've been trying to figure
out the problem. At one point, I rebuilt the query with the new information
I needed, then copied from the SQL view and pasted over my original query
SQL. This worked the last time, but I don't want to have to keep rebuilding
the query--it takes a lot of time. Any ideas as to what could be causing
this problem?
changes all the "Totals" from "Group by" to "Expression" then it prevents me
from entering any information to the fields form the form or from the query
spread sheet. (The form information is pulled from the query. I keep
restoring the database from a backup file while I've been trying to figure
out the problem. At one point, I rebuilt the query with the new information
I needed, then copied from the SQL view and pasted over my original query
SQL. This worked the last time, but I don't want to have to keep rebuilding
the query--it takes a lot of time. Any ideas as to what could be causing
this problem?