Access Quits on design of queries

  • Thread starter Thread starter Kevin Albrecht
  • Start date Start date
K

Kevin Albrecht

Hey -

My company utilizes Access databases for it's reporting.
I have a cercumstance where Access is 'Quitting', when you
desin specific queries. I have reporduced the queries,
already once. Can a query get corrupt over & over? THere
is really nothing too crazy happening, in the query. I
have a few iif functions, on groupby's in a totals query.
Basically:

CHANNEL_desc: IIf(IsNull([LFC_CHANNEL]),IIf([LoanSource]
="xxx","Special",IIf([LoanSource]="yyy",IIf(Right([qry].
[PRID],1)="R","Retail",IIf(Right([qry].[PRID],1)
="W","Whole",IIf(Right([qry].[PRID],2)
="CD","Crect","zzzz"))),"Unknown")),[LFC_CHANNEL])
 
Corruption can cause more corruption, so you may want to try importing all
objects to a new mdb. That usually helps to clear it up.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top