User Profile

Collapse

Profile Sidebar

Collapse
Tom Murphy
Tom Murphy
Last Activity: Mar 26 '14, 06:57 PM
Joined: Jan 28 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Tom Murphy
    replied to Count some data in same field in ms access
    in Access
    1.Create a select query and include the table containing "Age.
    2.Drag Age to the field row in first col.
    3.Drag another field (key field) to the field row in the second column.
    4.From the ribbon in the Show/Hide section click on Totals to show the Total row in the query grid.
    5.In the dropdown in the first column total row select Group By.
    6.In the dropdown in the second column total row select Count.
    Run...
    See more | Go to post

      Leave a comment:

    • Tom Murphy
      replied to Query for Combo box for subtype in MS access form
      in Access
      This is called cascading combo boxes. You can filter the source for the second combo box in the on enter event procedure using vba or a macro. In VBA the current value of the status field is me.statusfieldn ame. In a quary the criteria for ID would look something like Forms!myform!st atusfieldname.
      See more | Go to post

        Leave a comment:

      • Tom Murphy
        replied to Combining several tables within MS Access 2007
        in Access
        What is the complete field structure for each table? I don't see mention of a TechID in the Technology table.
        See more | Go to post

          Leave a comment:

        • Tom Murphy
          replied to MS ACCESS Relationship and Duplicate
          in Access
          You will not get duplicates if you make the key in the second table consist of the ID and the date. Then when you enter the data in the second table, it will not allow you to enter a second record with the same ID and date.

          If you are just trying to find duplicates in the second table, do a Find Duplicates query.
          See more | Go to post

            Leave a comment:

          • Tom Murphy
            started a topic How to pass a variable to a query?
            in ASP .NET

            How to pass a variable to a query?

            I want to enter a url of the form "http://www...../index.htm?MC001 " and pass the "MC001" to a query string. The query string I have now is:
            Code:
             qry = "SELECT QRID, QRContent FROM " & tablename & WHERE QRID= '" & request.querystring() & "'"
            Why does this not work?
            See more | Go to post
            No activity results to display
            Show More
            Working...