Re: Report Based On A Query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rick B (anonymous_at_discussions.microsoft.com)
Date: 06/22/04 

Date: Tue, 22 Jun 2004 09:35:52 -0500

limit the records in your query to only pull records where "schedulers" is
not nul.

Rick B

"Mandy" <anonymous@discussions.microsoft.com> wrote in message
news:1fc3c01c4585c$8795bf30$a401280a@phx.gbl...
I am doing a report based on a query. The fields i
included in the report are BusinessName, Representative,
and Scheduler. I want the report to only show the
businesses that have Schedulers. How can I do this?

Relevant Pages

  • Re: Not print a record with a NULL field
    ... your query to only pull records where that field is not null." ... There is nothing wrong with the query - it's the report that shows the ... created a query against the original file, ...
    (microsoft.public.access.reports)
  • Re: Not print a record with a NULL field
    ... RichK wrote: ... your query to only pull records where that field is not null." ... There is nothing wrong with the query - it's the report that shows the ...
    (microsoft.public.access.reports)
  • Re: Conditional formatting for dates is not working
    ... think) is "record source" and there should be a builder button to the right ... It will open the "query" that is used to pull records to the report. ...
    (microsoft.public.access.reports)
  • 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)