PC Review


Reply
Thread Tools Rate Thread

calculated fields in a form

 
 
=?Utf-8?B?Y2hhcmxvdHRl?=
Guest
Posts: n/a
 
      21st Feb 2006
I have a form 'frmStock' with fields detailing stock. I have a combo box
linked to a field in the form, detailing four different categories of sales
tax, which are named and inserted into the control box. In the footer of the
form I would like to insert calculated text boxes with the amount of tax
payable upon sale according to the type of sales tax. I can set up a query,
linking the tblStock with the ids values of the Look up table, which has
calculated fields which correctly work out the amounts due. I am uncertain
how to insert the calculated amounts into the footer of the frmStock. I don't
know if I can link the query field into the form or if I should build the
arguments into unbound text boxes in the footer of the form - in which latter
case, I would need to include the ids values of the Look up table with tax
types. At present the tax types are inserted into the form only as names and
not as number values. The expression in the query calculated field only seems
to work with numbers not names.
Any suggestions as to the best way to proceed?
--
charlotte
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculated fields on a form Tony Microsoft Access Forms 2 30th Mar 2010 04:51 PM
Calculated fields in main form based on criteria in sub form Data Tim Microsoft Access Forms 3 7th Oct 2008 05:30 PM
Calculated Form Field Option that sum other form fields =?Utf-8?B?RERUZXhhbg==?= Microsoft Word Document Management 2 14th Jan 2006 06:28 AM
Calculated Form Fields do not fill data into related table fields =?Utf-8?B?cmljaDE4Mzg=?= Microsoft Access Forms 1 12th Feb 2005 08:11 AM
calculated fields on a form =?Utf-8?B?VmFuZXNzYQ==?= Microsoft Access 1 8th Sep 2004 09:24 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:44 PM.