Search results

Hi, I need your assistance. I have built a form to use to edit one data field in my tables. If the data has been changed, before moving to the next record or closing the form, the user gets a Yes/No message box asking them to confirm whether they like to make the change. If Yes is chosen...

I have a table that stores different visits to clients and the key fields in this table are the ClientName and VisitDate. I am trying to design a query that extracts from the above table only the latest visit to each client where there is more than one visit found and if there is only one in...

I am building a series of reports based on different filter settings of the same query. Rather than save several versions of the query and base each report on its query, I thought I could have a single instance of the query, but then run each report based on VB code that includes the required...

I have designed a report to assess the risk of a project based on defined project elements. The project elements are set up as fields in a table and projects as records. After each project element is assessed, a score (from 1 to 5) is awarded and at the end of the day all the project element...