Rapport og varible dato

Make a query where you have the two dates as columns (paramaters)

Éxample: For the period start youi will enter something like this
in an empty column in the query

PeriodStart:[Period Start Date]
and period end
PeriodEnd: [Period End Date]
then in the criteria field for the date column
Between [Period Start Date] And [Period End Date]

so in report you will have two fields PewriodStart and PeriodEnd

janma>er du der?

Ja,men jeg skulle lige tjekke det og jeg har et problem.
Det lyder jo rigtigt nok, når jeg gør som du foreslår og opretter to kolonner i forespørgslen med registeringsdato og skriver henholdsvis startdato og slutdato, så sker der bot det at access ved kørsel af forespørgsel samler det hele i den ene kolonne som  "[Period Start date] And [Period End Date].

PeriodStart:[Period Start Date] is in a column where you normally would have a field from your table. PeriodEnd: [Period End Date] i also.

Then in the CRITERIA for the date field you have
Between [Period Start Date] And [Period End Date]

If you are having problems then I will take a look for you eksperten@santhell.dk

Hi Terry. Jeg skal bare læse dit svar korrekt. Jeg overså at oprette to to tomme kolonner. Når man går det virker det . Sorry !!

If you are still having problems then first create the two fields as parameters. Right click in th equery and choose paramaters from the menu. Then enter the names of your two paramaters and chose date/time as data type

OK, og tak :o)