Search results

  1. A

    Update Query for multiple scanarios

    Hi I have a form (helped by you guys) which has the fields Risk Probability(RP) and Risk Impact (RI)(both are from TblRisks ) - My next field is Risk Evaluation (RE) I have an update query which updates RE depending the results of both RP & RI Eg If "likely" is selected from RP and "Moderate" is...
  2. A

    Autofill a field based on the selection of 2 other fields

    Hi -Is this possible please? I have a form FrmRisklevel It has fields Risk Probability and Risk Impact (both are from TblRisks and the fields are look ups from other tables) - My next field is Risk Evaluation My preference is Risk Evaluation will autopopulate based on the selection of the...
  3. A

    Query to extract selected yes fields from table

    I have a "Risk Assessment" table with Contractor information and then a few yes/no fields. One or multiple fields could be = yes which would change with each risk assessment I would like a report to show the Contractor Info fields and then only the fields = yes and omit fields = no. Presuming...
  4. A

    Union Query with parameter for results by month

    Hi Again How would I go about adding a date parameter to my union query? My required end result is a report that would prompt me for the month ie "June"
  5. A

    Query to show review dates from multi tables

    H I have the following tables:- Employees, Supervisors, Line Managers, Dept Managers. The tables store Appraisal information amongst other things. I want a query to extract Appraisal review dates from all the tables so I can then print it in a report to easily see who is due a review. I have...
  6. A

    Open report from form with combo selection

    Hi again. I have a form with a combobox where I choose an employee and it autofills the form with the Employees name and details. I wanted to have a command button on the form which will take me to a report showing only the employee details selected from the combobox on the form. Hope that makes...
  7. A

    Help with count

    Hi I have a table that records Employees (Name)and their Accidents . I would like a report which shows each employees name, the accident details and then the total amount of accident for each person. Its the count feature that I am struggling with as a newbie
  8. A

    Navigating between page tabs

    Hi I have a form with 8 page tabs. I want to have a button on each page that will take me to a specific tab. eg Page tab 1 will have a button that when clicked, will take me to page 2 and then the same on page 2(a button that will take me to page 3) and so on. is this possible? I have no...
  9. A

    Forms and subforms

    Hi after solving the issues with my database(thanks to you guys) I have now come across another. My database is a vehicle management db. I want to store customer, vehicle and invoicing data. I have 3 tables, Customers, Vehicles and Invoicing. The invoicing calculations are in the query. I have a...
  10. A

    Query returning Duplicates

    Hello I am very new to access and this is my first database. My database is vehicle management for a mechanic who wants to be able to store all his vehicle data, customer records and raise invoices and keep that invoice data for future reference I have 3 main tables. Customers, Vehicles and...
  11. A

    Hello Everyone

    My name is Archie and I live in Scotland. I am very new to access and becoming addicted already
Top Bottom