newbie's question

[Douglas J. Steele]

You may have some problems if you're using dd/mm/yyyy format: Access doesn't
always work well with that format.

Try using the following criteria with the date field:

BETWEEN CDate([DateFrom]) AND CDate([DateTo])

When you run the query, a prompt will appear for DateFrom. Once the user
enters that, another prompt will appear for DateTo.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

I am using access 97.
I have a table with 5 fields(1 date fields). I want to create a

query/report dynamically depending upon the users requirement.

1) i want to know how i can get input from the user
2) how to generate the query out of it
i.e. if the user keys in 10/12/2003 and 15/12/2003, than i want to list

only those records who's date field is in between these range.

Thanks in advance.

[hcj]

raj
You posted this same question at least twice today in
different places. It's a little frustrating to spend time
helping you out in one place and then discover that you've
already got a good answer on the same question someplace
else. If you're going to do that (not advised) then at
least say in your subject line that the question is a
multiple post.
People will help, but please don't spread them too thin.

hcj

-----Original Message-----
I am using access 97.
I have a table with 5 fields(1 date fields). I want to

create a query/report dynamically depending upon the users
requirement.

1) i want to know how i can get input from the user
2) how to generate the query out of it
i.e. if the user keys in 10/12/2003 and 15/12/2003, than

i want to list only those records who's date field is in
between these range.

Thanks in advance.
.

[b***@gmail.com]

When I log on to my gmail account by hitting GMail from Google home page, I go right to my email without having to sign in. This happens by default. I would like to sign in each time to maximize security. How do I make signing in my default option?


Ben Bradlee Jr.

Post by Douglas J. Steele
You may have some problems if you're using dd/mm/yyyy format: Access doesn't
always work well with that format.
BETWEEN CDate([DateFrom]) AND CDate([DateTo])
When you run the query, a prompt will appear for DateFrom. Once the user
enters that, another prompt will appear for DateTo.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

I am using access 97.
I have a table with 5 fields(1 date fields). I want to create a

query/report dynamically depending upon the users requirement.

1) i want to know how i can get input from the user
2) how to generate the query out of it
i.e. if the user keys in 10/12/2003 and 15/12/2003, than i want to list

only those records who's date field is in between these range.

Thanks in advance.

[Access Developer]

This newsgroup is for Questions and Answers about, and discussions of,
Microsoft Access database software; it is not about "getting started with
accessing the Internet". If you can, and you probably can, find a newsgroup
that is about gmail, you will have a better chance of getting the answer you
need -- if not, then you should be able to find a path to useful Help either
on gmail.com or google.com.

I use gmail to some extent, but don't think I've ever done so from Google's
home page. I do, on occasion, switch from Yahoo to Yahoo Mail, and if I
recall correctly, I do not have to log in again, nor do I remember an option
to require logging in separately -- good luck in finding the answer you
need.
--
Larry

Post by b***@gmail.com
When I log on to my gmail account by hitting GMail from Google home page,
I go right to my email without having to sign in. This happens by default.
I would like to sign in each time to maximize security. How do I make
signing in my default option?
Ben Bradlee Jr.

Post by Douglas J. Steele
You may have some problems if you're using dd/mm/yyyy format: Access doesn't
always work well with that format.
BETWEEN CDate([DateFrom]) AND CDate([DateTo])
When you run the query, a prompt will appear for DateFrom. Once the user
enters that, another prompt will appear for DateTo.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

I am using access 97.
I have a table with 5 fields(1 date fields). I want to create a

query/report dynamically depending upon the users requirement.

1) i want to know how i can get input from the user
2) how to generate the query out of it
i.e. if the user keys in 10/12/2003 and 15/12/2003, than i want to list

only those records who's date field is in between these range.

Thanks in advance.