Recent content by AnsonniChu

  1. A

    Would like to run a query that is using a field in a table for it's criteria

    Sorry I'll try to explain i have a table like below: ID PromoDept Periods 1 1267 OR 1415 Between #06/23/2019# and #06/29/2019# 2 1536 OR 6538 OR 1415 Between #06/23/2019# and #06/25/2019# 3 2353 OR 2356 Between #06/26/2019# and #06/27/2019# 4 2366 OR 2356 Between #06/26/2019# and #06/27/2019#...
  2. A

    Would like to run a query that is using a field in a table for it's criteria

    I am new and have very basic knowledge of programming. So, I have a table that contains fields that is written in the same way as you would write in a criteria for a field in a query (ex: the field would contain: "1234 Or 1242" or some date range: "Between #06/23/2019# and #06/25/2019#")...
See more
Back
Top Bottom