|
| 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
February 17th, 2007, 04:58 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Parameter Dates in Queries - not calculating correctly
I have set up a query to determine deadline dates based on a start date. The
deadline dates range from 1/1/07 to 3/31/08. I have set up a query to pull the items that have a deadline that falls from the parameters that I enter. When I enter the dates 2/1/07 to 2/28/07, it pulls those deadlines in addition to 2/1/08 and 2/28/08 deadlines. Is this a formatting issue? What can I do to correct this so it only pulls 2007? Thanks in advanced for your help. 
|
|
#2
February 17th, 2007, 05:08 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Parameter Dates in Queries - not calculating correctly
I appears that either your date field isn't a date field or you are
converting your date field to a text value. Can you discribe your table structure and provide your SQL view? -- Duane Hookom Microsoft Access MVP "Supple" wrote: I have set up a query to determine deadline dates based on a start date. The deadline dates range from 1/1/07 to 3/31/08. I have set up a query to pull the items that have a deadline that falls from the parameters that I enter. When I enter the dates 2/1/07 to 2/28/07, it pulls those deadlines in addition to 2/1/08 and 2/28/08 deadlines. Is this a formatting issue? What can I do to correct this so it only pulls 2007? Thanks in advanced for your help.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
