I have a query with over 20 fields with a two criteria statements for each field. I can view it in table view and I can call it through a search form but when I go to edit it in Design View it locks up access or give me a memory error message. Does anyone have any suggestions.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Design View - Query Memory Error
- Thread starter HMArch
- Start date
Hi,
What version of Access? As a test, you could try breaking your query into two queries -- place half of the selection criteria in one, half in the other. How did you create the query in the first place?
Wayne
35+ years of 'progress' -- can't we all just go wire boards again?
What version of Access? As a test, you could try breaking your query into two queries -- place half of the selection criteria in one, half in the other. How did you create the query in the first place?
Wayne
35+ years of 'progress' -- can't we all just go wire boards again?
- Status
Similar threads
- Locked
- Question
- Locked
- Question
