Recent content by MDKay

  1. M

    Solved Calculated Last Action Date

    Thank you all for your advise and guidance, it has all helped so much.
  2. M

    Solved Calculated feild using values from multipe tables

    It appears to have been resolved by amending the Name Autocorrect settings on current database. Thank you all again for the support
  3. M

    Solved Calculated Last Action Date

    @The_Doc_Man that is correct, there is no standard order to the process. As an example, while the building is in progress at a customers house, a neighbour may ask to have the installer to take a look at theirs, the installer will then perform the survey and provide us with the details to...
  4. M

    Solved Calculated feild using values from multipe tables

    Not sure if this should be a new thread or nut but i am having an issue with the same fields and cant find a solution. These on my main table are set a basic Text, Number and Currency fields to match those in the reference tables. On my forms i have them set up as Cascading Combo Boxes with...
  5. M

    Solved Calculated Last Action Date

    Many thanks for the support, however i may have confused things with the names i have used, these are not the actual field names. Below is what i am actually using: Quote Raised - [Y/N Checkbox] Date Quote Raised - [Date] Followed Up - [Y/N Checkbox] Date Followed Up - {Date] Survey Completed...
  6. M

    Solved Calculated Last Action Date

    I already have an alternative way of achieving this, however it is long winded and possible over complicated. What i am looking to achieve is having a calculated date field that will show my Last Action date. What i have: Action One - Y/N Action One - Date Action Two - Y/N Action Two- Date...
  7. M

    Solved Calculated feild using values from multipe tables

    Thanks for the help both, i have gone with a cascading query within the form. @namliam the table with 4 columns is only a reference table, there will be no data added or removed from this table. I did not see the need for a PK here. I have a PK on my master table that utilizes this table. The...
  8. M

    Solved Calculated feild using values from multipe tables

    Good afternoon all, I have two tables, the first is 4 colums: Type Width Projection Cost This is effectively a row for every possible type, width and projection combination and how much it would cost. My second table is for the entire order with costs, customer details and all calculations...
Top Bottom