Display Results on Form

[trevor2524]

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

[ranman256]

make a sum query , say qsSumDAta
now connect this query to the form .
assign the text boxes to each field.
now the sum results will show in the text boxes.