28-Jul-2006, 08:42 AM
|  | Guest | | | | | | | | | | DateAdd
I want to put this string as a criteria in my Date field to be able to see
the results from different date intervals. Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14034-dateadd.html
= DateAdd("d"; -1; [Enter Date]) AND < DateAdd("d"; 2; [Enter Date])
But I receive an error saying:
Syntax Error in expression
E possible che sia stato immeso un operande senza un operatore (italian)
What have I done wrong?
And: Is it possible to visualize this time interval (+-1 day) for all dates Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14034
without being forced to put in a special date; i.e. to show this interval for
all dates at the same time?
Would REALLY need to solve this issue?
Thanks
Andreas 
 Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh! |
28-Jul-2006, 08:42 AM
| | Guest | | | | | | | | | | Re: DateAdd
Andreas
I can't tell from your description where you are trying to use the criteria. Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14034
Are you working on a query?
By the way, if your field is actually named "Date", be aware that Access
treats this as a reserved word, and may get confused as to what field/which
function to use. Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14034
--
Regards
Jeff Boyce
Microsoft Office/Access MVP http://mvp.support.microsoft.com/
Microsoft IT Academy Program Mentor http://microsoftitacademy.com/
Microsoft Registered Partner https://partner.microsoft.com/
"Andreas" wrote in message
news:8DC5BED7-6EEA-4DF7-8E43-56B1A17426FC@microsoft.com...
> I want to put this string as a criteria in my Date field to be able to see
> the results from different date intervals.
>
> = DateAdd("d"; -1; [Enter Date]) AND < DateAdd("d"; 2; [Enter Date])
>
> But I receive an error saying:
>
> Syntax Error in expression
> E possible che sia stato immeso un operande senza un operatore (italian)
>
> What have I done wrong?
>
> And: Is it possible to visualize this time interval (+-1 day) for all
dates
> without being forced to put in a special date; i.e. to show this interval
for
> all dates at the same time?
>
> Would REALLY need to solve this issue?
>
> Thanks
>
> Andreas
 |
28-Jul-2006, 08:42 AM
| | Guest | | | | | | | | | | Re: DateAdd
Indeed, I am working in a query made on a query that is made on a table. The
first query shows which dates two different companies delivers to the same
adress. Now I want to make the same thing except not looking at just one
date, instead a time interval as described
Andreas
"Jeff Boyce" skrev:
> Andreas
>
> I can't tell from your description where you are trying to use the criteria.
> Are you working on a query?
>
> By the way, if your field is actually named "Date", be aware that Access
> treats this as a reserved word, and may get confused as to what field/which
> function to use.
>
> --
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
> http://mvp.support.microsoft.com/
>
> Microsoft IT Academy Program Mentor
> http://microsoftitacademy.com/
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14034
>
> Microsoft Registered Partner
> https://partner.microsoft.com/
>
>
> "Andreas" wrote in message
> news:8DC5BED7-6EEA-4DF7-8E43-56B1A17426FC@microsoft.com...
> > I want to put this string as a criteria in my Date field to be able to see
> > the results from different date intervals.
> >
> > = DateAdd("d"; -1; [Enter Date]) AND < DateAdd("d"; 2; [Enter Date])
> >
> > But I receive an error saying:
> >
> > Syntax Error in expression
> > E possible che sia stato immeso un operande senza un operatore (italian)
> >
> > What have I done wrong?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14034
> >
> > And: Is it possible to visualize this time interval (+-1 day) for all
> dates
> > without being forced to put in a special date; i.e. to show this interval
> for
> > all dates at the same time?
> >
> > Would REALLY need to solve this issue?
> >
> > Thanks
> >
> > Andreas
>
> |
28-Jul-2006, 08:42 AM
| | Guest | | | | | | | | | | Re: DateAdd
Try posting your queries SQL, Then it's easier for us
Pieter
"Andreas" wrote in message
news:5F71BE82-8485-4314-94B6-4A56CB5E46A9@microsoft.com...
> Indeed, I am working in a query made on a query that is made on a table.
> The
> first query shows which dates two different companies delivers to the same
> adress. Now I want to make the same thing except not looking at just one
> date, instead a time interval as described
>
> Andreas
>
> "Jeff Boyce" skrev:
>
>> Andreas
>>
>> I can't tell from your description where you are trying to use the
>> criteria.
>> Are you working on a query?
>>
>> By the way, if your field is actually named "Date", be aware that Access
>> treats this as a reserved word, and may get confused as to what
>> field/which
>> function to use.
>>
>> --
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>> http://mvp.support.microsoft.com/
>>
>> Microsoft IT Academy Program Mentor
>> http://microsoftitacademy.com/
>>
>> Microsoft Registered Partner
>> https://partner.microsoft.com/
>>
>>
>> "Andreas" wrote in message
>> news:8DC5BED7-6EEA-4DF7-8E43-56B1A17426FC@microsoft.com...
>> > I want to put this string as a criteria in my Date field to be able to
>> > see
>> > the results from different date intervals.
>> >
>> > = DateAdd("d"; -1; [Enter Date]) AND < DateAdd("d"; 2; [Enter Date])
>> >
>> > But I receive an error saying:
>> >
>> > Syntax Error in expression
>> > E possible che sia stato immeso un operande senza un operatore
>> > (italian)
>> >
>> > What have I done wrong?
>> >
>> > And: Is it possible to visualize this time interval (+-1 day) for all
>> dates
>> > without being forced to put in a special date; i.e. to show this
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14034
>> > interval
>> for
>> > all dates at the same time?
>> >
>> > Would REALLY need to solve this issue?
>> >
>> > Thanks
>> >
>> > Andreas
>>
>>
--------------------------------------------------------------------------------
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14034
I am using the free version of SPAMfighter for private users.
It has removed 4382 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!
|
28-Jul-2006, 08:42 AM
| | Guest | | | | | | | | | | Re: DateAdd
Here is the sql before the criteria, not possible to open sql with the criteria
Thanks!
Andreas
SELECT [ny_Antonios första].Date AS Espr1, [ny_Antonios första].[NEW RAGIONE
SOCIALE], [ny_Antonios första].[NEW INDIRIZZO], [ny_Antonios första].[NEW Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14034Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14034
LOCALITÁ], Count([ny_Antonios första].SommaDiColli) AS ConteggioDiSommaDiColli
FROM [ny_Antonios första]
GROUP BY [ny_Antonios första].Date, [ny_Antonios första].[NEW RAGIONE
SOCIALE], [ny_Antonios första].[NEW INDIRIZZO], [ny_Antonios första].[NEW
LOCALITÁ];
"Pieter Wijnen" skrev:
> Try posting your queries SQL, Then it's easier for us
>
> Pieter
>
>
> "Andreas" wrote in message
> news:5F71BE82-8485-4314-94B6-4A56CB5E46A9@microsoft.com...
> > Indeed, I am working in a query made on a query that is made on a table.
> > The
> > first query shows which dates two different companies delivers to the same
> > adress. Now I want to make the same thing except not looking at just one
> > date, instead a time interval as described
> >
> > Andreas
> >
> > "Jeff Boyce" skrev:
> >
> >> Andreas
> >>
> >> I can't tell from your description where you are trying to use the
> >> criteria.
> >> Are you working on a query?
> >>
> >> By the way, if your field is actually named "Date", be aware that Access
> >> treats this as a reserved word, and may get confused as to what
> >> field/which
> >> function to use.
> >>
> >> --
> >> Regards
> >>
> >> Jeff Boyce
> >> Microsoft Office/Access MVP
> >> http://mvp.support.microsoft.com/
> >>
> >> Microsoft IT Academy Program Mentor
> >> http://microsoftitacademy.com/
> >>
> >> Microsoft Registered Partner
> >> https://partner.microsoft.com/
> >>
> >>
> >> "Andreas" wrote in message
> >> news:8DC5BED7-6EEA-4DF7-8E43-56B1A17426FC@microsoft.com...
> >> > I want to put this string as a criteria in my Date field to be able to
> >> > see
> >> > the results from different date intervals.
> >> >
> >> > = DateAdd("d"; -1; [Enter Date]) AND < DateAdd("d"; 2; [Enter Date])
> >> >
> >> > But I receive an error saying:
> >> >
> >> > Syntax Error in expression
> >> > E possible che sia stato immeso un operande senza un operatore
> >> > (italian)
> >> >
> >> > What have I done wrong?
> >> >
> >> > And: Is it possible to visualize this time interval (+-1 day) for all
> >> dates
> >> > without being forced to put in a special date; i.e. to show this
> >> > interval
> >> for
> >> > all dates at the same time?
> >> >
> >> > Would REALLY need to solve this issue?
> >> >
> >> > Thanks
> >> >
> >> > Andreas
> >>
> >>
>
> --------------------------------------------------------------------------------
> I am using the free version of SPAMfighter for private users.
> It has removed 4382 spam emails to date.
> Paying users do not have this message in their emails.
> Try SPAMfighter for free now!
>
>
> |
28-Jul-2006, 08:42 AM
| | Guest | | | | | | | | | | Re: DateAdd
capice
PARAMETERS [Enter Date] DateTime;
SELECT [ny_Antonios frsta].Date AS Espr1, [ny_Antonios frsta].[NEW RAGIONE
SOCIALE], [ny_Antonios frsta].[NEW INDIRIZZO], [ny_Antonios frsta].[NEW
LOCALIT], Count([ny_Antonios frsta].SommaDiColli) AS
ConteggioDiSommaDiColli
FROM [ny_Antonios frsta]
WHERE [ny_Antonios frsta].Date >= DateAdd("d", -1, [Enter Date]) AND
[ny_Antonios frsta].Date < DateAdd("d", 2, [Enter Date])
GROUP BY [ny_Antonios frsta].Date, [ny_Antonios frsta].[NEW RAGIONE
SOCIALE], [ny_Antonios frsta].[NEW INDIRIZZO], [ny_Antonios frsta].[NEW
LOCALIT];
I would probably use a Form To Enter The Date Though & Use:
PARAMETERS Forms!MyForm![Enter Date] DateTime;
SELECT [ny_Antonios frsta].Date AS Espr1, [ny_Antonios frsta].[NEW RAGIONE
SOCIALE], [ny_Antonios frsta].[NEW INDIRIZZO], [ny_Antonios frsta].[NEW
LOCALIT], Count([ny_Antonios frsta].SommaDiColli) AS
ConteggioDiSommaDiColli
FROM [ny_Antonios frsta]
WHERE [ny_Antonios frsta].Date >= DateAdd("d", -1, Forms!MyForm![Enter
Date])
AND [ny_Antonios frsta].Date < DateAdd("d", 2, Forms!MyForm![Enter Date])
GROUP BY [ny_Antonios frsta].Date, [ny_Antonios frsta].[NEW RAGIONE
SOCIALE], [ny_Antonios frsta].[NEW INDIRIZZO], [ny_Antonios frsta].[NEW
LOCALIT];
Pieter
"Andreas" wrote in message
news 24FA1FA-D14A-4FA9-8CCE-15E7541F8CE0@microsoft.com...
> Here is the sql before the criteria, not possible to open sql with the
> criteria
>
> Thanks!
>
> Andreas
>
> SELECT [ny_Antonios frsta].Date AS Espr1, [ny_Antonios frsta].[NEW
> RAGIONE
> SOCIALE], [ny_Antonios frsta].[NEW INDIRIZZO], [ny_Antonios frsta].[NEW
> LOCALIT], Count([ny_Antonios frsta].SommaDiColli) AS
> ConteggioDiSommaDiColli
>
> FROM [ny_Antonios frsta]
>
> GROUP BY [ny_Antonios frsta].Date, [ny_Antonios frsta].[NEW RAGIONE
> SOCIALE], [ny_Antonios frsta].[NEW INDIRIZZO], [ny_Antonios frsta].[NEW
> LOCALIT];
>
>
> "Pieter Wijnen" skrev:
>
>> Try posting your queries SQL, Then it's easier for us
>>
>> Pieter
>>
>>
>> "Andreas" wrote in message
>> news:5F71BE82-8485-4314-94B6-4A56CB5E46A9@microsoft.com...
>> > Indeed, I am working in a query made on a query that is made on a
>> > table.
>> > The
>> > first query shows which dates two different companies delivers to the
>> > same
>> > adress. Now I want to make the same thing except not looking at just
>> > one
>> > date, instead a time interval as described
>> >
>> > Andreas
>> >
>> > "Jeff Boyce" skrev:
>> >
>> >> Andreas
>> >>
>> >> I can't tell from your description where you are trying to use the
>> >> criteria.
>> >> Are you working on a query?
>> >>
>> >> By the way, if your field is actually named "Date", be aware that
>> >> Access
>> >> treats this as a reserved word, and may get confused as to what
>> >> field/which
>> >> function to use.
>> >>
>> >> --
>> >> Regards
>> >>
>> >> Jeff Boyce
>> >> Microsoft Office/Access MVP
>> >> http://mvp.support.microsoft.com/
>> >>
>> >> Microsoft IT Academy Program Mentor
>> >> http://microsoftitacademy.com/
>> >>
>> >> Microsoft Registered Partner
>> >> https://partner.microsoft.com/
>> >>
>> >>
>> >> "Andreas" wrote in message
>> >> news:8DC5BED7-6EEA-4DF7-8E43-56B1A17426FC@microsoft.com...
>> >> > I want to put this string as a criteria in my Date field to be able
>> >> > to
>> >> > see
>> >> > the results from different date intervals.
>> >> >
>> >> > = DateAdd("d"; -1; [Enter Date]) AND < DateAdd("d"; 2; [Enter Date])
>> >> >
>> >> > But I receive an error saying:
>> >> >
>> >> > Syntax Error in expression
>> >> > E possible che sia stato immeso un operande senza un operatore
>> >> > (italian)
>> >> >
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14034
>> >> > What have I done wrong?
>> >> >
>> >> > And: Is it possible to visualize this time interval (+-1 day) for
>> >> > all
>> >> dates
>> >> > without being forced to put in a special date; i.e. to show this
>> >> > interval
>> >> for
>> >> > all dates at the same time?
>> >> >
>> >> > Would REALLY need to solve this issue?
>> >> >
>> >> > Thanks
>> >> >
>> >> > Andreas
>> >>
>> >>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14034
>>
>> --------------------------------------------------------------------------------
>> I am using the free version of SPAMfighter for private users.
>> It has removed 4382 spam emails to date.
>> Paying users do not have this message in their emails.
>> Try SPAMfighter for free now!
>>
>>
>>
--------------------------------------------------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4382 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!
|
28-Jul-2006, 08:42 AM
| | Guest | | | | | | | | | | Re: DateAdd
Me scuse ma io non capisco!
I do really appreciate your help, however I must ask an amateur question;
now I tried to copy/paste the first string into the sql in the question I
had, erasing everything so basically I started a new question. Then I got 4
question (date, date, ragione etc) but no matter how I answered them I am not
able to see any information, an empty question without information pops up
instead.
I did the same with the second string but as a source to a form by pasting
it into a question that I went into the properties and data in a new form to
get to. Same result. How should I do to make it work?
"Pieter Wijnen" skrev:
> capice
>
> PARAMETERS [Enter Date] DateTime;
> SELECT [ny_Antonios första].Date AS Espr1, [ny_Antonios första].[NEW RAGIONE
> SOCIALE], [ny_Antonios första].[NEW INDIRIZZO], [ny_Antonios första].[NEW
> LOCALITÁ], Count([ny_Antonios första].SommaDiColli) AS
> ConteggioDiSommaDiColli
> FROM [ny_Antonios första]
> WHERE [ny_Antonios första].Date >= DateAdd("d", -1, [Enter Date]) AND
> [ny_Antonios första].Date < DateAdd("d", 2, [Enter Date])
> GROUP BY [ny_Antonios första].Date, [ny_Antonios första].[NEW RAGIONE
> SOCIALE], [ny_Antonios första].[NEW INDIRIZZO], [ny_Antonios första].[NEW
> LOCALITÁ];
>
> I would probably use a Form To Enter The Date Though & Use:
>
> PARAMETERS Forms!MyForm![Enter Date] DateTime;
> SELECT [ny_Antonios första].Date AS Espr1, [ny_Antonios första].[NEW RAGIONE
> SOCIALE], [ny_Antonios första].[NEW INDIRIZZO], [ny_Antonios första].[NEW
> LOCALITÁ], Count([ny_Antonios första].SommaDiColli) AS
> ConteggioDiSommaDiColli
> FROM [ny_Antonios första]
> WHERE [ny_Antonios första].Date >= DateAdd("d", -1, Forms!MyForm![Enter
> Date])
> AND [ny_Antonios första].Date < DateAdd("d", 2, Forms!MyForm![Enter Date])
> GROUP BY [ny_Antonios första].Date, [ny_Antonios första].[NEW RAGIONE
> SOCIALE], [ny_Antonios första].[NEW INDIRIZZO], [ny_Antonios första].[NEW
> LOCALITÁ];
>
> Pieter
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14034
>
>
> "Andreas" wrote in message
> news24FA1FA-D14A-4FA9-8CCE-15E7541F8CE0@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14034
> > Here is the sql before the criteria, not possible to open sql with the
> > criteria
> >
> > Thanks!
> >
> > Andreas
> >
> > SELECT [ny_Antonios första].Date AS Espr1, [ny_Antonios första].[NEW
> > RAGIONE
> > SOCIALE], [ny_Antonios första].[NEW INDIRIZZO], [ny_Antonios första].[NEW
> > LOCALITÁ], Count([ny_Antonios första].SommaDiColli) AS
> > ConteggioDiSommaDiColli
> >
> > FROM [ny_Antonios första]
> >
> > GROUP BY [ny_Antonios första].Date, [ny_Antonios första].[NEW RAGIONE
> > SOCIALE], [ny_Antonios första].[NEW INDIRIZZO], [ny_Antonios första].[NEW
> > LOCALITÁ];
> >
> >
> > "Pieter Wijnen" skrev:
> >
> >> Try posting your queries SQL, Then it's easier for us
> >>
> >> Pieter
> >>
> >>
> >> "Andreas" wrote in message
> >> news:5F71BE82-8485-4314-94B6-4A56CB5E46A9@microsoft.com...
> >> > Indeed, I am working in a query made on a query that is made on a
> >> > table.
> >> > The
> >> > first query shows which dates two different companies delivers to the
> >> > same
> >> > adress. Now I want to make the same thing except not looking at just
> >> > one
> >> > date, instead a time interval as described
> >> >
> >> > Andreas
> >> >
> >> > "Jeff Boyce" skrev:
> >> >
> >> >> Andreas
> >> >>
> >> >> I can't tell from your description where you are trying to use the
> >> >> criteria.
> >> >> Are you working on a query?
> >> >>
> >> >> By the way, if your field is actually named "Date", be aware that
> >> >> Access
> >> >> treats this as a reserved word, and may get confused as to what
> >> >> field/which
> >> >> function to use.
> >> >>
> >> >> --
> >> >> Regards
> >> >>
> >> >> Jeff Boyce
> >> >> Microsoft Office/Access MVP
> >> >> http://mvp.support.microsoft.com/
> >> >>
> >> >> Microsoft IT Academy Program Mentor
> >> >> http://microsoftitacademy.com/
> >> >>
> >> >> Microsoft Registered Partner
> >> >> https://partner.microsoft.com/
> >> >>
> >> >>
> >> >> "Andreas" wrote in message
> >> >> news:8DC5BED7-6EEA-4DF7-8E43-56B1A17426FC@microsoft.com...
> >> >> > I want to put this string as a criteria in my Date field to be able
> >> >> > to
> >> >> > see
> >> >> > the results from different date intervals.
> >> >> >
> >> >> > = DateAdd("d"; -1; [Enter Date]) AND < DateAdd("d"; 2; [Enter Date])
> >> >> >
> >> >> > But I receive an error saying:
> >> >> >
> >> >> > Syntax Error in expression
> >> >> > E possible che sia stato immeso un operande senza un operatore
> >> >> > (italian)
> >> >> >
> >> >> > What have I done wrong?
> >> >> >
> >> >> > And: Is it possible to visualize this time interval (+-1 day) for
> >> >> > all
> >> >> dates
> >> >> > without being forced to put in a special date; i.e. to show this
> >> >> > interval
> >> >> for
> >> >> > all dates at the same time?
> >> >> >
> >> >> > Would REALLY need to solve this issue?
> >> >> >
> >> >> > Thanks
> >> >> >
> >> >> > Andreas
> >> >>
> >> >>
> >>
> >> --------------------------------------------------------------------------------
> >> I am using the free version of SPAMfighter for private users.
> >> It has removed 4382 spam emails to date.
> >> Paying users do not have this message in their emails.
> >> Try SPAMfighter for free now!
> >>
> >>
> >>
>
> --------------------------------------------------------------------------------
> I am using the free version of SPAMfighter for private users.
> It has removed 4382 spam emails to date.
> Paying users do not have this message in their emails.
> Try SPAMfighter for free now!
>
>
> | 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Gurbani Jukebox |  Listen to Gurbani while surfing SPN! | | » Active Discussions | | | | | | |  ਨਾਮਾ Today 06:37 AM 2 Replies, 53 Views | | | | | | | | | | | | | | | | | | | | | | | | » Books You Should Read... | | | |
