If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Criteria Filter
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 |
#3
|
|||
|
|||
Criteria Filter
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 |
#4
|
|||
|
|||
Criteria Filter
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 |
#5
|
|||
|
|||
Criteria Filter
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 |
Thread Tools | |
Display Modes | |
|
|