Re: Day, month, and current year

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 10/01/04 

Date: Fri, 1 Oct 2004 04:05:18 -0700

Bruce

I don't know if it's relevant, but I noticed that every single reference to
a table field in your query is fully qualified ([tablename].[fieldname])
EXCEPT in the Between ... And ... clause. Again, don't know if that's
important.

Have you already tried starting over from scratch, and building a new copy
of the query? Once or twice I've encountered a corrupted query that doesn't
show up and doesn't "compact/repair". In those cases, I was able to start
over, build a query that did what I wanted, and delete the old,
no-longer-functional query.

Another possibility would be to "chain" (nest) a pair of queries. In the
first, calculate the [ReviewDate] and return the other fields you want --
apply all criteria except the Between ... And .... In the second, apply the
Between ... And ... criteria to [ReviewDate]. 

-- 
Good luck
Jeff Boyce
<Access MVP>

Relevant Pages

  • Re: Date criteria
    ... I added ReviewDate to the query as a calculated field: ... It looks right (if the expiration date is 1/15/06, ... Day) or DateAdd as the criteria for ReviewDate ...
    (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)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)
  • RE: Filtering a subform using many combo boxes
    ... I followed you instructions to the letter and every one of the criteria ... I described the typical properties of all my combo boxes in my original ... open the query "qryProjects" in design view. ... I have a main table named tblProjectData that contains all the data for each ...
    (microsoft.public.access.forms)