I have a query that finds results that meet any 1 of 3 criteria. It is
possible for each record to meet 0, 1, 2, or all 3 of the criteria.
When I run the query, each record will show up once for each of the
criteria it meets. Is there any way to return a record only once, no
matter whether it meets 1, 2, or 3 of the criteria? 4 1549
oh patty wrote: I have a query that finds results that meet any 1 of 3 criteria. It is possible for each record to meet 0, 1, 2, or all 3 of the criteria. When I run the query, each record will show up once for each of the criteria it meets. Is there any way to return a record only once, no matter whether it meets 1, 2, or 3 of the criteria?
Post your query. That is not normal behavior.
EX: If I have a record...
FirstName=John
LastName=Smith
MiddleName=Joe
And a query of...
SELECT * From TableName
WHERE FirstName = "John"
OR LastName = "Smith"
OR MiddleName = "Joe"
....it will return exactly one copy of the record even though it satisfies all
three criteria.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Query is the following 3 Rows of criteria. Each record can have
multiple entries under the "MODEL" field:
Row 1: MODEL="F/A-18 E" and CUM="Between 136 And 160"
or
Row 2: MODEL="F/A-18 F" and CUM="Between 190 And 202"
or
Row 3: MODEL="E/A-18G" and CUM="Between 1 And 4"
Rick Brandt wrote: oh patty wrote: I have a query that finds results that meet any 1 of 3 criteria.
It is possible for each record to meet 0, 1, 2, or all 3 of the
criteria. When I run the query, each record will show up once for each of the criteria it meets. Is there any way to return a record only once,
no matter whether it meets 1, 2, or 3 of the criteria? Post your query. That is not normal behavior.
EX: If I have a record...
FirstName=John LastName=Smith MiddleName=Joe
And a query of...
SELECT * From TableName WHERE FirstName = "John" OR LastName = "Smith" OR MiddleName = "Joe"
...it will return exactly one copy of the record even though it
satisfies all three criteria.
-- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com
oh patty wrote: I have a query that finds results that meet any 1 of 3 criteria. It
is possible for each record to meet 0, 1, 2, or all 3 of the criteria. When I run the query, each record will show up once for each of the criteria it meets. Is there any way to return a record only once, no matter whether it meets 1, 2, or 3 of the criteria?
Strasser
First:
Must change the displayed records so that duplicate lines are
identical.
Could do this by deleting or making invisible fields.
Second:
Must be in the design view of the query: View ==> SQL View ==>
display the SQL View
Look at first line, first word should be SELECT
Enter a space, the word DISTINCT and a space
This is telling Access:
"Compare each displayed line to lines above it"
"Any line that is exactly like the line above it, only display
once.
Result is one DISTINCT line is displayed, no matter how many times the
same line would have appeared if the word "DISTINCT" was not entered in
the SQL View of the query design. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mike Cocker |
last post by:
Hello,
I'm quite weak at PHP, so I was hoping to get some help understanding the
below code. First off, I'm trying to create a "query form" that will allow
me to display the results on my...
|
by: Bob Bedford |
last post by:
I've a query quite important to execute.
I've to fill an array with all result, so the query is called once wich
returns all ID's
Then I call the same query a second time as I shown only 10...
|
by: jaysonsch |
last post by:
Hello!
I am having some problems with a database query that I am trying to do.
I am trying to develop a way to search a database for an entry and
then edit the existing values. Upon submit, the...
|
by: Wescotte |
last post by:
Here is a small sample program I wrote in PHP (running off Apache
1.3.31 w/ PHP 5.0.1) to help illustrates problem I'm having. The data
base is using DB2 V5R3M0. The client is WinXP machine using...
|
by: san |
last post by:
Hi,
I wanted to know if this is possible and if so, how do I
do it. Say, I have a query "SELECT * FROM Table WHERE
Column="some_value". This executes on a very large data
set and I would like...
|
by: Rob |
last post by:
I doubt this is the best way to do it, but what I came up
with was to hide the XML in an HTML Comment then edit the
file deleting the HTML stuff and keep the XML results. If
anyone has a better...
|
by: jjturon |
last post by:
Can anyone help me??
I am trying to pass a Select Query variable to a table using Dlookup
and return the value to same select query but to another field.
Ex.
SalesManID ...
|
by: AJ |
last post by:
Hi all,
I have this monster query (at least i think it is).
SELECT
c.ID, c.Company_Name, p., 1 As QueryNbr
FROM
(Company AS c LEFT JOIN Sale AS s ON c.ID = s.Company_ID)
LEFT JOIN
Package...
|
by: sesling |
last post by:
I have created a query that will pull information from our database for the operators. This query will pull in on average 50,000 records. The operators need to refine the search results. I have...
|
by: siridyal |
last post by:
I have a wholesale website that i'm working on that shows hundreds of items that are updated from time to time. These items are kept in a mysql database with several tables.
I want to let the...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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...
|
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,...
|
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,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |