i m develop a system related car in/out records. I got data fields like date, time in, time out, car numbers......
My problem is How to count the repeat records base on repeat car numbers on a certain date?( my purpose is count how many times a car in/out on a certain date) :?: :?:
i hope anyone here can understand my problems and pls help me
maylim26
0
Newbie Poster
Recommended Answers
Jump to PostIf I understand your problem correctly you want to know how many times a certain car was in/out on a certain date. Is that correct?
If so, you can issue the following query:
SELECT Table.Date, Table.car, Count(Table.car) AS CountOfcar
FROM Table
GROUP BY Table.Date, Table.car;This will …
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.