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

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: Corstabquery or normal query
    ... You can create the crosstab similar to the suggestion by John. ... church, also church elders, we have many elders, only 1st elder is one person. ... I would first build a query to get the data ...
    (microsoft.public.access.reports)
  • Re: Creatinig a database to update in alphabetical order
    ... John M. it is like you are reading my mind, ... know I am a movie fanatic. ... > should not be routine) displayed as a query datasheet. ... > Keyword ...
    (microsoft.public.access.gettingstarted)
  • Re: Simply adding two fields
    ... Thank you, John. ... In an update query you update the field to the calculation. ... field before you add it to the master field you will have a problem. ... I'm reading a transaction file of widgets delivered and I want to update ...
    (microsoft.public.access.queries)
  • Re: problem with query
    ... Thanks John, it is not a number field, it is text. ... Open tblSitLog and look at the field SIT - what type of field is ... You may need to write the query as follows ... , tblSITLog.[NATURE OF iNCIDENT] ...
    (microsoft.public.access.queries)
  • Re: set first record to zero in a calculated field
    ... John, after playing around with the FOrmat comand, I think I managed to get ... I resolved it in my previous query by using the Format command in the SQL, ... Center for Health Program Development and Management ...
    (microsoft.public.access.queries)
Loading