Search results

I hope this helps: If the detail section has that field as Field1 then in the group footer use "=Sum([field1]) You can repeat this for other footers as well - if grouping is done for more than one item. Each footer will contain the sum for items above it. You can use this for expressions as...

Hi, Yes you can use formula expression in the report. Try =[EPD Records Query].[Cal Value]*[EPD Records Query].[Position 6] Or =([EPD Records Query].[Cal Value])*([EPD Records Query].[Position 6]) Or even this if the whole report is looking up from one query =([Cal Value]*[Position 6])

Hello, I need help with Access reports. Here is my senario: I am using crosstab query which means that the number of columns in the end query result varies depending on the data. My report looks up field values from this query. What I want to do: I want the field in my report to look if the...

Hey...I got it working. Thanks for reading. I actually had upto three clients added in the same relationship and I needed this query for that. Thanks though:D

Hi all.... I have been beating my head for 2 days on this. Any help will be GREAT! I have 2 tables: CLIENTS and RELATION NAMES has the client_ID, first_name and last_name along with other information for clients. RELATION is how the clients fit with each other. RELATION has relation_ID...