Search results

  1. A

    ComboBox for paramater of Make Table Query

    I have created a combo box, named "Combo3", based on "FieldX" from "Table1". I am trying to have it be the parameter for a Make Table Query. The Make Table query is outputting only the same "FieldX" from "Table1". Under the Criteria in the query for FieldX I typed: [Forms]![FormName]![Combo3]...
  2. A

    Label Dependant upon Graph having data

    I created a number of graphs on forms that graph GamesSold vs RDate. If a game has no sales, there won't be any data. Is there a way I can add a label that will automatically display "Game is not yet released" and make it dependant upon the graph having data, and invisible if it does? I...
  3. A

    Graphs in Detail Section of Report

    I have a query with four fields: VideoGame, Date, GamesSold, MCScore. I want to graph the games sold and metacritic score for each game vs the date. The easiest way I could think to do this would be in the detail section of a report so that it would automatically duplicate the graph for each...
  4. A

    Change Layout of Data

    I have been given a large set of records that is layed out with 10 ID fields, then 31 (Day 1, Day 2, etc.) fields representing each day of a given month. These fields contain data. I created two fields labeling the month and year as well. My goal is to create a date field where I can put...
  5. A

    Export Reports to PowerPoint

    I am creating a large number of reports, each containing 4 graphs apiece that is to be compiled into a powerpoint presentation. The only way I can get them into powerpoint at the moment is to convert each graph to an image then paste individually. I actually prefer the graphs in PP to be...
  6. A

    Query with Daily Fields based on Parameters

    Hello, I am trying to create a query that will provide a field for each day of a month. However, I want the query to be able to work for any month that I want to run on based on a parameter. Basically I want this: Day 1: Sum(IIF([ReleaseDate]=#[# of Month]/1/[# of Year]#,[GamesSold],0) Day...
  7. A

    Eliminate Ties in Most Common Value Query

    My current SQL for my most common value looks like this: SELECT TOP X TableName.FieldName, Count(*) AS CallCount FROM TableName GROUP BY TableName.FieldName ORDER BY Count(*) DESC; I am using the query in a subreport that automatically populates on a report. The problem is that there is often...
Back
Top Bottom