Display Qtrly data in form text box Formula in text box

[Guest]

Here is my dilemma...I have a table with 4 Qtrs of data...so, for each Widget
there are four data points. I have a form that shows the widget and the $
associated with it...however it is in total (all 4 Qtrs) what I want to show
is 4 text boxes of the same widget but for each qtr. Is there any code I can
put in to each text box to show each qtr? Any ideas? Thanks in advance I
don't want to create a query I want to just pull off of the table....because
I have a data entry point in the form that goes into table..

 

[Guest]

You can build a select statement the same as a query SQL statement to use in
the record source for the text box. Include the criteria for the quarter.
Place an equal sign ( = ) in front of the SQL statement.

 

[Guest]

Thanks!....I hate to ask...but I have tried creating it....could you send me
a sample of what one might look like...so I can build off of that? Thanks
much!

 

[Guest]

I did make a select statement associated with a combo box to copy into the
text box..however, there is no "record source" line for the text box...only
"control source" is there where I need to put a statement? Also, no luck on
my attempt to create this select statement...any help would be
appreciated...Thanks again.

 

[Guest]

Post the SQL for your query and I then can build off of that.