Include parameters in query output 1

[TrekBiker]

In simplified form I have a table with fields Activity and Date.

I'd like to query this between a StartDate and EndDate and produce output that includes a field Period as 'StartDate to EndDate'.

So the output would look like this

Activity, Period
Activity 1, 1/2/15 to 12/2/15
Activity 2, 1/2/15 to 12/2/15
etc

 

[Andrzejek]

How about:

[tt]Select tbl.Activity, '1/2/15 to 12/2/15' As Period
From tbl
Where tbl.SameDateField Between ...
[/tt]

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[dhookom]

First, I would recommend not using parameter queries faq701-6763. Also Date is the name of a function and should be avoided as the name of a field.

If you use controls on a form you can create columns with the expressions from your criteria. You could do the same with your parameter prompts.

SELECT Activity, Forms!frmDates![txStartDate] & " - " & Forms!frmDates![txtEndDate] AS Period
FROM tblActivities
WHERE ActivityDate Between Forms!frmDates![txStartDate] and Forms!frmDates![txtEndDate]

SELECT Activity, [Enter Start Date] & " " & [Enter End Date] As Period
FROM tblActivities
WHERE ActivityDate Between [Enter Start Date] And [Enter End Date];

Duane
Hook'D on Access
MS Access MVP

 

[TrekBiker]

Thanks again Duane, using form controls is exactly what I want to do so the same query can be run when one of twelve periods is selected from an option group.

Your constant help is very much appreciated.

 

[dhookom]

TrekBiker,

Always glad to help a fellow biker. Any tips on solving a rear hub wobble on my older Trek?

Duane
Hook'D on Access
MS Access MVP