looking up rejected items

A

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.
 
K

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?
 
A

Annette

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

Ken Snell said:
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 said:
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.
 
K

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/


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

Ken Snell said:
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 said:
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.
 
A

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.

Ken Snell said:
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 said:
I have a field for rejected items. The field name is rejected and it is a
text field.

Ken Snell said:
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.
 
K

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.


Annette said:
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 said:
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 said:
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.
 
A

Annette

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

KARL DEWEY said:
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 said:
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 said:
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.
 
K

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.


Annette said:
How do I do a totals query? Thanks in advance.

KARL DEWEY said:
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 said:
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.
 
A

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.

KARL DEWEY said:
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 said:
How do I do a totals query? Thanks in advance.

KARL DEWEY said:
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.
 
S

Steve

Put the following in the criteria of the Rejected field:

Not "0"

Steve
(e-mail address removed)
 
A

Annette

THANK YOU VERY MUCH IT WORKS!!!!!

Steve said:
Put the following in the criteria of the Rejected field:

Not "0"

Steve
(e-mail address removed)


Annette said:
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.
 
K

KARL DEWEY

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


Annette said:
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 said:
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 said:
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.
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top