Recent content by Jaybee214

Ah I see! sorry for the confusion and thank you so much for your help! It works perfectly :)

Apologies, that last post was starting data- A. Here is the expected results-B attachment. Hoping I can solve with a query of SQL. Only want to see East Region when NRI Brokerage or Brokerage - non NRI are TRUE.

ok, thanks for your patience-first time posting on the forum. Hopefully this is what you mean. I also was able to attach a file this time-I copied the query from access to Excel to show sample data. I just need the query to only show when region is east, nonNri and NRI are both TRUE. AsuCa...

Hi plog-Here are some examples, I hope this helps, I tried to attach a screen shot but I kept getting an error that the file was to big to attach. A: Query shows 3 headings: Region, NRI, and Non NRI Region:data could include 4 options for criteria-West,Central,East, or GI CM NRI: shows a check...

Hi All! I have Access 2007-2010. I'm a beginner to SQL so I think this is probably an easy solve for someone other than me! Any help as soon as possible is greatly appreciated. My table is called ASU CA My field names for the query are Region (data type is Text in the table), Brokerage – non NRI...