Search results

  1. D

    Assign Hyperlink

    Great, thanks so much!
  2. D

    Assign Hyperlink

    I'm using Office 2013. I was gifted a workbook with text that is supposed to be a hyperlink. I've changed the style to Hyperlink, with no luck. The only thing that seems to work is to enter each cell and insert and select the ENTER key to change the contents to a hyperlink. I have too many...
  3. D

    Converting Excel calendar duration to days

    Thanks Brianwarnock, this answered my question!
  4. D

    Converting Excel calendar duration to days

    In previous threads, it has been shared to use =DAYS360(C7,D7,FALSE) to convert calendar duration to days. Why does this formula use 360 days instead of 365 days?
  5. D

    Deleting Duplicate records from a query result

    Here is a file with the relationships.
  6. D

    Deleting Duplicate records from a query result

    In the attached pic, I want the query to remove the records in red and leave those highlighted in yellow. I can then run a count query to total the yellow records.
  7. D

    Deleting Duplicate records from a query result

    It's not working, but at least, there is a relationship now:banghead:
  8. D

    Deleting Duplicate records from a query result

    Thank you. I've added a relationship (Option 3) "Include ALL records from 'TBL_AgentInstallations_all' and only those records from 'Full' where the joined fields are equal."
  9. D

    Deleting Duplicate records from a query result

    This my sandbox copy. It has some in-progress objects that I will delete later.;) Thanks in advance! Dennis
  10. D

    Deleting Duplicate records from a query result

    I have a similar (but different) problem with duplicates. I have a query that compares two tables. The results I'm look for are comparison of activities with supervisors and their team members. I'm looking for activity from any one of a superviors team members. To do this, I want the query to...
  11. D

    Sub-reports or report grouping and bypass subreports.

    I'm a noob and trying to get as much report functionality as I can without using code. My desk reference, Access 2010, the Missing Manual, [Access 2010: The Missing Manual, Mathew MacDonald] notes that the subreport is a holdover from earlier versions of Access and that users should focus...
  12. D

    Having user choose a report and date range

    Carol, This sample database looks like my speed. I'm a R-E-A-L noob. I have a report that represents 8 queries that each require date (To and From) entries. Entering the date range multiple times invites error. A sample database would be the sort of instruction that would be great.
  13. D

    Another new Member

    I live in the United States, in Centeral Illinois. I have very little experience with Access, but my job responsibilities have changed! I'm a fairly quick study and I'm looking forward to another resources other than "Access 2010, the Missing Manual"!:)
Top Bottom