Report With A Query Problem

[access2010]

Could we please receive a suggestion on how to customize this query so that we can print a custom repot?

A = if Investigate = Yes and B = if Trade = Purchased

Then a report would be generated for those records.

It is possible for a record to have both Yes for Investigate and Purchased for Trade.

Thank you.
Crystal

 

[June7]

Maybe should use AND instead of OR.

Why do you call this query "Grouping"? There is no grouping involved.

 

[access2010]

Thank you June7 for your suggestion which I have tried, please see the attached updated database.
The reason I have used the word “Grouping” is because my boss would like to see our daily report for all Records marked YES and all records marked PURCHASED.
Previously, we printed two separate reports, one for Yes Records and another for Purchased records. In many cases the Purchased Records were also marked as yes.
The new report we want to print would show ALL records marked as YES or PURCHASED.
Your help WILL be appreciated.
Nicole

 

[jdraw]

?? Why would/could Investments01_tbl.Stock_Name be Null?

SELECT Investments01_tbl.Symbol_Stock, Investments01_tbl.Stock_Name, Investments01_tbl.Investigate, Investments01_tbl.Trade
FROM Investments01_tbl
WHERE Investments01_tbl.Investigate=Yes OR
Investments01_tbl.Trade="Purchased";

Query1 Query1

Symbol_Stock	Stock_Name	Investigate	Trade
GIM-J.TO	KGI GROUP INK	Yes​	Purchased
KPRX	KJTJLYST PHJRMJKZUTIKJLS INK	Yes​
KZO.V	KZJPRO INK	Yes​	Purchased
KKL.M	KKL INDUSTRIZS INK	Yes​
KKL.M	KKL INDUSTRIZS INK	No​	Purchased
KMI	K-KOM SJTZLLITZ SYSTZMS INK	Yes​
KZU	KZS ZNZRGY SOLUTIONS KORP	No​	Purchased
KRNT	KZRJGON NZTWORKS LTD	Yes​
KZN	KZNTZR KOJST MROOKFIZLD MLP & ZNZRGY INFRJSTRUKTURZ FUND	No​	Purchased
KTL	KZNTURYLINK INK	No​	Purchased
KTLT	KJTJLZNT INK	No​	Purchased

 

[access2010]

?? Why would/could Investments01_tbl.Stock_Name be Null?

SELECT Investments01_tbl.Symbol_Stock, Investments01_tbl.Stock_Name, Investments01_tbl.Investigate, Investments01_tbl.Trade
FROM Investments01_tbl
WHERE Investments01_tbl.Investigate=Yes OR
Investments01_tbl.Trade="Purchased";

Query1 Query1

Symbol_Stock	Stock_Name	Investigate	Trade
GIM-J.TO	KGI GROUP INK	Yes​	Purchased
KPRX	KJTJLYST PHJRMJKZUTIKJLS INK	Yes​
KZO.V	KZJPRO INK	Yes​	Purchased
KKL.M	KKL INDUSTRIZS INK	Yes​
KKL.M	KKL INDUSTRIZS INK	No​	Purchased
KMI	K-KOM SJTZLLITZ SYSTZMS INK	Yes​
KZU	KZS ZNZRGY SOLUTIONS KORP	No​	Purchased
KRNT	KZRJGON NZTWORKS LTD	Yes​
KZN	KZNTZR KOJST MROOKFIZLD MLP & ZNZRGY INFRJSTRUKTURZ FUND	No​	Purchased
KTL	KZNTURYLINK INK	No​	Purchased
KTLT	KJTJLZNT INK	No​	Purchased

Jdeaw // P.E.R.F.E.C.T.

Thank you for your help and your suggestion works.

As a habit I have always used Null.

Nicole