Hello,

I'm new to the access world and I'm working on a task right now. I figured out most of of where I have the form calling the query based on user input into four search fields. The part I'm having trouble on is the following:

I have four Textbox fields on the forum after the search lets call them text1,text2,text3 and text 4. From the query the textboxes need to display the following information:

text1 needs to display the total amount of rows in the query after the search from column 1

text2 needs to display the sum of column 2

text3 needs to display the sum of column 3

text4 needs to display the last cell in column 4.

I've tried using Dcount and other functions but I can't get it to work. I'm trying to make this all happen when I click a button after the query search is done. Any suggestions it would be greatly appreciated because I'm really stuck.

Thanks,
Trevor