Re: How to combine values from 2 fields for a report

In that case, I would guess that your fields are not DateTime fields, but are
actually text fields.

Can you check and see what type of fields Due and Out (what are the real names
by the way) are?

donnadele wrote:
>
> I get an error that says Data type mismatch in criteria expression when I try
> these.
>
> "John Spencer (MVP)" wrote:
>
> > Here is criteria that should work, although it will be slow.
> >
> > Field: Out
> > Criteria: > CDate(NZ([Due],#12/1/1900#))
> >
> > You could try
> >
> > Field: Out
> > CriteriaLine1: > Due
> >
> >
> > Field: Due
> > CriteriaLine2: Is Null
> >
> > In SQL
> >
> > WHERE Out>Due or Due Is Null
> >
> > donnadele wrote:
> > >
> > > Help please anyone!!! We are getting desperate here. OUr company president
> > > wants this report and we all feel rather like idiots that we can't figure out
> > > how to make this work.
> > >
> > > I have two fields, one is "due" and the next is "out". What we want to do
> > > is have a query that pulls the records from the "out" field that are greater
> > > than the "due" field, plus we want to include all the "out" records that are
> > > null. Can this be done?
> > >
> > > "donnadele" wrote:
> > >
> > > > What I am trying to do is make a report that shows when out dates are later
> > > > than thier due dates plus when the out dates are left blank. I need a query
> > > > that will pull both the dates greater than the due date, and those that are
> > > > null. Does that help?
> > > >
> > > > "John H W" wrote:
> > > >
> > > > > I am not really sure what you need, but as far as the query is concerned, try:
> > > > > WHERE [due date] < #show date# AND [second field] = #12:00:00 AM#
> > > > >
> > > > > Hopy this helps some.
> > > > >
> > > > > John H W
> > > > >
> > > > > "donnadele" wrote:
> > > > >
> > > > > > I am trying to build an expression in a query that will show dates that are
> > > > > > greater than the due date in one field and is null in the second field which
> > > > > > is the out date. We are putting this expression in the criteria of the out
> > > > > > date field. Can anyone help me?
> >
.

Relevant Pages

  • Re: Query Help!
    ... I would change them to datetime fields if that is ALL you store in them. ... Create a query with your date field and then apply criteria to return any records where the date string could not be interpreted as a date. ... Access MVP 2002-2005, 2007-2009 ... from the "callback" field with the calculated field's value: ...
    (microsoft.public.access.queries)
  • Re: Countif/And Function
    ... >> criteria. ... >> this be done using the COUNTIF or AND functions?? ... >> count the number of cells in column E with a value of N in column E AND a ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Diagonalizing blocks of a unitary matrix
    ... unitary transormation matrix, i.e. there exists a unitary n*n matrix U ... commute with each other, but this does not seem to be sufficient. ... there some criteria, ... Prev by Date: ...
    (sci.math)
  • Re: Multiple conditions in DLookUp
    ... > Also incase the criteria is with date then we should add the Hash letter ... >> need the syntactically required quotemarks: ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Multiple conditions in DLookUp
    ... >> Also incase the criteria is with date then we should add the Hash letter ... Prev by Date: ...
    (microsoft.public.access.queries)