Recent content by Jaybee214

  1. J

    Help with SQL query with checkboxes

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

    Help with SQL query with checkboxes

    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.
  3. J

    Help with SQL query with checkboxes

    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...
  4. J

    Help with SQL query with checkboxes

    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...
  5. J

    Help with SQL query with checkboxes

    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...
Back
Top Bottom