Re: Form is grow

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

and what is the code with OrderBy??

Duncan Bachen wrote:
Sorry mistake

Fields [DayOfPay] and [Pay]

Sure. All the filter does is act like a where clause.
Me.Filter = "[DayOfPay] >= #" & DateAdd("d", -30, Date()) & "# AND
[Pay]=12345"
Me.FilterOn = True


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200603/1
.

Relevant Pages

  • Re: Aggregate Functions and Null
    ... > preserved table using WHERE clause, ... adding the outer rows, while the WHERE is applied after. ... If you filter in the ON clause, you'll end up with ALL rows from the ... e.g., when you join Customers LOJ Orders, and want to filter customers from ...
    (microsoft.public.sqlserver.programming)
  • RE: Passing Qry as part of Rpt DoCmd.OpenReport
    ... You are, by your description, trying to filter the output of the report. ... If you create a string that is a Where Clause without the word Where, ... And yes my data query is plain vanillia with no where clause only a single ...
    (microsoft.public.access.reports)
  • Re: How to summarize recordset...Select Distinct alternative?
    ... You can loop through this one to using Filter to easily do the first ... GROUP BY groups, it doesn't filter. ... are done on the grouped records in the SELECT clause. ... where FldPage contained "Page2". ...
    (microsoft.public.data.ado)
  • Re: Filter By Calculated Field
    ... If you mean the prompt string in the Having clause, ... You can filter the total in many different ways. ... FROM [UnionSeasonCount Query] ... SELECT DISTINCT Season, MailingListID ...
    (microsoft.public.access.queries)
  • Re: GPLv3 Position Statement
    ... running the program) within the meaning of GPLv2 clause 0. ... The vendor did many acts covered by copyright law (taking US copyright ... license on each act: ... Vendor runs Linux on prototype hardware to see where it fails ...
    (Linux-Kernel)