473,320 Members | 1,884 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 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 2084
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Gord | last post by:
Hello, VB6 accepts Date and Time values as 'Date'. I'm trying to verify entry into a database I'm creating by verifying that an appropriate Date or Time value has been entered. Using built-in...
4
by: Joe User | last post by:
Hi all....I have a feeling this is going to be one of those twisted query questions, but here it goes anyways.... I want to generate a report that shows the chronology of events (represented by...
4
by: Tony | last post by:
Hey guys, I use Google Groups quite a bit as it is an enormous wealth of information, and now I need some help. I have created a query using parameters to capture a range of date, the date is...
1
by: rock72 | last post by:
I am developing a application using this fields as required by the company. 1. Date Login 2. Time IN 3. Time OUT My question is how to produce the number of days with 1 entry of Date is...
9
by: MLH | last post by:
I have a database (datatrek.mdb) with a table named DATA. The table has a date/time field with default value = Now(). It has 100 records in it entered over a 50-minute period. I would like the...
1
by: Gee | last post by:
Hi Folks, I have a small database that contains test dates. We can only sit 9 people per test. I need to count the dates that are the same and NOT go over 9. I read MSAcess help on the DCount...
2
by: x | last post by:
hi i am a pilot by profession. i want to create a database of my logbook using ms access 2002. i am facing a problem regarding the format of time field. when i select "Data/Time" data type for my...
4
by: Simon Gare | last post by:
Hi all, I am trying to retrieve a count of booking entries made 30 days ago, below is the end of the query I am having problems with. dbo.booking_form.TimeOfBooking = DATEADD(day, -30,...
4
by: SilentThunderer | last post by:
Hey folks, Let me start out by letting you know what I'm working with. I'm building an application in VB 2005 that is basically a userform that employees can use to "Clock in". The form...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.