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............ .. 3 2881
"Don Sealer" <vz******@veriz on.net> wrote in message
news:LpT1f.643$ AR1.105@trndny0 9... 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
Larry Linson wrote: "Don Sealer" <vz******@veriz on.net> wrote in message news:LpT1f.643$ AR1.105@trndny0 9...
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............
Just testing to see if I can send to the newsgroup.
Don Sealer wrote: Larry Linson wrote:
"Don Sealer" <vz******@veriz on.net> wrote in message news:LpT1f.643$ AR1.105@trndny0 9...
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............ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: unixman |
last post by:
As usual, it is 2:00am, and I'm pulling my hair out, finally resorting to
posting in the newsgroups for help. :)
Simple problem, in theory.
Given table "map":
CREATE TABLE map (
entry_id int(10) unsigned NOT NULL auto_increment,
piece_id int(10) unsigned NOT NULL default '0',
|
by: Eddie Smit |
last post by:
field- field-
surname town
---- ----
john NY
john Vegas
john Boston
eddie Boston
eddie New Orleans
eddie NY
|
by: Mrs Howl |
last post by:
I have a query that just reads one table and appends to an output
table, one-for-one. No criteria. It's not a Total query (i.e. no
group by). It normally run run in minutes, but gets horribly slowed
down because five of my output fields are text fields and the
expression that gets appended is a user-defined function I wrote which
is very simple (just a few lines long). Here's the code of my
function:
Public Function tformat(num As...
|
by: j.mandala |
last post by:
I created a simple link between two tables in a query. TableA has
Social Security numbers stored as Long Integer Data. (I imported this
table).
The Join is between these two fields
Table Field Data Type
------------------------------------------
TableA ClientNumA Long Integer
TableB CliNumB String
|
by: Don Wash |
last post by:
Hi All!
I've been searching everywhere for a simple sample of producing a bar graph
using CrystalReport by specifying SQL Query, and I've found none of it! I
find so many complex samples with so many features buried in the sample but
all I want to know is a very simple thing, how to create bar charts with
CrystalReport in VS.NET using SQL Query.
Could anyone provide me a sample showing how to produce a simple bar chart
using SQL Query...
| |
by: John Baker |
last post by:
Hi:7
Newby here to ASP, and using the ASP.NET Web Matrix development tool. While that tool
looks great for a Newby, I have run into a snag. I have an HTML Text Box which I have
named HireInput, and a table (Access Table in fact) that has on it a field called HIREID.
I wish to select records where the two match! It sounds simple, but I am having trouble
setting up the text box name so that it is recognized in the query.
Can someone...
|
by: one man army |
last post by:
Hi All-
I am new to PHP. I found FAQTS and the php manual. I am trying this
sequence, but getting 'no zip string found:'... PHP Version 4.4.0
$doc = new DomDocument;
$res = $doc->loadHTMLFile("./aBasicSearchResult.html");
if ( $res == true )
{
$zip = $doc->getElementById('zipRaw_id')->value;
if ( 0 != $zip ) {
|
by: Fendi Baba |
last post by:
I created a person table with various fields such as Suffix,
Salutation, etc, Some of these fields may not be mandatory for example
suffix. In the actual table itself, I only have a field for suffix ID
where 1=Phd, 2= MD. To display all of these to the user, I created a
form with an underlying query. The problem I am encountering is this,
when we have an empty field, for example where ID="", the query returns
nothing. How do i work around...
|
by: Emin |
last post by:
Dear Experts,
I have a fairly simple query in which adding a where clause slows
things down by at least a factor of 100. The following is the slow
version of the query
-------------------------
SELECT * FROM
( Select x.event_date From x FULL OUTER JOIN y
ON x.event_date = y.event_date
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |