looking up rejected items

I’m new to access and I’m trying to make a query to look up rejected items.
I’m doing this by date so in the criteria I have “Between [Enter Start Date]
And [Enter End Date]� it is working fine. I need to show items that are
rejected. If there isn’t any rejected we have entered a 0. What do I need
to put in the criteria to show the number of rejected items? Thank you in
advance.

Do you have a field that indicates that an item has been rejected? What is
the name of that field? What datatype is that field?

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Annette" wrote in message
...
I'm new to access and I'm trying to make a query to look up rejected
items.
I'm doing this by date so in the criteria I have "Between [Enter Start
Date]
And [Enter End Date]" it is working fine. I need to show items that
are
rejected. If there isn't any rejected we have entered a 0. What do I
need
to put in the criteria to show the number of rejected items? Thank you
in
advance.

I have a field for rejected items. The field name is rejected and it is a
text field.

"Ken Snell [MVP]" wrote:

Do you have a field that indicates that an item has been rejected? What is
the name of that field? What datatype is that field?

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Annette" wrote in message
...
I'm new to access and I'm trying to make a query to look up rejected
items.
I'm doing this by date so in the criteria I have "Between [Enter Start
Date]
And [Enter End Date]" it is working fine. I need to show items that
are
rejected. If there isn't any rejected we have entered a 0. What do I
need
to put in the criteria to show the number of rejected items? Thank you
in
advance.

Use this as example of the criterion for that field (I assume the word
Rejected is in the field when it's a rejected item):

= 'Rejected'

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Annette" wrote in message
...
I have a field for rejected items. The field name is rejected and it is a
text field.

"Ken Snell [MVP]" wrote:

Do you have a field that indicates that an item has been rejected? What
is
the name of that field? What datatype is that field?

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Annette" wrote in message
...
I'm new to access and I'm trying to make a query to look up rejected
items.
I'm doing this by date so in the criteria I have "Between [Enter Start
Date]
And [Enter End Date]" it is working fine. I need to show items that
are
rejected. If there isn't any rejected we have entered a 0. What do I
need
to put in the criteria to show the number of rejected items? Thank
you
in
advance.

There is a zero in the field if they aren't rejected. If it is rejected they
put a number in the field. It's how many were rejected. It could be 1 to
500. I hope this helps.

"Ken Snell [MVP]" wrote:

Use this as example of the criterion for that field (I assume the word
Rejected is in the field when it's a rejected item):

= 'Rejected'

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Annette" wrote in message
...
I have a field for rejected items. The field name is rejected and it is a
text field.

"Ken Snell [MVP]" wrote:

Do you have a field that indicates that an item has been rejected? What
is
the name of that field? What datatype is that field?

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Annette" wrote in message
...
I'm new to access and I'm trying to make a query to look up rejected
items.
I'm doing this by date so in the criteria I have "Between [Enter Start
Date]
And [Enter End Date]" it is working fine. I need to show items that
are
rejected. If there isn't any rejected we have entered a 0. What do I
need
to put in the criteria to show the number of rejected items? Thank
you
in
advance.

I think if you use a totals query and sum the reject field it will give you
what you want.
--
Build a little, test a little.


"Annette" wrote:

There is a zero in the field if they aren't rejected. If it is rejected they
put a number in the field. It's how many were rejected. It could be 1 to
500. I hope this helps.

"Ken Snell [MVP]" wrote:

Use this as example of the criterion for that field (I assume the word
Rejected is in the field when it's a rejected item):

= 'Rejected'

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Annette" wrote in message
...
I have a field for rejected items. The field name is rejected and it is a
text field.

"Ken Snell [MVP]" wrote:

Do you have a field that indicates that an item has been rejected? What
is
the name of that field? What datatype is that field?

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Annette" wrote in message
...
I'm new to access and I'm trying to make a query to look up rejected
items.
I'm doing this by date so in the criteria I have "Between [Enter Start
Date]
And [Enter End Date]" it is working fine. I need to show items that
are
rejected. If there isn't any rejected we have entered a 0. What do I
need
to put in the criteria to show the number of rejected items? Thank
you
in
advance.

How do I do a totals query? Thanks in advance.

"KARL DEWEY" wrote:

I think if you use a totals query and sum the reject field it will give you
what you want.
--
Build a little, test a little.


"Annette" wrote:

There is a zero in the field if they aren't rejected. If it is rejected they
put a number in the field. It's how many were rejected. It could be 1 to
500. I hope this helps.

"Ken Snell [MVP]" wrote:

Use this as example of the criterion for that field (I assume the word
Rejected is in the field when it's a rejected item):

= 'Rejected'

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Annette" wrote in message
...
I have a field for rejected items. The field name is rejected and it is a
text field.

"Ken Snell [MVP]" wrote:

Do you have a field that indicates that an item has been rejected? What
is
the name of that field? What datatype is that field?

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Annette" wrote in message
...
I'm new to access and I'm trying to make a query to look up rejected
items.
I'm doing this by date so in the criteria I have "Between [Enter Start
Date]
And [Enter End Date]" it is working fine. I need to show items that
are
rejected. If there isn't any rejected we have entered a 0. What do I
need
to put in the criteria to show the number of rejected items? Thank
you
in
advance.

Open your query in design view. Click on the icon that looks like an "M" on
its side - ∑ to change a select query to a totals query.

Then change the Group By in the grid to Sum for the field you want to total.

--
Build a little, test a little.


"Annette" wrote:

How do I do a totals query? Thanks in advance.

"KARL DEWEY" wrote:

I think if you use a totals query and sum the reject field it will give you
what you want.
--
Build a little, test a little.


"Annette" wrote:

There is a zero in the field if they aren't rejected. If it is rejected they
put a number in the field. It's how many were rejected. It could be 1 to
500. I hope this helps.

"Ken Snell [MVP]" wrote:

Use this as example of the criterion for that field (I assume the word
Rejected is in the field when it's a rejected item):

= 'Rejected'

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Annette" wrote in message
...
I have a field for rejected items. The field name is rejected and it is a
text field.

"Ken Snell [MVP]" wrote:

Do you have a field that indicates that an item has been rejected? What
is
the name of that field? What datatype is that field?

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Annette" wrote in message
...
I'm new to access and I'm trying to make a query to look up rejected
items.
I'm doing this by date so in the criteria I have "Between [Enter Start
Date]
And [Enter End Date]" it is working fine. I need to show items that
are
rejected. If there isn't any rejected we have entered a 0. What do I
need
to put in the criteria to show the number of rejected items? Thank
you
in
advance.

Thanks, but I'm not totaling I just need to know the item that was rejected.
The person that rejects the item put the total rejected and if they don't
reject it the put a zero in the rejected field. I want to be able to look up
the rejected item per date. The date works fine but it brings up all the
items in the rejected field even the ones with the zero in it. Thanks in
advance.

"KARL DEWEY" wrote:

Open your query in design view. Click on the icon that looks like an "M" on
its side - ∑ to change a select query to a totals query.

Then change the Group By in the grid to Sum for the field you want to total.

--
Build a little, test a little.


"Annette" wrote:

How do I do a totals query? Thanks in advance.

"KARL DEWEY" wrote:

I think if you use a totals query and sum the reject field it will give you
what you want.
--
Build a little, test a little.


"Annette" wrote:

There is a zero in the field if they aren't rejected. If it is rejected they
put a number in the field. It's how many were rejected. It could be 1 to
500. I hope this helps.

"Ken Snell [MVP]" wrote:

Use this as example of the criterion for that field (I assume the word
Rejected is in the field when it's a rejected item):

= 'Rejected'

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Annette" wrote in message
...
I have a field for rejected items. The field name is rejected and it is a
text field.

"Ken Snell [MVP]" wrote:

Do you have a field that indicates that an item has been rejected? What
is
the name of that field? What datatype is that field?

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Annette" wrote in message
...
I'm new to access and I'm trying to make a query to look up rejected
items.
I'm doing this by date so in the criteria I have "Between [Enter Start
Date]
And [Enter End Date]" it is working fine. I need to show items that
are
rejected. If there isn't any rejected we have entered a 0. What do I
need
to put in the criteria to show the number of rejected items? Thank
you
in
advance.

Put the following in the criteria of the Rejected field:

Not "0"

Steve



"Annette" wrote in message
...
I'm new to access and I'm trying to make a query to look up rejected
items.
I'm doing this by date so in the criteria I have "Between [Enter Start
Date]
And [Enter End Date]" it is working fine. I need to show items that
are
rejected. If there isn't any rejected we have entered a 0. What do I
need
to put in the criteria to show the number of rejected items? Thank you
in
advance.