Search results for query: *

Ginger, It is also telling me that "You can't calculate totals on the asterick" Because the asterick represents all the fields in a table, you can't calculate totals on it. Remove the asterick from the query design grid. Add the fields you want to use to the design grid, and then select the...

Thank You Ginger for the prompt reply, and the Grouping:coding works fine now I dont have to have two seperate columns to produced the desired results. But I am not clear on when you say bring down "VARIANCE DATE" into the grid and, from the menu pick View+Totals change the GroupBy under...

I would like to calculate the total number of records either identified as >10 or >15. This is the coding I have thus far for >10 Expr3:IIf([VARIANCE DATE] Between 10 And 14,">=10") >15 Expr4: IIf([VARIANCE DATE]>=15,">=15") My expressions Identify accurately what columns are greater than...

What I am putting in the criteria section for the user id column is "UCase([Enter User Name:])", I also place in the criteria section for the date column "Between [Enter begin Entry Date as MM/DD/YYYY:] And [Enter end Entry Date as MM/DD/YYYY:]". Upon doing the following I successfully...

I have a report that I am trying to complete. It display the desired results if I leave the criteria field blank, but when I try to run the report with something in the criteria field it displays no data, the only way I can get it to work using criteria is if I place a parameter in the fields...