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

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: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Tips on domain aggregate replacements
    ... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
    (microsoft.public.access.modulesdaovba)
  • 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: Truncating a date
    ... >> expect a column named 'YrMonth' to exclude the day. ... >> expression in the source query? ... >>>I have a report that pulls data from one query. ...
    (microsoft.public.access.reports)
Loading