I need to make shift entry optional

[bhrosey via AccessMonster.com]

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.

 

[Guest]

You could use parameters in your query like:

Like * & [Shift] & *

and for the dept

Like * & [dept] & *

place the two statements in the criteria fields (shift - dept) of the query.
Now if you don't choose a shift or dept you'll see all the records. If you
only choose a shift without the dept you'll see all the shifts. If you enter
a shift and a dept you'll see that criteria..

hth

 

[John Spencer]

Better would be to use
Like Nz([Shift],"*')

Like Nz([Dept],"*")

Those rely on Shift and Dept fields to be text fields and not number fields.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

You could use parameters in your query like:

Like * & [Shift] & *

and for the dept

Like * & [dept] & *

place the two statements in the criteria fields (shift - dept) of the
query.
Now if you don't choose a shift or dept you'll see all the records. If you
only choose a shift without the dept you'll see all the shifts. If you
enter
a shift and a dept you'll see that criteria..

hth
--
Maurice Ausum

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

 

[Gary Walter]

perish

 

[bhrosey via AccessMonster.com]

What is that supposed to mean???

perish

I have a report I run where I query date, shift and department from a
table.

[quoted text clipped - 9 lines]

God Bless,
Bill R.

 

[Gary Walter]

UPDATE Table HisWord
SET Quote = Replace(

, "parish", "perish");

What is that supposed to mean???

perish

I have a report I run where I query date, shift and department from a
table.

[quoted text clipped - 9 lines]

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

 

[bhrosey via AccessMonster.com]

Got it....thanks!

UPDATE Table HisWord
SET Quote = Replace(

, "parish", "perish");

What is that supposed to mean???

[quoted text clipped - 5 lines]