|
| 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 |
|
#21
December 1st, 2009, 05:38 PM
posted to microsoft.public.access
|
|||
|
|||
Month-to-date
Karim -
Can you explain what you mean by 'not working'? Today is the 1st of the month, so I would expect no results until a near miss for December is added. Are you getting an error message? -- Daryl S "karim" wrote: in another way: Month To Date: = DateSerial(Year(Date()), Month(Date()), 1) This code is what I need, but it's not working in the criteria... 
|
|
#22
December 1st, 2009, 05:38 PM
posted to microsoft.public.access
|
|||
|
|||
|
Month-to-date
Karim -
Can you explain what you mean by 'not working'? Today is the 1st of the month, so I would expect no results until a near miss for December is added. Are you getting an error message? -- Daryl S "karim" wrote: in another way: Month To Date: = DateSerial(Year(Date()), Month(Date()), 1) This code is what I need, but it's not working in the criteria...
|
|
#23
December 1st, 2009, 05:38 PM
posted to microsoft.public.access
|
|||
|
|||
|
Month-to-date
Karim -
Can you explain what you mean by 'not working'? Today is the 1st of the month, so I would expect no results until a near miss for December is added. Are you getting an error message? -- Daryl S "karim" wrote: in another way: Month To Date: = DateSerial(Year(Date()), Month(Date()), 1) This code is what I need, but it's not working in the criteria...
|
|
#24
December 1st, 2009, 05:46 PM
posted to microsoft.public.access
|
|||
|
|||
|
Month-to-date
yes, I am getting an error msg "#Name?"
I also added a record for today just to try it. Basically what I am doing is I made a form and I have a text box that suppose to show the totla records in it, but it's giving me that error.
|
|
#25
December 1st, 2009, 05:46 PM
posted to microsoft.public.access
|
|||
|
|||
|
Month-to-date
yes, I am getting an error msg "#Name?"
I also added a record for today just to try it. Basically what I am doing is I made a form and I have a text box that suppose to show the totla records in it, but it's giving me that error.
|
|
#26
December 1st, 2009, 05:46 PM
posted to microsoft.public.access
|
|||
|
|||
|
Month-to-date
yes, I am getting an error msg "#Name?"
I also added a record for today just to try it. Basically what I am doing is I made a form and I have a text box that suppose to show the totla records in it, but it's giving me that error.
|
|
#27
December 1st, 2009, 06:39 PM
posted to microsoft.public.access
|
|||
|
|||
|
Month-to-date
That's probably due to an element of the calculation referring to an
object name that does not exist. Given Price and Qty then a calculation like... Prize * Qty = LineTotal would yield a #Name? error. Check the spelling in the calc vs. the real object names. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "karim" wrote in message ... yes, I am getting an error msg "#Name?" I also added a record for today just to try it. Basically what I am doing is I made a form and I have a text box that suppose to show the totla records in it, but it's giving me that error.
|
|
#28
December 1st, 2009, 06:39 PM
posted to microsoft.public.access
|
|||
|
|||
|
Month-to-date
That's probably due to an element of the calculation referring to an
object name that does not exist. Given Price and Qty then a calculation like... Prize * Qty = LineTotal would yield a #Name? error. Check the spelling in the calc vs. the real object names. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "karim" wrote in message ... yes, I am getting an error msg "#Name?" I also added a record for today just to try it. Basically what I am doing is I made a form and I have a text box that suppose to show the totla records in it, but it's giving me that error.
|
|
#29
December 1st, 2009, 06:39 PM
posted to microsoft.public.access
|
|||
|
|||
|
Month-to-date
That's probably due to an element of the calculation referring to an
object name that does not exist. Given Price and Qty then a calculation like... Prize * Qty = LineTotal would yield a #Name? error. Check the spelling in the calc vs. the real object names. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "karim" wrote in message ... yes, I am getting an error msg "#Name?" I also added a record for today just to try it. Basically what I am doing is I made a form and I have a text box that suppose to show the totla records in it, but it's giving me that error.
|
|
#30
December 1st, 2009, 08:14 PM
posted to microsoft.public.access
|
|||
|
|||
|
Month-to-date
Karim -
If you are using a query, can you post the SQL to your query (copy/paste from the SQL View)? That will help us see what you are doing. I assume this is the query behind the form? -- Daryl S "karim" wrote: yes, I am getting an error msg "#Name?" I also added a record for today just to try it. Basically what I am doing is I made a form and I have a text box that suppose to show the totla records in it, but it's giving me that error.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
