|
| 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
October 20th, 2008, 09:26 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Date Query using Forms Parameter
I have a query set up to use the date parameter entered into a form. I would
like the query to be limited to the date or before that is entered on the form. The critera I have in the query is: =([Forms]![frmCurrentInventoryDateQuery]![cboDate]) "frmCurrentInventoryDateQuery" is the form used to enter the parameter by the user, "cboDate" is the control box the date is typed into on the form. The query returns all records instead of limiting it by the date. Any suggestions? Thanks 
|
|
#2
October 20th, 2008, 09:37 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Date Query using Forms Parameter
I tried it again and it is actually working now, the query returns the
correct records, I don't know what I was doing wrong the first time. "Thorson" wrote: I have a query set up to use the date parameter entered into a form. I would like the query to be limited to the date or before that is entered on the form. The critera I have in the query is: =([Forms]![frmCurrentInventoryDateQuery]![cboDate]) "frmCurrentInventoryDateQuery" is the form used to enter the parameter by the user, "cboDate" is the control box the date is typed into on the form. The query returns all records instead of limiting it by the date. Any suggestions? Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
