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
Jump to Post
If 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
GROUP BY Table.Date, Table.car;
This will …
All 3 RepliesReply to this topic
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.