Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2017
    Posts
    1

    Unanswered: Dynamic number or user input parameters

    Greetings!

    MS Access 2016:

    I have a need for a query where a user will input a dynamic number of attendance dates. The dates would be the same for all attendees so a parameter would fit my needs. But each time the query is run there could be from one (1) to many dates to be entered. Think multi-day committee meetings (fun stuff!).

    I'm open to prompting the user up front for a total quantity of dates - but I'm unsure how to take than number and dynamically create columns for the dates to be input.

    Hope this make sense, and thanks in advance!

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    1,101
    Provided Answers: 17
    Um. Tricky.

    If the dates are consecutive, you could try prompting for the start date and the number of days to run. Then use a formula in the query:
    Code:
    Between #[Enter start date]# And DateAdd("d", [Enter number of days], #[Enter start date]#)
    NB
    The above is air code, but might point you in the right direction.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •