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

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: Update Subform
    ... Good evening John, ... Query Name: Name of my query ... MonthEndTotalSales and Cash Donations on the same report. ... same tblDonators for In-KindDonators and Cash Donators ...
    (microsoft.public.access.forms)
  • Re: help with report and counting values in field
    ... if you just need to get the number of counties into the report ... >>Thank you John, ... Where do I put these expressions in the query grid? ... >simply a user-friendly tool for constructing SQL, ...
    (microsoft.public.access.gettingstarted)
  • Re: Report with condition
    ... Thank you John. ... field with all conditions with is much easier when you run a query. ... how do I show the correct data on the report? ... Null, 2, DG1 is Not Null, 1, True, Null) ...
    (microsoft.public.access.reports)
  • RE: store DateDiff as a calcuable number for queries/reporting
    ... Sorry John, I think you've misunderstood me a bit. ... query or report for a group of records. ... Yet when I've created other dbs that do calculations, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Form- Bringing in multiple data from one combo box
    ... John: ... I manually enter the products stock number, ... Should I be designing a form or report? ... the fields that you want to see in the Combo Box's RowSource query. ...
    (microsoft.public.access.forms)