RE: Exclude

I don't fully understand ....but:

to exclude results based upon date, put in the criteria of your query for
the appropriate field: >8/4/08
(using today's date as an example)

obviously put in the appropriate date to segregate "this week" from "last
week"...and you might need to get creative as to whether this date is entered
manually or auto entered based upon perhaps the computer's system date...

--
NTC


"earrozz via AccessMonster.com" wrote:

I have a database from which I have to produce weekly reports excluding
previous week report. Below is an example how the reprt should look like.

Logged Date Recieved Date Completed Dated 415 Current Status
2008/08/01 2008/08/10 2008/08/20 Cancelled

(only Cancelled or Completed here)


how can I only exclcude previous weeks report weekly per completed/cancelled
(pending on the 415 Current Status) system date (meaninig per the date in the
computer when I punched Cancelled or Completed under 415 Current Status)?

--
Message posted via http://www.accessmonster.com


.

Relevant Pages

  • Re: Criteria & <>
    ... I'm trying to create a year-end check out report for my school. ... I'm having a problem creating the query for this new report. ... exclude certain records. ... I dropped to the "or" criteria line and added another title ID that I ...
    (microsoft.public.access.queries)
  • Re: Exclude records that meet criteria
    ... It is important to mention that if the field used in the subquery has Null ... the main query will never return anything. ... use a subquery on the second table in the criteria ... I need to exclude rather than include records from a table that meet ...
    (microsoft.public.access.modulesdaovba)
  • Excluding data from a query
    ... query that excludes certain criteria using a Between and clause but I ... need to exclude more cirteria from that query and I can't seem to get ... This database tracks advertising on buses by side. ...
    (microsoft.public.access.queries)
  • Re: how can I use a table as a list of records not to includ in a qry
    ... Tell us specifically what your criteria is. ... a query to include and exclude the criteria desired. ... > I have to get a table of records that have certain keywords and don't have ...
    (microsoft.public.access.queries)
  • RE: Filtering a subform using many combo boxes
    ... SELECT AssignedPriority, AssignedPriorityDetail FROM tblAssignedPriority ... YES for all of the combo boxes.) ... I followed you instructions to the letter and every one of the criteria ... open the query "qryProjects" in design view. ...
    (microsoft.public.access.forms)
Loading