Search results

  1. I

    Export to Excel (xlsx)

    I am having a very frustrating time working with exports to Excel since my company upgraded from Office 2003 to Office 2010. My current issue is as follows: I have an Excel workbook with two worksheets. One of the worksheets contains conditional formatting. I import the other worksheet into...
  2. I

    Field Header in Query based on Other Field Data

    I'm not exactly sure how to ask this, but here goes. I have two tables that are joined - called A and B. A has two fields, "PLACE" and "RAND" and is joined to B via field "RAND". Other than "RAND", B has several fields named 01 TOTAL, 02 TOTAL, 03 TOTAL, etc...for about 60 fields. The "PLACE"...
  3. I

    Math with Variables

    I am attempting to piece together my first true VBA project, but I have hit a snag. I have entered the following code into the immediate window: dim sCnt as Integer dim wCnt as Integer dim suDif as Integer sCnt = DLookup("[Number_of_Su]", "Su_Profile", "[Su_Num] = 9") wtCnt =...
  4. I

    Week Number by Month

    I'm needing to write an expression that calculates the week number for any date for the month it's in, given that all weeks begin on Monday and all months begin on the first Monday of the month. In other words, the 5th week of October, 2011 would begin on 10/31/11 and end on 11/06/11. The...
  5. I

    Query / Append for Top N

    Good Morning, I need to select the top 8 records from a large table using varying criteria. First, I would take all of the items that are, say "Red". If that didn't return 8 records, I would need to run an append query adding the difference from the other colors. How would i go about putting...
  6. I

    Charting Question

    I don't know where to start, but the final product I'm looking for will be a stacked chart, so I'm asking here. I have an excel file that holds event data. I want to be able to see an entire season's days (as one axis), and how many events are being held on each day (as the other axis) by type...
  7. I

    Add field to flag duplicates in another field

    Good Afternoon! I am looking for a statement that I can add to a query in design view that will create a new field that returns a "True" or "False" if the data in "Field C" is duplicate for all records in which "Field B" has a certain value. In Excel, I would simply use a COUNTIF formula, but...
Back
Top Bottom