I would like to set up a query in which the where clause ask for a start date in this format dd/mm/yyyy and then asks for an end date in the same format.
Since this particular report is created to be a weekly report is there a way to tell access that no mather what the start date is, the end date should be +7 days and not having to type the full date?
Also, since the information in my table is saved as dd/mm/yyyy I assume it's the reason why I have to type the date like this, but was wondering if it's possible to just type it straight as ddmmyyyy?
EDIT
I figured maybe it would be a good thing to have the current query:
Code:
SELECT QUERYCOLLECT1.Date, QUERYCOLLECT1.[THETYPE], QUERYCOLLECT1.[THENAME], QUERYCOLLECT1.APPLICATIO, QUERYCOLLECT1.REVIEWER_S, QUERYCOLLECT1.COMMENTS, QUERYCOLLECT1.EXAMINER_S, QUERYCOLLECT1.DRAWING, QUERYCOLLECT1.Notes, QUERYCOLLECT1.[DATE OF ACTION], [SCORE RESULTS].[TEXT BODY] FROM [SCORE RESULTS] INNER JOIN QUERYCOLLECT1 ON [SCORE RESULTS].APPLICATIO = QUERYCOLLECT1.APPLICATIO
And specificaly in the QUERYCOLLECT1 Query :
Code:
WHERE (((REVIEW11.[DATE_OF_ACTION]) Between [Start Date dd/mm/yyyy] And [End Date dd/mm/yyyy]));