help (1 Viewer)

murray83 · Apr 24, 2019

Help with query criteria

Firstly Good Morning, well is in the UK at the moment and I need/would like a little assistance.

I have the following as the criteria for my query

Code:

Between [From Date DD/MM/YY] And [To Date DD/MM/YY]

And want to use the input of this, to run another query, which has the same criteria, other wise they have to enter the dates 4 times; two From Date & 2 To Date.

another option i was thinking was putting the dates in a table, then have a text box on my form and have them dlookup and then have them (the boxes) be the criteria for the second query

but have searched ol Google and here but not found anything for between dates

any help would be gratefully appreciated, cheers

June7 · Apr 24, 2019

What do you mean by 'dates in a table' and 'dlookup' - why would that be a solution?

I never use dynamic parameters in query but if you really want to then should reference controls on form instead of having popup input prompt.

Review http://allenbrowne.com/ser-62.html

essaytee · Apr 24, 2019

Quick question, for your first query, how are the dates (from & to) retrieved or entered into your query?

Edit: What June said as well.

murray83 · Apr 24, 2019

data is inputted through a prompt to the user as shown in the attached

Click On Number 1
Then enter From Date in 2
Then enter To Date at 3

and then i would like this to either be put in a text box, put on a table which i can then dlookup, or have this inputted criteria run the second query using the IN Select which have seen and used in the past but not for between dates

Code:

In (SELECT [stuff here] FROM [tbl or query here] )

June7 · Apr 24, 2019

Did you read post 2?

MajP · Apr 24, 2019

That format would not work anyways. SQL uses mm/dd/yyyy format regardless of regional settings and any formatting on the field.

murray83 · Apr 24, 2019

June7 said:
Did you read post 2?

i did but how would i select date range, i'm guessing you would say use a date picker in a text box

Gasman · Apr 24, 2019

MajP said:
That format would not work anyways. SQL uses mm/dd/yyyy format regardless of regional settings and any formatting on the field.

That format appears to work from simple input prompts.? even when not specifying the century.

essaytee · Apr 24, 2019

Create a form, create two text boxes, name them accordingly (txtDateStart and txtDateEnd - or whatever naming convention you prefer).

In your query criteria cell enter references to the form, similar to:

Code:

Between [Forms]![frm_DateQuery]![txtDateStart] And [Forms]![frm_DateQuery]![txtDateEnd]

Sample image:

First of all, get this to work and then we can fine tune for US date style if required.

You will also note that for this query to run, the form must be open, if not, you will be presented with input boxes.

help (1 Viewer)

murray83

Games Collector

June7

AWF VIP

essaytee

Need a good one-liner.

murray83

Games Collector

Attachments

June7

AWF VIP

MajP

You've got your good things, and you've got mine.

murray83

Games Collector

Gasman

Enthusiastic Amateur

essaytee

Need a good one-liner.

Attachments

Similar threads

Users who are viewing this thread