Recent content by erict

Got it to work. Created second query utilizing Union query results - with function Sum(Val([fieldname])). Thank you

Thank you - got it to work. Another problem crept up on me. The data pulled from the (2) different tables within the union query are on different rows even though the first three fields are the same. Is there a function to get data on same row. Thank you again for your time.

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...

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

Attaching d-base I've attached the d-base if you have time to look at it. Thank you

Thank you for your patience. I meant for the data look like that but the last row of data has the x's under the Available Hrs column instead of the Forecast Hrs column. And in the query I'm executing, the Available Hrs data is repeated in the four preceeding columns. Kind of like each time...

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...

Thank you for the help. Have a good week.

It works. Thanks for the tip. Can I ask how to add another series of IIf statements. Below is the revised original statement (1), & directly underneath the revised original, is another (2) of the many statements I need to add to get the results. Thank you for the advice. (1) Other Qty...

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...