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

Very sticky Object Invalid error

P: n/a
RE: "Object Invalid or No Longer Set" errors

I've had an angelic visitation and the revelation is that my problem, in
essence, is due to the fact that I have multiple forms open at the same time
whose recordsources draw data from the same table.

I use a tabbed interface: frmMain has 4 tabs. On each tab there is a form
and at least one subform (datasheet). So we're talking at least 5 subform
datasheets, on different tabs, all open at the same time. Each subform is a
different representation data drawn from (mainly) tblTxJournal (a
transaction journal).

The transaction journal is updated through one of the subforms in the tabbed
form set (where the user can add new transactions). Also, the other
subforms are each built off a different query that is controlled by at least
one combo box on it's parent form. For example, the queries are passed
criteria from the combo boxes: WHERE
((tblTxJournal.TxDate)=Forms!frmMain!frmAc!cbxDate ).

On each tab/parent form, these combo boxes feed each subform's
recordsource/query different criteria such as category, account, date
(quarter, year), etc. The user can be in one tab, change the subform
query/recordsource around, then go to another tab and do the dame thing on a
different subform datasheet, then go to another tab and add/delete/edit
transactions in tblTxJournal (from which all the other subform
recordsource/queries draw from).

The core issue then, I think, is questionable design in terms of UI and
form/recordsource combination (be nice... I'm still a rookie). However, I'm
heavily invested in this tabbed interface and the user likes the ability to
control presentation of his data in the different datasheets. I've tried
using "snapshot" instead of "dynaset" for recordsource type, and also
re-assigning the subform recordsource (Forms!frmMain!frmAc.Recordsource =
"qryTxTotal_Ac") on tab change, but none of this seems to help -- I still
get "Object Invalid or No Longer Set" errors. This error cannot be trapped,
and it usually freezes the interface so Access has to be killed from Task
Manager.

Any suggestions are very welcome!

Below are some of the recordsource/queries in question.
_ _ _ _ _

SELECT tblTxJournal.TxDate, tblTxJournal.Amount, tblTxJournal.Tx_ID,
tblTxJournal.Entity_ID, tblTxJournal.Comment, tblTxAcct.TxAcctName,
tblTxType.TxTypeName, tblTxPayment.Payment, tblTxAcct.TxAcct_ID,
tblTxType.TxType_ID, tblTxPayment.Payment_ID
FROM tblTxType INNER JOIN (tblTxPayment INNER JOIN (tblTxAcct INNER JOIN
tblTxJournal ON tblTxAcct.TxAcct_ID=tblTxJournal.TxAcct_ID) ON
tblTxPayment.Payment_ID=tblTxJournal.Payment_ID) ON
tblTxType.TxType_ID=tblTxJournal.TxType_ID
WHERE ((tblTxJournal.Entity_ID)=Forms!frmMain!frmAc!Eid) ;
_ _ _ _ _

SELECT SUM(Amount) AS YrAll
FROM qryTxHist_Ac
WHERE (Year(TxDate)=Forms!frmMain!frmAc!cbxYear_Ac);
_ _ _ _ _

SELECT qryTxTotal_To_Accts.TxAcct_ID, qryTxTotal_To_Accts.TxAcctName,
qryTxToQ1.Q1Total, qryTxToQ2.Q2Total, qryTxToQ3.Q3Total, qryTxToQ4.Q4Total,
qryTxToYr.YrTotal
FROM ((((qryTxTotal_To_Accts LEFT JOIN qryTxToQ1 ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ1.TxAcct_ID) LEFT JOIN qryTxToQ2 ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ2.TxAcct_ID) LEFT JOIN qryTxToQ3 ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ3.TxAcct_ID) LEFT JOIN qryTxToQ4 ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ4.TxAcct_ID) LEFT JOIN qryTxToYr ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToYr.TxAcct_ID
ORDER BY TxAcctName;
_ _ _ _ _

SELECT qryTxHist_Ac.TxAcct_ID, qryTxTotal_Ac_Total_Q1.Q1,
qryTxTotal_Ac_Total_Q2.Q2, qryTxTotal_Ac_Total_Q3.Q3,
qryTxTotal_Ac_Total_Q4.Q4, qryTxTotal_Ac_Total_Yr.ytd,
qryTxTotal_Ac_Total_YrAll.YrAll
FROM qryTxTotal_Ac_Total_Q1, qryTxTotal_Ac_Total_Q3, qryTxTotal_Ac_Total_Q4,
qryTxTotal_Ac_Total_Yr, qryTxTotal_Ac_Total_YrAll, qryTxTotal_Ac_Total_Q2,
qryTxHist_Ac;
_ _ _ _ _
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
By the way, this is Access 2002 with Jet 4.0 SP 7

"deko" <dj****@hotmail.com> wrote in message
news:1v****************@newssvr27.news.prodigy.com ...
RE: "Object Invalid or No Longer Set" errors

I've had an angelic visitation and the revelation is that my problem, in
essence, is due to the fact that I have multiple forms open at the same time whose recordsources draw data from the same table.

I use a tabbed interface: frmMain has 4 tabs. On each tab there is a form
and at least one subform (datasheet). So we're talking at least 5 subform
datasheets, on different tabs, all open at the same time. Each subform is a different representation data drawn from (mainly) tblTxJournal (a
transaction journal).

The transaction journal is updated through one of the subforms in the tabbed form set (where the user can add new transactions). Also, the other
subforms are each built off a different query that is controlled by at least one combo box on it's parent form. For example, the queries are passed
criteria from the combo boxes: WHERE
((tblTxJournal.TxDate)=Forms!frmMain!frmAc!cbxDate ).

On each tab/parent form, these combo boxes feed each subform's
recordsource/query different criteria such as category, account, date
(quarter, year), etc. The user can be in one tab, change the subform
query/recordsource around, then go to another tab and do the dame thing on a different subform datasheet, then go to another tab and add/delete/edit
transactions in tblTxJournal (from which all the other subform
recordsource/queries draw from).

The core issue then, I think, is questionable design in terms of UI and
form/recordsource combination (be nice... I'm still a rookie). However, I'm heavily invested in this tabbed interface and the user likes the ability to control presentation of his data in the different datasheets. I've tried
using "snapshot" instead of "dynaset" for recordsource type, and also
re-assigning the subform recordsource (Forms!frmMain!frmAc.Recordsource =
"qryTxTotal_Ac") on tab change, but none of this seems to help -- I still
get "Object Invalid or No Longer Set" errors. This error cannot be trapped, and it usually freezes the interface so Access has to be killed from Task
Manager.

Any suggestions are very welcome!

Below are some of the recordsource/queries in question.
_ _ _ _ _

SELECT tblTxJournal.TxDate, tblTxJournal.Amount, tblTxJournal.Tx_ID,
tblTxJournal.Entity_ID, tblTxJournal.Comment, tblTxAcct.TxAcctName,
tblTxType.TxTypeName, tblTxPayment.Payment, tblTxAcct.TxAcct_ID,
tblTxType.TxType_ID, tblTxPayment.Payment_ID
FROM tblTxType INNER JOIN (tblTxPayment INNER JOIN (tblTxAcct INNER JOIN
tblTxJournal ON tblTxAcct.TxAcct_ID=tblTxJournal.TxAcct_ID) ON
tblTxPayment.Payment_ID=tblTxJournal.Payment_ID) ON
tblTxType.TxType_ID=tblTxJournal.TxType_ID
WHERE ((tblTxJournal.Entity_ID)=Forms!frmMain!frmAc!Eid) ;
_ _ _ _ _

SELECT SUM(Amount) AS YrAll
FROM qryTxHist_Ac
WHERE (Year(TxDate)=Forms!frmMain!frmAc!cbxYear_Ac);
_ _ _ _ _

SELECT qryTxTotal_To_Accts.TxAcct_ID, qryTxTotal_To_Accts.TxAcctName,
qryTxToQ1.Q1Total, qryTxToQ2.Q2Total, qryTxToQ3.Q3Total, qryTxToQ4.Q4Total, qryTxToYr.YrTotal
FROM ((((qryTxTotal_To_Accts LEFT JOIN qryTxToQ1 ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ1.TxAcct_ID) LEFT JOIN qryTxToQ2 ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ2.TxAcct_ID) LEFT JOIN qryTxToQ3 ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ3.TxAcct_ID) LEFT JOIN qryTxToQ4 ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ4.TxAcct_ID) LEFT JOIN qryTxToYr ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToYr.TxAcct_ID
ORDER BY TxAcctName;
_ _ _ _ _

SELECT qryTxHist_Ac.TxAcct_ID, qryTxTotal_Ac_Total_Q1.Q1,
qryTxTotal_Ac_Total_Q2.Q2, qryTxTotal_Ac_Total_Q3.Q3,
qryTxTotal_Ac_Total_Q4.Q4, qryTxTotal_Ac_Total_Yr.ytd,
qryTxTotal_Ac_Total_YrAll.YrAll
FROM qryTxTotal_Ac_Total_Q1, qryTxTotal_Ac_Total_Q3, qryTxTotal_Ac_Total_Q4, qryTxTotal_Ac_Total_Yr, qryTxTotal_Ac_Total_YrAll, qryTxTotal_Ac_Total_Q2,
qryTxHist_Ac;
_ _ _ _ _

Nov 12 '05 #2

P: n/a
The first thing I notice is this syntax:
Forms!frmMain!frmAc!cbxYear_Ac

Standard syntax would be this:
Forms!frmMain!frmAc.form!cbxYear_Ac);

HTH
- Turtle
"deko" <dj****@hotmail.com> wrote in message
news:FS****************@newssvr27.news.prodigy.com ...
By the way, this is Access 2002 with Jet 4.0 SP 7

"deko" <dj****@hotmail.com> wrote in message
news:1v****************@newssvr27.news.prodigy.com ...
RE: "Object Invalid or No Longer Set" errors

I've had an angelic visitation and the revelation is that my problem, in
essence, is due to the fact that I have multiple forms open at the same time
whose recordsources draw data from the same table.

I use a tabbed interface: frmMain has 4 tabs. On each tab there is a form and at least one subform (datasheet). So we're talking at least 5 subform datasheets, on different tabs, all open at the same time. Each subform is a
different representation data drawn from (mainly) tblTxJournal (a
transaction journal).

The transaction journal is updated through one of the subforms in the tabbed
form set (where the user can add new transactions). Also, the other
subforms are each built off a different query that is controlled by at

least
one combo box on it's parent form. For example, the queries are passed
criteria from the combo boxes: WHERE
((tblTxJournal.TxDate)=Forms!frmMain!frmAc!cbxDate ).

On each tab/parent form, these combo boxes feed each subform's
recordsource/query different criteria such as category, account, date
(quarter, year), etc. The user can be in one tab, change the subform
query/recordsource around, then go to another tab and do the dame thing

on a
different subform datasheet, then go to another tab and add/delete/edit
transactions in tblTxJournal (from which all the other subform
recordsource/queries draw from).

The core issue then, I think, is questionable design in terms of UI and
form/recordsource combination (be nice... I'm still a rookie). However,

I'm
heavily invested in this tabbed interface and the user likes the ability

to
control presentation of his data in the different datasheets. I've

tried using "snapshot" instead of "dynaset" for recordsource type, and also
re-assigning the subform recordsource (Forms!frmMain!frmAc.Recordsource = "qryTxTotal_Ac") on tab change, but none of this seems to help -- I still get "Object Invalid or No Longer Set" errors. This error cannot be

trapped,
and it usually freezes the interface so Access has to be killed from Task Manager.

Any suggestions are very welcome!

Below are some of the recordsource/queries in question.
_ _ _ _ _

SELECT tblTxJournal.TxDate, tblTxJournal.Amount, tblTxJournal.Tx_ID,
tblTxJournal.Entity_ID, tblTxJournal.Comment, tblTxAcct.TxAcctName,
tblTxType.TxTypeName, tblTxPayment.Payment, tblTxAcct.TxAcct_ID,
tblTxType.TxType_ID, tblTxPayment.Payment_ID
FROM tblTxType INNER JOIN (tblTxPayment INNER JOIN (tblTxAcct INNER JOIN
tblTxJournal ON tblTxAcct.TxAcct_ID=tblTxJournal.TxAcct_ID) ON
tblTxPayment.Payment_ID=tblTxJournal.Payment_ID) ON
tblTxType.TxType_ID=tblTxJournal.TxType_ID
WHERE ((tblTxJournal.Entity_ID)=Forms!frmMain!frmAc!Eid) ;
_ _ _ _ _

SELECT SUM(Amount) AS YrAll
FROM qryTxHist_Ac
WHERE (Year(TxDate)=Forms!frmMain!frmAc!cbxYear_Ac);
_ _ _ _ _

SELECT qryTxTotal_To_Accts.TxAcct_ID, qryTxTotal_To_Accts.TxAcctName,
qryTxToQ1.Q1Total, qryTxToQ2.Q2Total, qryTxToQ3.Q3Total,

qryTxToQ4.Q4Total,
qryTxToYr.YrTotal
FROM ((((qryTxTotal_To_Accts LEFT JOIN qryTxToQ1 ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ1.TxAcct_ID) LEFT JOIN qryTxToQ2 ON qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ2.TxAcct_ID) LEFT JOIN qryTxToQ3 ON qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ3.TxAcct_ID) LEFT JOIN qryTxToQ4 ON qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ4.TxAcct_ID) LEFT JOIN qryTxToYr ON qryTxTotal_To_Accts.TxAcct_ID=qryTxToYr.TxAcct_ID
ORDER BY TxAcctName;
_ _ _ _ _

SELECT qryTxHist_Ac.TxAcct_ID, qryTxTotal_Ac_Total_Q1.Q1,
qryTxTotal_Ac_Total_Q2.Q2, qryTxTotal_Ac_Total_Q3.Q3,
qryTxTotal_Ac_Total_Q4.Q4, qryTxTotal_Ac_Total_Yr.ytd,
qryTxTotal_Ac_Total_YrAll.YrAll
FROM qryTxTotal_Ac_Total_Q1, qryTxTotal_Ac_Total_Q3,

qryTxTotal_Ac_Total_Q4,
qryTxTotal_Ac_Total_Yr, qryTxTotal_Ac_Total_YrAll, qryTxTotal_Ac_Total_Q2, qryTxHist_Ac;
_ _ _ _ _


Nov 12 '05 #3

P: n/a
thanks for the reply, but I think the only solution is to redesign.

The problem is basically that I'm updating a table and trying to use it as a
recordsource at the same time.

"MacDermott" <ma********@nospam.com> wrote in message
news:h5***************@newsread2.news.atl.earthlin k.net...
The first thing I notice is this syntax:
Forms!frmMain!frmAc!cbxYear_Ac

Standard syntax would be this:
Forms!frmMain!frmAc.form!cbxYear_Ac);

HTH
- Turtle
"deko" <dj****@hotmail.com> wrote in message
news:FS****************@newssvr27.news.prodigy.com ...
By the way, this is Access 2002 with Jet 4.0 SP 7

"deko" <dj****@hotmail.com> wrote in message
news:1v****************@newssvr27.news.prodigy.com ...
RE: "Object Invalid or No Longer Set" errors

I've had an angelic visitation and the revelation is that my problem, in essence, is due to the fact that I have multiple forms open at the same
time
whose recordsources draw data from the same table.

I use a tabbed interface: frmMain has 4 tabs. On each tab there is a form and at least one subform (datasheet). So we're talking at least 5 subform datasheets, on different tabs, all open at the same time. Each
subform
is
a
different representation data drawn from (mainly) tblTxJournal (a
transaction journal).

The transaction journal is updated through one of the subforms in the tabbed
form set (where the user can add new transactions). Also, the other
subforms are each built off a different query that is controlled by at

least
one combo box on it's parent form. For example, the queries are
passed criteria from the combo boxes: WHERE
((tblTxJournal.TxDate)=Forms!frmMain!frmAc!cbxDate ).

On each tab/parent form, these combo boxes feed each subform's
recordsource/query different criteria such as category, account, date
(quarter, year), etc. The user can be in one tab, change the subform
query/recordsource around, then go to another tab and do the dame thing on
a
different subform datasheet, then go to another tab and
add/delete/edit transactions in tblTxJournal (from which all the other subform
recordsource/queries draw from).

The core issue then, I think, is questionable design in terms of UI and form/recordsource combination (be nice... I'm still a rookie). However, I'm
heavily invested in this tabbed interface and the user likes the
ability to
control presentation of his data in the different datasheets. I've

tried using "snapshot" instead of "dynaset" for recordsource type, and also
re-assigning the subform recordsource
(Forms!frmMain!frmAc.Recordsource = "qryTxTotal_Ac") on tab change, but none of this seems to help -- I still get "Object Invalid or No Longer Set" errors. This error cannot be

trapped,
and it usually freezes the interface so Access has to be killed from Task Manager.

Any suggestions are very welcome!

Below are some of the recordsource/queries in question.
_ _ _ _ _

SELECT tblTxJournal.TxDate, tblTxJournal.Amount, tblTxJournal.Tx_ID,
tblTxJournal.Entity_ID, tblTxJournal.Comment, tblTxAcct.TxAcctName,
tblTxType.TxTypeName, tblTxPayment.Payment, tblTxAcct.TxAcct_ID,
tblTxType.TxType_ID, tblTxPayment.Payment_ID
FROM tblTxType INNER JOIN (tblTxPayment INNER JOIN (tblTxAcct INNER
JOIN tblTxJournal ON tblTxAcct.TxAcct_ID=tblTxJournal.TxAcct_ID) ON
tblTxPayment.Payment_ID=tblTxJournal.Payment_ID) ON
tblTxType.TxType_ID=tblTxJournal.TxType_ID
WHERE ((tblTxJournal.Entity_ID)=Forms!frmMain!frmAc!Eid) ;
_ _ _ _ _

SELECT SUM(Amount) AS YrAll
FROM qryTxHist_Ac
WHERE (Year(TxDate)=Forms!frmMain!frmAc!cbxYear_Ac);
_ _ _ _ _

SELECT qryTxTotal_To_Accts.TxAcct_ID, qryTxTotal_To_Accts.TxAcctName,
qryTxToQ1.Q1Total, qryTxToQ2.Q2Total, qryTxToQ3.Q3Total,

qryTxToQ4.Q4Total,
qryTxToYr.YrTotal
FROM ((((qryTxTotal_To_Accts LEFT JOIN qryTxToQ1 ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ1.TxAcct_ID) LEFT JOIN qryTxToQ2

ON qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ2.TxAcct_ID) LEFT JOIN qryTxToQ3 ON qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ3.TxAcct_ID) LEFT JOIN qryTxToQ4 ON qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ4.TxAcct_ID) LEFT JOIN qryTxToYr ON qryTxTotal_To_Accts.TxAcct_ID=qryTxToYr.TxAcct_ID
ORDER BY TxAcctName;
_ _ _ _ _

SELECT qryTxHist_Ac.TxAcct_ID, qryTxTotal_Ac_Total_Q1.Q1,
qryTxTotal_Ac_Total_Q2.Q2, qryTxTotal_Ac_Total_Q3.Q3,
qryTxTotal_Ac_Total_Q4.Q4, qryTxTotal_Ac_Total_Yr.ytd,
qryTxTotal_Ac_Total_YrAll.YrAll
FROM qryTxTotal_Ac_Total_Q1, qryTxTotal_Ac_Total_Q3,

qryTxTotal_Ac_Total_Q4,
qryTxTotal_Ac_Total_Yr, qryTxTotal_Ac_Total_YrAll, qryTxTotal_Ac_Total_Q2, qryTxHist_Ac;
_ _ _ _ _



Nov 12 '05 #4

P: n/a
proof of concept achieved -- keep all the various subform datasheets in
place and just make the entry form a popup modal that (on close) requeries
only the subform datasheet in the active form.

There's something about how Access deals with RecordSources of forms that
are not open or active that I don't understand. It seems futile to
"re-assign" the record source after updating the underlying table.... if
anyone has comments about this, please let me know...
"deko" <dj****@hotmail.com> wrote in message
news:1v****************@newssvr27.news.prodigy.com ...
RE: "Object Invalid or No Longer Set" errors

I've had an angelic visitation and the revelation is that my problem, in
essence, is due to the fact that I have multiple forms open at the same time whose recordsources draw data from the same table.

I use a tabbed interface: frmMain has 4 tabs. On each tab there is a form
and at least one subform (datasheet). So we're talking at least 5 subform
datasheets, on different tabs, all open at the same time. Each subform is a different representation data drawn from (mainly) tblTxJournal (a
transaction journal).

The transaction journal is updated through one of the subforms in the tabbed form set (where the user can add new transactions). Also, the other
subforms are each built off a different query that is controlled by at least one combo box on it's parent form. For example, the queries are passed
criteria from the combo boxes: WHERE
((tblTxJournal.TxDate)=Forms!frmMain!frmAc!cbxDate ).

On each tab/parent form, these combo boxes feed each subform's
recordsource/query different criteria such as category, account, date
(quarter, year), etc. The user can be in one tab, change the subform
query/recordsource around, then go to another tab and do the dame thing on a different subform datasheet, then go to another tab and add/delete/edit
transactions in tblTxJournal (from which all the other subform
recordsource/queries draw from).

The core issue then, I think, is questionable design in terms of UI and
form/recordsource combination (be nice... I'm still a rookie). However, I'm heavily invested in this tabbed interface and the user likes the ability to control presentation of his data in the different datasheets. I've tried
using "snapshot" instead of "dynaset" for recordsource type, and also
re-assigning the subform recordsource (Forms!frmMain!frmAc.Recordsource =
"qryTxTotal_Ac") on tab change, but none of this seems to help -- I still
get "Object Invalid or No Longer Set" errors. This error cannot be trapped, and it usually freezes the interface so Access has to be killed from Task
Manager.

Any suggestions are very welcome!

Below are some of the recordsource/queries in question.
_ _ _ _ _

SELECT tblTxJournal.TxDate, tblTxJournal.Amount, tblTxJournal.Tx_ID,
tblTxJournal.Entity_ID, tblTxJournal.Comment, tblTxAcct.TxAcctName,
tblTxType.TxTypeName, tblTxPayment.Payment, tblTxAcct.TxAcct_ID,
tblTxType.TxType_ID, tblTxPayment.Payment_ID
FROM tblTxType INNER JOIN (tblTxPayment INNER JOIN (tblTxAcct INNER JOIN
tblTxJournal ON tblTxAcct.TxAcct_ID=tblTxJournal.TxAcct_ID) ON
tblTxPayment.Payment_ID=tblTxJournal.Payment_ID) ON
tblTxType.TxType_ID=tblTxJournal.TxType_ID
WHERE ((tblTxJournal.Entity_ID)=Forms!frmMain!frmAc!Eid) ;
_ _ _ _ _

SELECT SUM(Amount) AS YrAll
FROM qryTxHist_Ac
WHERE (Year(TxDate)=Forms!frmMain!frmAc!cbxYear_Ac);
_ _ _ _ _

SELECT qryTxTotal_To_Accts.TxAcct_ID, qryTxTotal_To_Accts.TxAcctName,
qryTxToQ1.Q1Total, qryTxToQ2.Q2Total, qryTxToQ3.Q3Total, qryTxToQ4.Q4Total, qryTxToYr.YrTotal
FROM ((((qryTxTotal_To_Accts LEFT JOIN qryTxToQ1 ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ1.TxAcct_ID) LEFT JOIN qryTxToQ2 ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ2.TxAcct_ID) LEFT JOIN qryTxToQ3 ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ3.TxAcct_ID) LEFT JOIN qryTxToQ4 ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToQ4.TxAcct_ID) LEFT JOIN qryTxToYr ON
qryTxTotal_To_Accts.TxAcct_ID=qryTxToYr.TxAcct_ID
ORDER BY TxAcctName;
_ _ _ _ _

SELECT qryTxHist_Ac.TxAcct_ID, qryTxTotal_Ac_Total_Q1.Q1,
qryTxTotal_Ac_Total_Q2.Q2, qryTxTotal_Ac_Total_Q3.Q3,
qryTxTotal_Ac_Total_Q4.Q4, qryTxTotal_Ac_Total_Yr.ytd,
qryTxTotal_Ac_Total_YrAll.YrAll
FROM qryTxTotal_Ac_Total_Q1, qryTxTotal_Ac_Total_Q3, qryTxTotal_Ac_Total_Q4, qryTxTotal_Ac_Total_Yr, qryTxTotal_Ac_Total_YrAll, qryTxTotal_Ac_Total_Q2,
qryTxHist_Ac;
_ _ _ _ _

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.