Seearch criteria in a question to be presented in a report
in [General]
|
Prev: feier
Next: Spell checking in Access
From: joelgeraldine on 17 Mar 2010 09:49 jkjkjkj "Leif Thorsen" <LeifThorsen(a)discussions.microsoft.com> a écrit dans le message de groupe de discussion : E8294912-E04F-4D15-9F93-A17992A7473B(a)microsoft.com... > > -- > Thanks in advance for Your help > > > "John W. Vinson" wrote: > >> On Thu, 4 Mar 2010 08:03:02 -0800, Leif Thorsen >> <LeifThorsen(a)discussions.microsoft.com> wrote: >> >> >I have a query based om a table with a bunch of posts sorted by the >> >field >> >"Date". The query is based on the criteria "Between Date1 and Date2" in >> >the >> >field "Date". I want to show Date1 and Date2 in the header in a report >> >based >> >on the question above even if there are no posts with just these dates >> >in the >> >field "Dare". >> >How to do ?? >> >> One thing I'd suggest is changing the name of the field Date. It's a >> reserved >> word (for the builtin Date() function) and can and will cause trouble. >> >> If you are using a parameter query with criteria like >> >> Between [Date1] AND [Date2] >> >> then you can use a textbox on the report with a control source >> >> =[Date1] >> >> You'll be better off using a form to provide the criteria: say the form >> is >> named frmCrit, with textboxes txtStartdate and txtEnddate. You can then >> use >> >> >= [Forms]![frmCrit]![txtStartDate] AND < DateAdd("d", 1, >> >[Forms]![frmCrit]![txtEndDate]) >> >> to catch date/time values with a time component on the last day; you can >> then >> use a textbox with a control source >> >> =[Forms]![frmCrit]![txtStartDate] >> >> and the same for the end date. >> -- >> >> John W. Vinson [MVP] > >> .Thank You for Your solution but if I don´t want to use a separate form >> for this ?? > The reason for this is that the command for the report is given from a > start-upform and I want to have the report directly from this > start-upform. > Do You have a solution for this ??? > >> |