looking up rejected items

[Annette]

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.

 

[Ken Snell [MVP]]

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?

 

[Annette]

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

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/

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.

 

[Ken Snell [MVP]]

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/

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

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/

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.

 

[Annette]

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.

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/

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

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/


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.

 

[KARL DEWEY]

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.

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.

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/

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

:

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/


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.

 

[Annette]

How do I do a totals query? Thanks 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.

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.

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/


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

:

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/


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.

 

[KARL DEWEY]

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.

How do I do a totals query? Thanks 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.

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.

:

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/


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

:

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/


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.

 

[Annette]

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.

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.

How do I do a totals query? Thanks 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.


:

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.

:

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/


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

:

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/


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.

 

[Steve]

Put the following in the criteria of the Rejected field:

Not "0"

Steve
(e-mail address removed)

 

[Annette]

THANK YOU VERY MUCH IT WORKS!!!!!

Put the following in the criteria of the Rejected field:

Not "0"

Steve
(e-mail address removed)

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.

 

[KARL DEWEY]

If Reject is a number field then use >0 as your criteria.
--
Build a little, test a little.

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.

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.

How do I do a totals query? Thanks 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.


:

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.

:

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/


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

:

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/


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.

 

[John W. Vinson]

Put the following in the criteria of the Rejected field:

Not "0"

or, better, since it's a Number field not a Text field,

<> 0

 

[Steve]

John,

Read her second post. She says it is a text field. Also read her last post.
If it was a number field, "0" would not work.

Steve