Simple Query

[Don Sealer]

I'm guessing this is pretty simple however not simple enough for me.
I'm developing a database to track expenses, income, banking
transactions, etc.
I have a very simple query with four fields, date, checking account
deposits, savings account deposits, savings account withdrawals. How do
I get this query to only show dates when a transaction occurred in one
of the other three fields?
Thanks,
Don..............

[Larry Linson]

"Don Sealer" <vz******@verizon.net> wrote in message
news:LpT1f.643$AR1.105@trndny09...

I'm guessing this is pretty simple however not simple enough for me.
I'm developing a database to track expenses, income, banking transactions,
etc.
I have a very simple query with four fields, date, checking account
deposits, savings account deposits, savings account withdrawals. How do I
get this query to only show dates when a transaction occurred in one of
the other three fields?
Thanks,
Don..............

"Other three fields"? You described four, but didn't identify the "one". If
I assume that one is "date", I would also assume that there would be no
record for the query to retrieve if there were no entry in any of the other
three fields, so a simply retrieval query would suffice... unless, as is
very likely, you want to retrieve only for a particular date range.

On the off-chance that you do have records for dates when there are no
transactions, and that you do not want to limit the date range, do the
following:

Add the table to the Query Builder

Drag down all fields into the grid.

Under each of the deposits or withdrawal fields, on a separate criteria line
(to indicate OR rather than the AND that is implied if criteria are listed
on the same line), enter Not Null. If you do want a paramter query for a
date range, under the date field (which should not be named "date" because
that is an Access reserved word), enter Between [Enter From Date] and [Enter
To Date].

If you want this query to be used as a record source for a form or report,
initiated from another form, it will be only slightly more complex... using
VBA code to construct the query or the criteria.

Larry Linson
Microsoft Access MVP

[Don Sealer]

Larry Linson wrote:

"Don Sealer" <vz******@verizon.net> wrote in message
news:LpT1f.643$AR1.105@trndny09...

I'm guessing this is pretty simple however not simple enough for me.
I'm developing a database to track expenses, income, banking transactions,
etc.
I have a very simple query with four fields, date, checking account
deposits, savings account deposits, savings account withdrawals. How do I
get this query to only show dates when a transaction occurred in one of
the other three fields?
Thanks,
Don..............

"Other three fields"? You described four, but didn't identify the "one". If
I assume that one is "date", I would also assume that there would be no
record for the query to retrieve if there were no entry in any of the other
three fields, so a simply retrieval query would suffice... unless, as is
very likely, you want to retrieve only for a particular date range.

On the off-chance that you do have records for dates when there are no
transactions, and that you do not want to limit the date range, do the
following:

Add the table to the Query Builder

Drag down all fields into the grid.

Under each of the deposits or withdrawal fields, on a separate criteria line
(to indicate OR rather than the AND that is implied if criteria are listed
on the same line), enter Not Null. If you do want a paramter query for a
date range, under the date field (which should not be named "date" because
that is an Access reserved word), enter Between [Enter From Date] and [Enter
To Date].

If you want this query to be used as a record source for a form or report,
initiated from another form, it will be only slightly more complex... using
VBA code to construct the query or the criteria.

Larry Linson
Microsoft Access MVP

Thank you Larr,
I wonder how long it will take for me to figure out things like this
(just the simple things).
Thanks again,
Don............

[Don Sealer]

Just testing to see if I can send to the newsgroup.
Don Sealer wrote:

Larry Linson wrote:

"Don Sealer" <vz******@verizon.net> wrote in message
news:LpT1f.643$AR1.105@trndny09...

I'm guessing this is pretty simple however not simple enough for me.
I'm developing a database to track expenses, income, banking
transactions, etc.
I have a very simple query with four fields, date, checking account
deposits, savings account deposits, savings account withdrawals. How
do I get this query to only show dates when a transaction occurred in
one of the other three fields?
Thanks,
Don..............

"Other three fields"? You described four, but didn't identify the
"one". If I assume that one is "date", I would also assume that there
would be no record for the query to retrieve if there were no entry in
any of the other three fields, so a simply retrieval query would
suffice... unless, as is very likely, you want to retrieve only for a
particular date range.

On the off-chance that you do have records for dates when there are no
transactions, and that you do not want to limit the date range, do the
following:

Add the table to the Query Builder

Drag down all fields into the grid.

Under each of the deposits or withdrawal fields, on a separate
criteria line (to indicate OR rather than the AND that is implied if
criteria are listed on the same line), enter Not Null. If you do want
a paramter query for a date range, under the date field (which should
not be named "date" because that is an Access reserved word), enter
Between [Enter From Date] and [Enter To Date].

If you want this query to be used as a record source for a form or
report, initiated from another form, it will be only slightly more
complex... using VBA code to construct the query or the criteria.

Larry Linson
Microsoft Access MVP

Thank you Larr,
I wonder how long it will take for me to figure out things like this
(just the simple things).
Thanks again,
Don............