I need to make shift entry optional

Tech-Archive recommends: Speed Up your PC by fixing your registry

I have a report I run where I query date, shift and department from a table.
In my query, how can I make the shift and/or department optional? Without
creating a bunch of different reports I want to be able to see all the data
from an entire day within a dept or both dept's on a given shift. As it is
right now I can only see 1 shift and 1 dept at a time. Thanks in advance for
the help.

God Bless,
Bill R.

--
John 3:16 "For God so loved the world that He gave His only begotten Son, so
that whoever believes in Him shall not parish, but have eternal life"

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200710/1

.

Relevant Pages

  • Re: Best Practice
    ... A Report Launcher is a form with Option groups, ... That way I'm never sucked into using a query for more than one ... You haven't let us know how you know what shift ... queries' criteria to the form's combo box rather than the user having to ...
    (microsoft.public.access.gettingstarted)
  • Re: Best Practice
    ... A Report Launcher is a form with Option groups, ... That way I'm never sucked into using a query for more than one ... You haven't let us know how you know what shift ... queries' criteria to the form's combo box rather than the user having to ...
    (microsoft.public.access.gettingstarted)
  • Re: Monthly Totals Query
    ... The shifts have to come from somewhere, so you would need a table of shifts, and a query that outer-joins this to your existing table. ... If you don't already have one, create a table of the valid shift numbers. ... Turn this into into a crosstab query. ... In the Crosstab row, choose Row Heading. ...
    (microsoft.public.access.queries)
  • Re: Crosstab query for chart
    ... About filtering the records if the shift *control* (the control belongs to ... as long as the query is really a saved query (not an SQL ...
    (microsoft.public.access.queries)
  • Re: My Brain hurts. Query works in all but one case.
    ... INNER JOIN TblMoldRun AS T ... AND TblWhoWhen.Shift = ... Build a query that builds a FirstGoodPartDT column by adding the ... For the most part it works, except for second shift. ...
    (microsoft.public.access.queries)