Sorting by date

[Guest]

I have a question made from another question. It tells me to which adresses
two companies have delievered goods the same date the last year. Now I want
to see the same thing but change the demand that it has to be the same day.
Instead I want to see which transports that have been made to the sam adress
with a time span of +- 1 day from any date. How can I do this?

 

[John Vinson]

I have a question made from another question. It tells me to which adresses
two companies have delievered goods the same date the last year. Now I want
to see the same thing but change the demand that it has to be the same day.
Instead I want to see which transports that have been made to the sam adress
with a time span of +- 1 day from any date. How can I do this?

Add a criterion on the date field such as

= DateAdd("d", -1, [Enter Date:]) AND < DateAdd("d", 2, [Enter Date:])

John W. Vinson[MVP]

 

[Guest]

Voila! Perfect! Thanks!

But I tried everything on a copy of my originial table to be on the safe
side. I have a lot of questions and forms built up upon "consegna", how can I
make this change in the original table without affecting this?

Andreas

"John Vinson" skrev:

I have a question made from another question. It tells me to which adresses
two companies have delievered goods the same date the last year. Now I want
to see the same thing but change the demand that it has to be the same day.
Instead I want to see which transports that have been made to the sam adress
with a time span of +- 1 day from any date. How can I do this?

Add a criterion on the date field such as

= DateAdd("d", -1, [Enter Date:]) AND < DateAdd("d", 2, [Enter Date:])

John W. Vinson[MVP]

 

[John Vinson]

Voila! Perfect! Thanks!

But I tried everything on a copy of my originial table to be on the safe
side. I have a lot of questions and forms built up upon "consegna", how can I
make this change in the original table without affecting this?

Andreas

I'm sorry, I have no idea what you're asking here.

My suggestion did not involve ANY change to ANY table - just a
criterion in a query to retrieve a date range.


John W. Vinson[MVP]

 

[Guest]

Sorry about that, it was another question I got answered.

When I write the code you gave me I get an error message (Unfortunately in
italian but I do my best to translate)

"Errore di sintassi nell espressione" (Error in the syntax(syntax is a
professional guess) of the expression)

"Operando o operatore mancante, carattere o virgola non valida oppure testo
immesso non racchiuso tra virgolette" (Operator or operation is missing,
character or comma is not valid otherwise ... etc)

I understand it is not easy for you but I would really appreciate your
help


I have done exactly as you described otherwise (I think...) I write my date
as yyyy-mm-dd if that will help.

"John Vinson" skrev:

 

[Pieter Wijnen]

Use ';' instead of ',' in a Query, Form or Report (GUI)
The GUI uses the Windows (Regional settings) List seperator
ie
= DateAdd("d"; -1, [Enter Date:]) AND < DateAdd("d"; 2, [Enter Date:])

Pieter

 

[Pieter Wijnen]

Use ';' instead of ',' in a Query, Form or Report (GUI)
The GUI uses the Windows (Regional settings) List seperator
ie
= DateAdd("d"; -1, [Enter Date:]) AND < DateAdd("d"; 2, [Enter Date:])

Pieter

Sorry about that, it was another question I got answered.

When I write the code you gave me I get an error message (Unfortunately in
italian but I do my best to translate)

"Errore di sintassi nell espressione" (Error in the syntax(syntax is a
professional guess) of the expression)

"Operando o operatore mancante, carattere o virgola non valida oppure
testo
immesso non racchiuso tra virgolette" (Operator or operation is missing,
character or comma is not valid otherwise ... etc)

I understand it is not easy for you but I would really appreciate your
help


I have done exactly as you described otherwise (I think...) I write my
date
as yyyy-mm-dd if that will help.

"John Vinson" skrev:

--

 

[Guest]

I have tried that but then it says

"Syntax error in the expression"

"It is not possible to make a operation without an operator" (or something
like that)

Possible to solve somehow?

/Andreas



"Pieter Wijnen" skrev:

Use ';' instead of ',' in a Query, Form or Report (GUI)
The GUI uses the Windows (Regional settings) List seperator
ie
= DateAdd("d"; -1, [Enter Date:]) AND < DateAdd("d"; 2, [Enter Date:])

Pieter

Sorry about that, it was another question I got answered.

When I write the code you gave me I get an error message (Unfortunately in
italian but I do my best to translate)

"Errore di sintassi nell espressione" (Error in the syntax(syntax is a
professional guess) of the expression)

"Operando o operatore mancante, carattere o virgola non valida oppure
testo
immesso non racchiuso tra virgolette" (Operator or operation is missing,
character or comma is not valid otherwise ... etc)

I understand it is not easy for you but I would really appreciate your
help


I have done exactly as you described otherwise (I think...) I write my
date
as yyyy-mm-dd if that will help.

"John Vinson" skrev:

--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4367 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len

 

[Pieter Wijnen]

missed the seccond ',' (to quick again)

= DateAdd("d"; -1; [Enter Date:]) AND < DateAdd("d"; 2; [Enter Date:])

sorry about that

Pieter

"Pieter Wijnen"

Use ';' instead of ',' in a Query, Form or Report (GUI)
The GUI uses the Windows (Regional settings) List seperator
ie
= DateAdd("d"; -1, [Enter Date:]) AND < DateAdd("d"; 2, [Enter Date:])

Pieter

Sorry about that, it was another question I got answered.

When I write the code you gave me I get an error message (Unfortunately
in
italian but I do my best to translate)

"Errore di sintassi nell espressione" (Error in the syntax(syntax is a
professional guess) of the expression)

"Operando o operatore mancante, carattere o virgola non valida oppure
testo
immesso non racchiuso tra virgolette" (Operator or operation is missing,
character or comma is not valid otherwise ... etc)

I understand it is not easy for you but I would really appreciate
your
help


I have done exactly as you described otherwise (I think...) I write my
date
as yyyy-mm-dd if that will help.

"John Vinson" skrev: