471,073 Members | 1,482 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

DAte/Time Entry Query

I am working on a database in ACCESS 2003. Six of the fields provide
for entry of service dates 1 to 6 progressively recording when the
client was serviced. The data type is Date/Time. I need to design a
query that will show the records for clients that have been served six
times, that is one through six dates have been entered. I don't care
what the actual data of the service just that the service has been
performed. Any help will be appreciated.

Stan Hanna

May 1 '07 #1
5 1977
Is it possible to change the set up of the database? You should have a
separate table for service dates, that way you can have unlimited service
dates per customer and you could easily do a count on the number of service
dates in a query

"Stan" <st*******@hotmail.comwrote in message
news:11**********************@h2g2000hsg.googlegro ups.com...
>I am working on a database in ACCESS 2003. Six of the fields provide
for entry of service dates 1 to 6 progressively recording when the
client was serviced. The data type is Date/Time. I need to design a
query that will show the records for clients that have been served six
times, that is one through six dates have been entered. I don't care
what the actual data of the service just that the service has been
performed. Any help will be appreciated.

Stan Hanna

May 1 '07 #2
to see if customers have been serviced six times in your current set up,
just run a query to see if there is any data in the sixth field.

"Scott" <sc**********@ns.sympatico.cawrote in message
news:Yv***************@ursa-nb00s0.nbnet.nb.ca...
Is it possible to change the set up of the database? You should have a
separate table for service dates, that way you can have unlimited service
dates per customer and you could easily do a count on the number of
service dates in a query

"Stan" <st*******@hotmail.comwrote in message
news:11**********************@h2g2000hsg.googlegro ups.com...
>>I am working on a database in ACCESS 2003. Six of the fields provide
for entry of service dates 1 to 6 progressively recording when the
client was serviced. The data type is Date/Time. I need to design a
query that will show the records for clients that have been served six
times, that is one through six dates have been entered. I don't care
what the actual data of the service just that the service has been
performed. Any help will be appreciated.

Stan Hanna


May 1 '07 #3
On Apr 30, 8:08 pm, "Scott" <scott.n.j...@ns.sympatico.cawrote:
to see if customers have been serviced six times in your current set up,
just run a query to see if there is any data in the sixth field.

"Scott" <scott.n.j...@ns.sympatico.cawrote in message

news:Yv***************@ursa-nb00s0.nbnet.nb.ca...
Is it possible to change the set up of the database? You should have a
separate table for service dates, that way you can have unlimited service
dates per customer and you could easily do a count on the number of
service dates in a query
"Stan" <stanha...@hotmail.comwrote in message
news:11**********************@h2g2000hsg.googlegro ups.com...
>I am working on a database in ACCESS 2003. Six of the fields provide
for entry of service dates 1 to 6 progressively recording when the
client was serviced. The data type is Date/Time. I need to design a
query that will show the records for clients that have been served six
times, that is one through six dates have been entered. I don't care
what the actual data of the service just that the service has been
performed. Any help will be appreciated.
Stan Hanna
I inherited this db and hesitate to try to change it. In the future
when I have a chance to redo it there will be lots of changes. Scott
has the right Idea but I don't know what to use as the criteria in the
query to bring back the records will entries in the last date field.
Scott, can you give me a little more direction ?

May 1 '07 #4
in the criteria section of the query for the sixth field type "is not null"

"Stan" <st*******@hotmail.comwrote in message
news:11**********************@n59g2000hsh.googlegr oups.com...
On Apr 30, 8:08 pm, "Scott" <scott.n.j...@ns.sympatico.cawrote:
>to see if customers have been serviced six times in your current set up,
just run a query to see if there is any data in the sixth field.

"Scott" <scott.n.j...@ns.sympatico.cawrote in message

news:Yv***************@ursa-nb00s0.nbnet.nb.ca...
Is it possible to change the set up of the database? You should have a
separate table for service dates, that way you can have unlimited
service
dates per customer and you could easily do a count on the number of
service dates in a query
"Stan" <stanha...@hotmail.comwrote in message
news:11**********************@h2g2000hsg.googlegr oups.com...
I am working on a database in ACCESS 2003. Six of the fields provide
for entry of service dates 1 to 6 progressively recording when the
client was serviced. The data type is Date/Time. I need to design a
query that will show the records for clients that have been served six
times, that is one through six dates have been entered. I don't care
what the actual data of the service just that the service has been
performed. Any help will be appreciated.
>Stan Hanna

I inherited this db and hesitate to try to change it. In the future
when I have a chance to redo it there will be lots of changes. Scott
has the right Idea but I don't know what to use as the criteria in the
query to bring back the records will entries in the last date field.
Scott, can you give me a little more direction ?

May 1 '07 #5
On Apr 30, 8:45 pm, "Scott" <scott.n.j...@ns.sympatico.cawrote:
in the criteria section of the query for the sixth field type "is not null"

"Stan" <stanha...@hotmail.comwrote in message

news:11**********************@n59g2000hsh.googlegr oups.com...
On Apr 30, 8:08 pm, "Scott" <scott.n.j...@ns.sympatico.cawrote:
to see if customers have been serviced six times in your current set up,
just run a query to see if there is any data in the sixth field.
"Scott" <scott.n.j...@ns.sympatico.cawrote in message
>news:Yv***************@ursa-nb00s0.nbnet.nb.ca...
Is it possible to change the set up of the database? You should have a
separate table for service dates, that way you can have unlimited
service
dates per customer and you could easily do a count on the number of
service dates in a query
"Stan" <stanha...@hotmail.comwrote in message
news:11**********************@h2g2000hsg.googlegro ups.com...
I am working on a database in ACCESS 2003. Six of the fields provide
for entry of service dates 1 to 6 progressively recording when the
client was serviced. The data type is Date/Time. I need to design a
query that will show the records for clients that have been served six
times, that is one through six dates have been entered. I don't care
what the actual data of the service just that the service has been
performed. Any help will be appreciated.
Stan Hanna
I inherited this db and hesitate to try to change it. In the future
when I have a chance to redo it there will be lots of changes. Scott
has the right Idea but I don't know what to use as the criteria in the
query to bring back the records will entries in the last date field.
Scott, can you give me a little more direction ?
Thanks for the help and direction. Query works great.

Stan Hanna

May 1 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Gord | last post: by
4 posts views Thread by Tony | last post: by
4 posts views Thread by Simon Gare | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.