Criteria Filter

I have a database with a column that figures delinquent payment by how many
months delinquent based on their last payment.

now i am wanting to run a report where i tell it to give me a list that are
3 months delinquent but i want to be able to have a pop-up window to ask me
'by how many months' do i want to search.

how do i put this in the criteria of my query? I have tried " [type
number]" but it does not give me correct results. if i just put in the
criteria "3" it gives me the right results but i want to be able to type in
other month ranges.

I hope i made sense.
Thanks!
LTOSH

How are the results incorrect?

What data type is the field that stores the delinquent information?

What does the data in that field look like?

Have you defined the [type number] parameter as the same data type as the
delinquent information field?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"LTOSH" wrote:

I have a database with a column that figures delinquent payment by how many
months delinquent based on their last payment.

now i am wanting to run a report where i tell it to give me a list that are
3 months delinquent but i want to be able to have a pop-up window to ask me
'by how many months' do i want to search.

how do i put this in the criteria of my query? I have tried " [type
number]" but it does not give me correct results. if i just put in the
criteria "3" it gives me the right results but i want to be able to type in
other month ranges.

I hope i made sense.
Thanks!
LTOSH

Try =[type number] and it should work. If not then =Val([Type number])
should.
Or declare the parameter by opening in design view and clicking on Parameter
and entering [Type number] and Data Type as number. To make sure I do
not make a mistake in typing I copy from the criteria and paste in the
parameter row.

--
Build a little, test a little.


"LTOSH" wrote:

I have a database with a column that figures delinquent payment by how many
months delinquent based on their last payment.

now i am wanting to run a report where i tell it to give me a list that are
3 months delinquent but i want to be able to have a pop-up window to ask me
'by how many months' do i want to search.

how do i put this in the criteria of my query? I have tried " [type
number]" but it does not give me correct results. if i just put in the
criteria "3" it gives me the right results but i want to be able to type in
other month ranges.

I hope i made sense.
Thanks!
LTOSH

Great!!! Thanks for quick response...the =Val([Type Number]) worked
perfectly!!!

If i wanted to make it a range criteria..say for example 2 4 how would i
write that??

Leslie

"KARL DEWEY" wrote:

Try =[type number] and it should work. If not then =Val([Type number])
should.
Or declare the parameter by opening in design view and clicking on Parameter
and entering [Type number] and Data Type as number. To make sure I do
not make a mistake in typing I copy from the criteria and paste in the
parameter row.

--
Build a little, test a little.


"LTOSH" wrote:

I have a database with a column that figures delinquent payment by how many
months delinquent based on their last payment.

now i am wanting to run a report where i tell it to give me a list that are
3 months delinquent but i want to be able to have a pop-up window to ask me
'by how many months' do i want to search.

how do i put this in the criteria of my query? I have tried " [type
number]" but it does not give me correct results. if i just put in the
criteria "3" it gives me the right results but i want to be able to type in
other month ranges.

I hope i made sense.
Thanks!
LTOSH

Best way --
Between [Enter start] AND [Enter end]
You can enter the same number at both prompts for single digit requirement.

--
Build a little, test a little.


"LTOSH" wrote:

Great!!! Thanks for quick response...the =Val([Type Number]) worked
perfectly!!!

If i wanted to make it a range criteria..say for example 2 4 how would i
write that??

Leslie

"KARL DEWEY" wrote:

Try =[type number] and it should work. If not then =Val([Type number])
should.
Or declare the parameter by opening in design view and clicking on Parameter
and entering [Type number] and Data Type as number. To make sure I do
not make a mistake in typing I copy from the criteria and paste in the
parameter row.

--
Build a little, test a little.


"LTOSH" wrote:

I have a database with a column that figures delinquent payment by how many
months delinquent based on their last payment.

now i am wanting to run a report where i tell it to give me a list that are
3 months delinquent but i want to be able to have a pop-up window to ask me
'by how many months' do i want to search.

how do i put this in the criteria of my query? I have tried " [type
number]" but it does not give me correct results. if i just put in the
criteria "3" it gives me the right results but i want to be able to type in
other month ranges.

I hope i made sense.
Thanks!
LTOSH