|
| 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
March 7th, 2010, 07:36 PM
posted to microsoft.public.access
|
|||
|
|||
Search criteria between - and
I have a table containing let´s say 5 posts – A,B,C,D and E.
Then I make a selecting question with query conditions like “Between C and H” The result then will be C,D and E. If I want to make a report from this result and I in the header of this report want to have “This report contains posts between C and H” How will I achive this ??? -- Thanks in advance for Your help 
|
|
#2
March 7th, 2010, 08:01 PM
posted to microsoft.public.access
|
|||
|
|||
|
Search criteria between - and
The usual way to give the user a way to select criteria is by unbound
controls on a form. In your case you need a way for the user to select C and H. You could use a form named FrmCriteria with two comboboxes named FirstLetter and LastLetter. Your query then would have the criteria: Between Forms!FrmCriteria!FirstLetter And Forms!FrmCriteria!LastLetter You would need to insure that the form was open (perhaps not visible) when the report opened so the recordsource query could find the two criteria fields. To get "This report contains posts between C and H" in the report header, all you need is a textbox in the report header with the following expression in the control source: =""This report contains posts between " & Forms!FrmCriteria!FirstLetter & " and " & Forms!FrmCriteria!LastLetter watch for wrapping Steve "Leif Thorsen" wrote in message ... I have a table containing lets say 5 posts - A,B,C,D and E. Then I make a selecting question with query conditions like "Between C and H" The result then will be C,D and E. If I want to make a report from this result and I in the header of this report want to have "This report contains posts between C and H" How will I achive this ??? -- Thanks in advance for Your help
|
|
#3
March 9th, 2010, 10:18 AM
posted to microsoft.public.access
|
|||
|
|||
|
Search criteria between - and
Steve !!
Thank You for Your answer !! But is there no way to pick up the expressions inside the two (or four depending how You see it) brackets [ ] within the query instead for making a separate form for it ?? The reason for my wish is that I already have a command buttom in form for "Print me a report" and don´t want to open a new form when I already is working in one. -- Thanks in advance for Your help "Steve" wrote: The usual way to give the user a way to select criteria is by unbound controls on a form. In your case you need a way for the user to select C and H. You could use a form named FrmCriteria with two comboboxes named FirstLetter and LastLetter. Your query then would have the criteria: Between Forms!FrmCriteria!FirstLetter And Forms!FrmCriteria!LastLetter You would need to insure that the form was open (perhaps not visible) when the report opened so the recordsource query could find the two criteria fields. To get "This report contains posts between C and H" in the report header, all you need is a textbox in the report header with the following expression in the control source: =""This report contains posts between " & Forms!FrmCriteria!FirstLetter & " and " & Forms!FrmCriteria!LastLetter watch for wrapping Steve "Leif Thorsen" wrote in message ... I have a table containing let´s say 5 posts - A,B,C,D and E. Then I make a selecting question with query conditions like "Between C and H" The result then will be C,D and E. If I want to make a report from this result and I in the header of this report want to have "This report contains posts between C and H" How will I achive this ??? -- Thanks in advance for Your help .
|
|
#4
March 9th, 2010, 04:25 PM
posted to microsoft.public.access
|
|||
|
|||
|
Search criteria between - and
On Tue, 9 Mar 2010 02:18:02 -0800, Leif Thorsen
wrote: Steve !! Thank You for Your answer !! But is there no way to pick up the expressions inside the two (or four depending how You see it) brackets [ ] within the query instead for making a separate form for it ?? The reason for my wish is that I already have a command buttom in form for "Print me a report" and dont want to open a new form when I already is working in one. You can put textboxes on your current form and reference them; you don't need to open a separate form. -- John W. Vinson [MVP]
|
|
#5
March 13th, 2010, 05:35 PM
posted to microsoft.public.access
|
|||
|
|||
|
Search criteria between - and
"Leif Thorsen" wrote in message ... Steve !! Thank You for Your answer !! But is there no way to pick up the expressions inside the two (or four depending how You see it) brackets [ ] within the query instead for making a separate form for it ?? The reason for my wish is that I already have a command buttom in form for "Print me a report" and don´t want to open a new form when I already is working in one. -- Thanks in advance for Your help "Steve" wrote: The usual way to give the user a way to select criteria is by unbound controls on a form. In your case you need a way for the user to select C and H. You could use a form named FrmCriteria with two comboboxes named FirstLetter and LastLetter. Your query then would have the criteria: Between Forms!FrmCriteria!FirstLetter And Forms!FrmCriteria!LastLetter You would need to insure that the form was open (perhaps not visible) when the report opened so the recordsource query could find the two criteria fields. To get "This report contains posts between C and H" in the report header, all you need is a textbox in the report header with the following expression in the control source: =""This report contains posts between " & Forms!FrmCriteria!FirstLetter & " and " & Forms!FrmCriteria!LastLetter watch for wrapping Steve "Leif Thorsen" wrote in message ... I have a table containing let´s say 5 posts - A,B,C,D and E. Then I make a selecting question with query conditions like "Between C and H" The result then will be C,D and E. If I want to make a report from this result and I in the header of this report want to have "This report contains posts between C and H" How will I achive this ??? -- Thanks in advance for Your help .
|
|
#6
March 17th, 2010, 01:48 PM
posted to microsoft.public.access
|
|||
|
|||
|
Search criteria between - and
jkjkjkjk
"Leif Thorsen" a écrit dans le message de groupe de discussion : ... I have a table containing let´s say 5 posts – A,B,C,D and E. Then I make a selecting question with query conditions like “Between C and H” The result then will be C,D and E. If I want to make a report from this result and I in the header of this report want to have “This report contains posts between C and H” How will I achive this ??? -- Thanks in advance for Your help
|
|
#7
April 19th, 2010, 05:55 PM
posted to microsoft.public.access
|
|||
|
|||
|
Search criteria between - and
"Leif Thorsen" ha scritto nel messaggio ... Steve !! Thank You for Your answer !! But is there no way to pick up the expressions inside the two (or four depending how You see it) brackets [ ] within the query instead for making a separate form for it ?? The reason for my wish is that I already have a command buttom in form for "Print me a report" and don´t want to open a new form when I already is working in one. -- Thanks in advance for Your help "Steve" wrote: The usual way to give the user a way to select criteria is by unbound controls on a form. In your case you need a way for the user to select C and H. You could use a form named FrmCriteria with two comboboxes named FirstLetter and LastLetter. Your query then would have the criteria: Between Forms!FrmCriteria!FirstLetter And Forms!FrmCriteria!LastLetter You would need to insure that the form was open (perhaps not visible) when the report opened so the recordsource query could find the two criteria fields. To get "This report contains posts between C and H" in the report header, all you need is a textbox in the report header with the following expression in the control source: =""This report contains posts between " & Forms!FrmCriteria!FirstLetter & " and " & Forms!FrmCriteria!LastLetter watch for wrapping Steve "Leif Thorsen" wrote in message ... I have a table containing let´s say 5 posts - A,B,C,D and E. Then I make a selecting question with query conditions like "Between C and H" The result then will be C,D and E. If I want to make a report from this result and I in the header of this report want to have "This report contains posts between C and H" How will I achive this ??? -- Thanks in advance for Your help .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
