Display Qtrly data in form text box Formula in text box

Display Qtrly data in form text box Formula in text box

Post by ZGVlZH » Fri, 23 Mar 2007 01:17:03


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..
 
 
 

Display Qtrly data in form text box Formula in text box

Post by S0FSTCBERV » Fri, 23 Mar 2007 02:51:41

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.
--
KARL DEWEY
Build a little - Test a little

 
 
 

Display Qtrly data in form text box Formula in text box

Post by ZGVlZH » Fri, 23 Mar 2007 03:30:08

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!
 
 
 

Display Qtrly data in form text box Formula in text box

Post by ZGVlZH » Fri, 23 Mar 2007 03:45:25

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.
 
 
 

Display Qtrly data in form text box Formula in text box

Post by S0FSTCBERV » Fri, 23 Mar 2007 04:41:08

Post the SQL for your query and I then can build off of that.
--
KARL DEWEY
Build a little - Test a little