Search results

  1. N

    Updating Linked Table not Supported in this ISAM

    Hi Guys, I know you're all Access-Smart, so I figured this would be the best place to post this question. What I Did: *I created an Excel/CSV table and imported it as a linked table into Access. (This table has 6 fields which also occur in another larger table of 12 fields.) *I linked the...
  2. N

    Form Calculations not Entered into Table

    Hi Guys, I created a Form to enter data into a table. Two fields are numeric and typed into, a third field calculates the ratio instantly. I did that by entering "=field1/field2" into the control box in the properties panel for that form element. However, when I look at the table, all the data...
  3. N

    Which Function? (Return String based on Count Value)

    Hi, This is probably going to be pretty basic, but... I have a query that returns each record with three fields: A stable identifier (StableID) Text string with multiple varieties for each StableID (VariableText) A numeric count of how many times each VariableText is associated with each...
  4. N

    Need to Run Query 'For Each' Field Value

    I have a MODE query that I am trying to reference in another query. SELECT TOP 1 [Query1].[VariableText], [Query1].[StableID] FROM [Query1] GROUP BY [Query1].[VariableText], [Query1].[StableID] ORDER BY Count([Query1].[VariableText]) DESC; I have a query, Query1, which has two columns. A...
Top Bottom