By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,107 Members | 1,284 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,107 IT Pros & Developers. It's quick & easy.

save query crashes access

P: n/a
Here's what happens.

I created the query below in a copy of my BE & it works fine.

But in the FE:

If I enter query into SQL view & hit "!" I get correct results (a list of
families w/nonzero balance).

However, every time I try to save it Access crashes (error report &
restart). What's going on? How do I fix it?

As a general question, how seriously should I take an Access crash? I am
inclined to suspect my data has now become silently corrupt. Thanks for any
insight here.

Eric

SELECT * FROM tFam INNER JOIN (SELECT tFam.ID as yid,
sum([tFamilyJournal.charge]-[tFamilyJournal.credit]) as balance FROM tFam
inner JOIN tFamilyJournal ON tFam.ID=tFamilyJournal.fid group by tFam.ID
having sum(tFamilyJournal.charge) - sum(tFamilyJournal.credit) <>0) AS bal
ON tFam.ID=bal.yid;
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Eric,
it is strange that your query even ran - the subquery should have square
brackets around it
and followed by a dot, so try that (see below)

Aliasing your tables names may also help.

HS
------------------------------

SELECT * FROM tFam
INNER JOIN [SELECT F.ID as yid,
sum([J.charge]-[J.credit]) as balance
FROM tFam as F
inner JOIN tFamilyJournal as J
ON F.ID=J.fid
group by F.ID
having sum(J.charge) - sum(J.credit) <>0]. AS bal
ON tFam.ID=bal.yid;
"Eric Nelson" <pl****@just.post> wrote in message
news:3f******@usenet01.boi.hp.com...
Here's what happens.

I created the query below in a copy of my BE & it works fine.

But in the FE:

If I enter query into SQL view & hit "!" I get correct results (a list of
families w/nonzero balance).

However, every time I try to save it Access crashes (error report &
restart). What's going on? How do I fix it?

As a general question, how seriously should I take an Access crash? I am
inclined to suspect my data has now become silently corrupt. Thanks for any insight here.

Eric

SELECT * FROM tFam INNER JOIN (SELECT tFam.ID as yid,
sum([tFamilyJournal.charge]-[tFamilyJournal.credit]) as balance FROM tFam
inner JOIN tFamilyJournal ON tFam.ID=tFamilyJournal.fid group by tFam.ID
having sum(tFamilyJournal.charge) - sum(tFamilyJournal.credit) <>0) AS bal
ON tFam.ID=bal.yid;

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.