field names

  1. MacroAlan

    Build query from Defs

    I think I've seen what I'm looking for but cannot find it again! I have this huge Crosstab query that shows columns for each month from Year minus 1 through Year plus 2; i.e. 01/01/2017 thru 12/1/2020. I want to gather all the field names into a new query that writes to a new table. I...
  2. K

    The text is too long to be edited.

    Hello, I'm creating a table in access but I keep getting a message says " The text is too long to be edited". Please help me resolve this issue.. Thank you in advance for your help.
  3. M

    Index Match / lookup formula using column names

    Is there a way I can modify this Index Match formula, or use a different formula, so that I can reference by column/field names instead of clicking on specific column references?: =INDEX(source!E:E,MATCH(A2,source!D:D,0)) Instead of source!E:E I'd like to find "DESCRIPTION" in row1 of the...
  4. M

    Excel Field Data pipe delimited with many fields inside

    I have a lot of field data in a row that's in format: Color: Red|Title: Red Shirt|Date: 2015|Medium: cotton|Size: M| Title: Blue Dress|Date: 2014|Price: 55|Size: M| Color:Green| Type: New| Size: G| Title: Green Shirt| Here, in my data, there are many rows with new fields. There are many...
  5. F

    4 Part Extract - Fields are not in the same order

    I am getting a 4 part extract from an enterprise tool which come out in XML, that was irritating but I can work around that, but whats weird is that when I import the data into excel the fields are moving around (see screen shot). No one can seem to either explain to me why this is happening or...
  6. J

    Dynamically Changing Field Names

    I have a query that calculates Current Month and YTD Totals. I would like to have the field names change every month. For Example. I would like the field names to say March 2013 and March YTD 2013 for when I run the data this month and April 2013 and April YTD 2013 when I run next month. Can...
  7. Gingertrees

    VBA: List field names where criteria not met?

    Related to, but sufficiently different from: http://www.mrexcel.com/forum/microsoft-access/657817-feebly-trying-evaluate-several-fields-visual-basic-applications-2.html Classifying business customers: we have programs where each business aims for a Type (Good, Better, Best), and we measure what...
  8. W

    How to use one field to choose another field

    This seems so simple yet I can't get anything to work. I want the value of one field to determine from which column to get a bit of data. I have a table with column names 1, 2, and 3. I have a field called type that contains values 1, 2 and 3. If Type has the value one in it, I want a field...
  9. U

    Finding Field Names of Web Pages

    I am attempting to automate the process of downloading current 401k and IRA data from various websites, however, without knowing the names of the fields I need to populate or the buttons I need to "click", I cannot automate it. What methods are there for determining the field names of webpages?

Some videos you may like

This Week's Hot Topics

Top