Restuarant Survey

[Guest]

Hi,
I'm attempting to put the results of a restuarant survey ,multiple choice
questions : good excellent, poor, etc; plus date, name and postcode, into
access. I've been able to put all the info into a table want to be able to
get reports by date range, eg between 12/4 and 19/4. I have no idea.

Please help

 

[Arvin Meyer [MVP]]

In a query that will be the source for your report, add this to the criteria
of the date field:

Between #12/4/07# And #19/4/07#

 

[John W. Vinson]

In a query that will be the source for your report, add this to the criteria
of the date field:

Between #12/4/07# And #19/4/07#

Arvin, don't you need to use the American mm/dd/yy date format for literal
dates?

That should probably be either

Between #4/12/07# AND #4/19/07#

or

Between [Enter start date:] AND [Enter end date:]

John W. Vinson [MVP]

 

[Arvin Meyer [MVP]]

You are correct John. I was trying to be considerate of foreign date entry,
and gave incorrect information.

In fact all SQL must be entered in American date style: mm/dd/yy or some
combination like m/d/yyyy. Month must come first, then day, then year.

Intead of using Between/And, one can also use:

= #4/12/07# And <= #4/19/07#
or:

= [Enter start date:] And <= [Enter end date:]

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

In a query that will be the source for your report, add this to the
criteria
of the date field:

Between #12/4/07# And #19/4/07#

Arvin, don't you need to use the American mm/dd/yy date format for literal
dates?

That should probably be either

Between #4/12/07# AND #4/19/07#

or

Between [Enter start date:] AND [Enter end date:]

John W. Vinson [MVP]

 

[i_takeuti]

Hi,
I'm attempting to put the results of a restuarant survey ,multiple choice
questions : good excellent, poor, etc; plus date, name and postcode, into
access. I've been able to put all the info into a table want to be able to
get reports by date range, eg between 12/4 and 19/4. I have no idea.

Please help

 

[Guest]

You are correct John. I was trying to be considerate of foreign date entry,
and gave incorrect information.

In fact all SQL must be entered in American date style: mm/dd/yy or some
combination like m/d/yyyy. Month must come first, then day, then year.

Intead of using Between/And, one can also use:

= #4/12/07# And <= #4/19/07#
or:

= [Enter start date:] And <= [Enter end date:]

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

***********************************

Would this be necessary if the person went into Regional Settings and had
the date format set to English (New Zealand) or whatever the appropriate
country was? I am asking because I am working on a database that ultimately
will be used in the South Pacific. I wasn't thinking about this because I
thought it would all be handled through the system.

Hope you can clarify.

Thanks.

Mary

 

[Douglas J. Steele]

You are correct John. I was trying to be considerate of foreign date
entry,
and gave incorrect information.

In fact all SQL must be entered in American date style: mm/dd/yy or some
combination like m/d/yyyy. Month must come first, then day, then year.

Intead of using Between/And, one can also use:

= #4/12/07# And <= #4/19/07#
or:

= [Enter start date:] And <= [Enter end date:]

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

***********************************

Would this be necessary if the person went into Regional Settings and had
the date format set to English (New Zealand) or whatever the appropriate
country was? I am asking because I am working on a database that
ultimately
will be used in the South Pacific. I wasn't thinking about this because I
thought it would all be handled through the system.

Yes, it's necessary regardless of what the Regional Settings may be.

Take a look at Allen Browne's "International Dates in Access" at
http://allenbrowne.com/ser-36.html or what I had in my September 2003
"Access Answers" column for Pinnacle Publication's "Smart Access"
newsletter. (The column and accompanying database can be downloaded for free
at http://www.accessmvp.com/djsteele/SmartAccess.html)

 

[Guest]

Thank you. this was very helpful.

Mary Sweeney

You are correct John. I was trying to be considerate of foreign date
entry,
and gave incorrect information.

In fact all SQL must be entered in American date style: mm/dd/yy or some
combination like m/d/yyyy. Month must come first, then day, then year.

Intead of using Between/And, one can also use:

= #4/12/07# And <= #4/19/07#

or:

= [Enter start date:] And <= [Enter end date:]
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

***********************************

Would this be necessary if the person went into Regional Settings and had
the date format set to English (New Zealand) or whatever the appropriate
country was? I am asking because I am working on a database that
ultimately
will be used in the South Pacific. I wasn't thinking about this because I
thought it would all be handled through the system.

Yes, it's necessary regardless of what the Regional Settings may be.

Take a look at Allen Browne's "International Dates in Access" at
http://allenbrowne.com/ser-36.html or what I had in my September 2003
"Access Answers" column for Pinnacle Publication's "Smart Access"
newsletter. (The column and accompanying database can be downloaded for free
at http://www.accessmvp.com/djsteele/SmartAccess.html)