User Profile

Collapse

Profile Sidebar

Collapse
Zontar
Zontar
Last Activity: Sep 12 '06, 12:24 AM
Joined: Sep 8 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Zontar
    replied to Convert Field Value String to Actual Field in Expression
    in Access
    mmccarthy,

    Thanks for your help.. I am excited about the possibility of doing Dynamic Querying in MS Access, but I don't really know where to go from here. I tried some of the stuff you mentioned, but wasn't able to pass a SELECT statement into the query so it would Execute the SELECT statement, and not just display the SELECT statement.

    I'm assuming this has to be done in VB code, which I'm not opposed to, I just...
    See more | Go to post

      Leave a comment:

    • Zontar
      replied to Convert Field Value String to Actual Field in Expression
      in Access
      Sorry this is so hard to explain. Perhaps I should give a more complete explanation instead of trying to simplify it.

      Basically, I would like to design a query that will Group By multiple fields depending on what fields a user selects in a Combo Box.

      Since I would like two levels of grouping, it just isn't feasible to have hundreds of queries for every possible combination of groupings.


      My FieldTable...
      See more | Go to post

        Leave a comment:

      • Zontar
        replied to Convert Field Value String to Actual Field in Expression
        in Access
        mmccarthy,

        I am using a form, but my question is only regarding a query and a table.

        The string "[TransactionTabl e].[Name]" is what I typed as the value in the first row of my FieldTable Table.

        I hope to then use that value in the FieldTable in my query of the TransactionTabl e.

        Basically, I want to Group By whatever field name happens to be in the FieldTable, if that makes...
        See more | Go to post

          Leave a comment:

        • Zontar
          replied to Convert Field Value String to Actual Field in Expression
          in Access
          Thanks, that Interesting, I didn't know about DLookup. I tried it, but I am still getting the "Value" of the field and not the actual field.

          When I tried this, all my rows still said

          [TransactionTabl e].[Name]
          [TransactionTabl e].[Name]
          [TransactionTabl e].[Name]
          [TransactionTabl e].[Name]
          [TransactionTabl e].[Name]

          When I wanted them to say:

          Bob Parker...
          See more | Go to post

            Leave a comment:

          • Zontar
            started a topic Convert Field Value String to Actual Field in Expression
            in Access

            Convert Field Value String to Actual Field in Expression

            I'm trying to improve performance on a query, and I was wondering if this is possible in Access.

            Let's say I have a table [fieldtable] with one text column [field1] and one row.

            In that column, I have a field name from another table [TransactionTabl e]. This fieldtable gets updated from a form, but it never has more than one row in it.

            So an example value in my [fieldtable] look like this:

            ...
            See more | Go to post
            No activity results to display
            Show More
            Working...