Problem adding a field to a query

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
No, the table does not get deleted. If fact, i can continue to add info
directly to the table.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Combine Duplicates in Query 0
optional queries fields output 2
Query field size quandry 2
Count text values in a Access Field 0
query field names changing to expr#: 8
Query by Form "blows-up" when query is closed and re-opened 1
Using text in a Form to run a Query 2

Back
Top