Recent content by Jeromenew

Input forms designed with date range and user selections. I tried many combinations of query, but I am unable to get the proper results. perhaps I developed some other detailed report, but I need the summary report as mensioned.

Dear all We have an existing database, supplied by the "door access" software vender. It also has two fingerprint scanners [one indoor and one outdoor] One of the tables in the database has user ID date with time IN or OUT flag Now, we need to prepare a report 1. Weekly summary report –...