As a novice in Access i am currently writing a database to track certain financial information for a non-profit organisation. As part of the funding they have to monitor age ranges and ethnic minority, this is done with 4 yes/no fields controlled on a form with Bi-state check boxes (minor, adult, ethnicminor, ethnicadult).
The database stores many purchase orders for each person as more money is awarded however each person can only be counted once. Data from two tables (Customer, PuchaseOrder) is used to query by a financial quarter, grouping all the similar references, and then a record count applied in a second query counting the number of records returning results.
The problem I am having is that regardless of a value (-1 or 0) the record is counted unless each box is unchecked. I have tried putting ' <>0' in the criteria box of the count but this does not work. Other than writing a query for each individual field is there anything I can do?
Thanks in advance
2 2744
As a novice in Access i am currently writing a database to track certain financial information for a non-profit organisation. As part of the funding they have to monitor age ranges and ethnic minority, this is done with 4 yes/no fields controlled on a form with Bi-state check boxes (minor, adult, ethnicminor, ethnicadult).
The database stores many purchase orders for each person as more money is awarded however each person can only be counted once. Data from two tables (Customer, PuchaseOrder) is used to query by a financial quarter, grouping all the similar references, and then a record count applied in a second query counting the number of records returning results.
The problem I am having is that regardless of a value (-1 or 0) the record is counted unless each box is unchecked. I have tried putting ' <>0' in the criteria box of the count but this does not work. Other than writing a query for each individual field is there anything I can do?
Thanks in advance
Hey dmne05974,
Can you please post your SQL Statement that you've written so far. It simply sounds like we just need to add a few changes to your SQL Statement, and we should be able to get it to work.
But without any details, it's really hard to give you a detailed answer.
Thanks,
Joe P.
Joe,
Solved the problem as i sat down this morning used the textbox controlsource property to action the count on the query, Think it must have been one of those sleep on it problems.
Thanks for the reply though
Sign in to post your reply or Sign up for a free account.
Similar topics
by: William Wisnieski |
last post by:
Hello Everyone,
I have a main form with a datasheet subform that I use to query by form.
After the user selects two criteria on the main form and clicks the
cmdShowResults button on the main...
|
by: neptune |
last post by:
I have a query where each customer has an or . Sometimes
both fields for a customer are populated, but if is null, then
will be populated and vice versa. I have a form,
, where I select a...
|
by: jaYPee |
last post by:
I'm having problem w/ my query on how to filter a record based on the
criteria i give.
here's the tables
students table
id
program
course table
|
by: Rolan |
last post by:
I have tried many iterations of constructing an expanded string link
criteria for a list box selection, but have not been successful. The
List Box uses a Totals Select Query that has a CustID,...
|
by: ChasW |
last post by:
I just read these 2 pages. These are most helpful, but leave me with
a question.
http://www.mvps.org/access/queries/qry0005.htm
http://www.mvps.org/access/forms/frm0007.htm
I have a Multi...
|
by: Sid |
last post by:
I hope someone could help me with this.
I am trying to setup a criteria to decide when to allow/not allow
user
to click on the check box. logically it looks simple but I am not
able
to...
|
by: Robertf987 |
last post by:
Hi,
Yet another thing I need help with I'm affraid. I'll first explain what I want, then I'll try to explain what I have. I'm using Microsoft Access 2000.
What I want is to be able to do a...
|
by: Dr Al |
last post by:
I have a table with four date fields, some of which may not be filled
in based on our data entry needs. I have a criteria set as <date()-180
which is supposed to pull dates older than 180 days ago....
|
by: Brett |
last post by:
Hello,
Is it possible to have just one criteria and have it apply to a group
of queries?
I am trying to create a report with the separate results of 4 queries
based on a prompt for the user...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |