468,507 Members | 1,626 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,507 developers. It's quick & easy.

Simple Query

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..............
Nov 13 '05 #1
3 2425

"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
Nov 13 '05 #2
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............
Nov 13 '05 #3


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............

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by unixman | last post: by
6 posts views Thread by Eddie Smit | last post: by
2 posts views Thread by Don Wash | last post: by
3 posts views Thread by John Baker | last post: by
27 posts views Thread by one man army | last post: by
2 posts views Thread by Fendi Baba | last post: by
reply views Thread by NPC403 | last post: by
3 posts views Thread by gieforce | last post: by
1 post views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.