Search results

  1. E

    Query two tables and return all data from both tables

    I have 2 tables (created by queries to linked tables) with the following fields: (1) Project, Project Name, Dept, Actual Hours, Forecast Hours, Period Ending (2) Project, Project Name, Dept, Original Budget Hours, Total CN Hours, Total Approved Hours Trying to generate a query which...
  2. E

    Need report to look like Cross tab query, but with subtotals

    Is there any way I can subtotal Columns A then Column B in the cross tab query and export to Excel instead of exporting the query to Excel and inserting the subtotals everytime. Thanks
  3. E

    Query returns duplicated values for some cells

    I'm trying to execute a query which is looking at data from 2 different tables and most of the data fields in the tables are the same. For instance table 1 has Dept, Res, Period_date, & Available Hrs and table 2 has Dept, Res, Period_date, Project & Forecast Hrs. The results I'm looking for are...
  4. E

    I can't get this to work IIf function work for me

    I have an expression in one column of my query and It keeps returning a negative result and there are no negative numbers in the source data. Can anyone help. I just want to sum the sums the two IIf expressions, but its not working. Thanks Other Qty: Sum(IIf([QSum]![ACCOUNT]=2 And...
Back
Top Bottom