1

I have a query in Access that has a parameter for Customer ID.

I've set up the parameter like this: Field: CustID Table:cutomer Criterial:[Choose CustID]. However, currently, I'm only able to enter a single value into the parameter.

Is there a way to enter multiple values into the query parameter?

Unfortunately, I can't use forms. I am extracting data based on a value to an excel workbook.

User1974
  • 276
  • 1
  • 17
  • 63
HAIZD
  • 179
  • 1
  • 1
  • 16

1 Answers1

1

Using example from Microsoft's site I'd suggest you use example 1 - seeing as you seem to indicate VBA is not an option

This should give you the helpful prompt to type in all valid CustIDs separated by a comma, or just leave blank so get them all

  Field: InStr([Cust IDs separated by commas, Blank=All],[CustID])
  Criteria:  > 0 Or Is Null
  Show: False

Example: When prompted enter 1,2,3 - to get records with those customer IDs

dbmitch
  • 5,361
  • 4
  • 24
  • 38