Newbie- How To Attach Formula To Field In A Table.
Mar 9, 2008
I'm sure this is a simple issue, but so simple I can't find the answer.
I have a recipe DB and have calories and fat and fiber fields, I want to have another field which will display a point count for a formula (calories/50+Fat/2+fiber/5) but the catch is if the fiber number entered is over 4 I only want the calculation to use 4 max.
Not sure how or where to create this formula to populate a field in the DB.
As you can tell I'm new to all this and any help would be appreciated.
Thanks in advance
Mike
View Replies
ADVERTISEMENT
Jan 26, 2006
Hi,
I have a field in one table that needs the sum from fields in another table.
How do I go about doing that?
Thanks,
Trena
View 1 Replies
View Related
Dec 11, 2005
I am new at this and have been struggling for days trying to solve this problem.
I created a database, using the wizard, to keep records of my orchids.
This resulted in a table. I keyed in the information on each plant.
Then I created a form, using the form wizard. Everything worked great. I could switch between the form and the table views.
The other day, the form no longer contained the information from each of my records. When I tried to switch to datasheet view (from form view), there was no longer a datasheet listed.
When I go directly to the datasheet (when starting Access), I can see all of the records (186 of them), but if I try to switch to form view - no form is listed.
Please help.
View 3 Replies
View Related
Jul 10, 2013
I am trying to set up a create table query using parameter called Year. For each year I input , I need to create a new table with the suffix of the year. for example, if i input year 2011, i want to create a table called budget_2011, if i input year 2012, i want to create a table called budget-2012...
View 3 Replies
View Related
Oct 12, 2014
I have hp scanner whose twain driver has the option to scanning in the pdf document.
Microsoft WIA 2.0 have save scanned document only to graphical format.
I want automated (on click any button control) to scan multipage document from glass source or ADF to pdf document and attach it to attachment field.
I'm found VB Module for accessing TWAIN compatible scanner but it is call twain software and scan to bmp format with assigned name of file.
Me need it also only use the pdf format .
View 7 Replies
View Related
Apr 27, 2005
I've got a table set up with sales info and all other kinds of data. How do I get a formula to work? Here are the inputs I have: Total sales (by outside company), total purchases (from my company). I want to know what percent of their total sales are made up of the poducts they purchase from me and have that field update automatically. Its a simple formula really, I just don't know how to enter it properly. Thanks.
View 2 Replies
View Related
May 31, 2007
Hey guys hope someone can help me out here...
i need to have a currency field in one of my tables, the user will enter the price in euros, and the output will be in pounds... therefor i need the following formula to work:
[enterdprice]*[current exchangerate] = price in pounds
i would very much appreciate suggestions/help
View 3 Replies
View Related
Dec 15, 2006
hi i have a text field in with this calculation
=([Total amount requested]+[text3])/[Initial valuation]
it displays a div/0 error which i want to remove, i know i need to put this calcualtion in an iif statement but whenever i try and make the formula it never works
=iif([Total amount requested]+[text3])/[Initial valuation],?,""
where the question mark is i am not sure what should go there, as i want the total to of the calculation there and if 0 hide 0 with the ""
this has been bugging me for a while now and i can just get my head around it, probably very simple for someone to answer
regards
chris
View 3 Replies
View Related
Apr 11, 2005
Hi all,
A nice easy one for you. I am creating a database, one of the fields is total cost. Is there an easy way to have another field, which calculates the VAT without using a query? I would like this done as soon as the total is entered.
I have done this using a query, but didnt like this way.
I am sure there must be a very simple way of doing this but it has escaped me.
Help
Phil
View 2 Replies
View Related
Nov 20, 2014
I am trying to make a query using fields from multiple tables. I used the Expression builder to create it and it is a formula field where multiple table fields are involved. But whenever i run the query Access asks for a parameter value in a modal dialogue for the value of the fields. Is it because the field names has Square brackets around it? But access puts that automatically. How to make it work properly?
View 11 Replies
View Related
Apr 8, 2013
I have a field in my query which returns results based on a formula that is a function of other fields. The results are: Pass and Fail.
I want to make a query that returns only Fail rows. When I enter Fail as the criteria, a parameter box pops up requesting information be entered before continuing.
How can this problem be rectified?
View 11 Replies
View Related
Jan 16, 2015
I need to add a text box to my report that shows the value of a record in a certain field that is corresponding to a given value in another field.
For example, if my report shows the following:
N City
3 D
7 F
2 H
9 K
4 A
the text box should show the name of the city corresponding to the largest number which is in this case "K". is it possible through formula builder?
View 1 Replies
View Related
Apr 8, 2013
I have a field in my query which returns results based on a formula that is a function of other fields. The results are: Pass and Fail. I want to make a query that returns only Fail rows. When I enter Fail as the criteria, a parameter box pops up requesting information be entered before continuing.
View 1 Replies
View Related
Apr 23, 2007
I have two fields on a table that has numeric values.
I'd like to create a third field where i would just like to divide the two numbers, multiply by 100 and display the results on field three.
I can't use forms or reports as i need to be able to export this information to excel.
Can this be done?
View 9 Replies
View Related
Apr 6, 2007
Hi All:running Access 2000.I have a qry with a formula field that performs some calculation (Extension: CCur(([OnHand]*[Price])/[UnitsPer]))and it works fine. How can I update the actual table with the result of the calculation for every record? The problem I have is that there's some null values in the results therefore when I try to get totals on that field, it errors out saying "invalid null use"thanks
View 7 Replies
View Related
Apr 23, 2014
I got a table salaries master I want to extract some info out of and calculate some values. The formula below doesn't work, I'm pretty sure it has to do with [pay period] being a text field. Is there no way to make it work?
'Gross monthly Salary: IIf([Salaries Master]![Pay Period] = "weekly";[Salaries Master]![Daily Wage]*5*52/12,IIf([Salaries Master]![Pay Period] = "monthly";[Salaries Master]![Daily Wage]*20))'
View 10 Replies
View Related
Jan 31, 2014
I have a date in "date to engineering" of 13/ 01/2010 but I am not getting a value in my field which should be 1479 my field is just always returning an empty field
Code:
=IIf(IsDate([date to engineering]),"",IIf(IsDate([date from engineering]),Now()-[date to engineering],[date from engineering]-[date to engineering]))
View 4 Replies
View Related
Nov 21, 2007
I've built a table and used it to build a form. One the form I have three boxes, one to enter the DoB, and two others that record the age and also put the individual into an age bracket.
In the latter two categories I have entered a formula in the Properties Box under Data & Control Source (the formulas are below) to automatically work out what the age and age bracket is when the DoB is entered. This works fine but the information isn't transferred back to the table.
Do I need to do the info in the table first and then update the form? And if so where do I enter the info in the field properties in the table design view?
=Int((Date()-[DOB])/365.25)
=IIf([age]>=50,"50+",IIf([age]>=35,"35-49",IIf([age]>=25,"25-34","16-24")))
Many thanks in advance
View 2 Replies
View Related
Jan 22, 2005
I have a form that has 3 fields each representing a different table. I want the sum of 2 of the fields to update the third field. The third table has an existing value in it, but I need it to change when the formula is executed. I have a formula embedded in the form and can make the formula work, but it doesn't update my table. How can I make it do this? :confused:
View 1 Replies
View Related
Nov 17, 2006
Hi,
I am an Access newbie and I have a form running about 5 seperate formulas and I would like to store the info in the table that it is associated with so that I can use it later in a query to create another formula. Any help would be greatly appreciated.
View 6 Replies
View Related
Sep 25, 2014
I have a report exporting to excel using late binding techniques. When exported into excel i have numbers for 1,2,3,4 tblPreSiteSurveys. PreSiteSurvey Stop TheClockReason entitie and I am trying to either change the numbers here casting from int to string
1 = a
2 = b
looping through the record set, Or i have a blank field in my SQL for the column "P" and adding the formular to that column, but it only goes into the first row of the record set, which is a expandable table.
On Error GoTo Command29_Click_Err
'Utilergy Master Update report
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Dim UserDate As Date
[code]...
View 12 Replies
View Related
Aug 3, 2007
i'm new to ms access please help, how do i set this up please suggest
ID Name
101 james,Jonathan, Paul (option to select 1)
102 milton, harry, george, (option to select 1)
103
each Id refers to a constant value but i need only to select 1 name for each ID
sorry for my poor english....
View 1 Replies
View Related
Dec 11, 2005
Hello...
I am a newbie to Access or any database for that matter. So please be gentle.
I'm in the process of writing an automotive invoicing database and have gotten stuck early in the game.
On my form I have Qty1 - Mat1 - and Amt1 fields placed from my database.
In Amt1 I would like to typein an amount and have it multiplied by 15% (.015).
I fiddled with the "On Enter" in the Amt1 property box but got nowhere.
Can someone help???
Thanks for your time
d9085@hotmail.com
View 7 Replies
View Related
Sep 22, 2006
Hi there - i'm looking for a bit of help on something that is probably obvious to experienced Access users - i've checked the forum for about 25 min or so and couldn't find a related answer to this question.
I have a select query (QRY2) that reads another select qery (QRY1), and I need to (or rather, i'd like to) add a field to QRY1 - how do I get it so i can view this new field from QRY1 in QRY2?
thanks so much for anyone who could help me!
View 4 Replies
View Related
Apr 9, 2008
I’m trying to create a DB with some field validations. I have a field named ‘Value’ and a field named ‘Doubled’. Value is in a currency format. ‘Doubled’ is in a Y/N format. I want a to create a rule that prevents the value ‘Yes’ from being entered in the ‘Doubled’ field IF the value in the ‘Value’ field is greater than .60. How do I do that?
I entered "[Value]< .6" but that wouldn’t allow me to put any value in the ‘Value’ field – it popped an error every time.
Thanks for helping out a newbie!
View 1 Replies
View Related
Sep 14, 2005
I am working on this database where each category contains certain thickness ranges that can be stored in a pack of x amount and finally paneltypes.
ie KS1000 only comes in 40mm 50mm 75mm and paneltype MR is the one associated with it.
there are 3 tables
tbl_Customer
tbl_catergory
tbl_product
--------------------
tbl_Customer:
-CustomerID (autonumber) Primary key
-CompName
-CompAddr
-ContactFName
-ContactSName
---------------------
tbl_category:
-CategoryID (autonumber) Primary key
-Category (combo box) this has set values entered i.e.
KS600
KS900
KS1000
KS1000LP
KS1000RW
------------------
tbl_Product:
-ProductID Primary key (autonumber)
-fkeyCategoryID (foreign primary key)
-Thickness (combo) this has set values of thickness ie. 40, 50, 55, 60, 70, 80, 100, 150, 180
-NoInPack (set number directly related to the Category and thickness chosen)
i.e. Category KS1000 with thicknesses of 55 can be stored in a pack of 17. KS1000 with thickness of 60 can be stored in a pack of 22.
-PanelType: (combo box) set values as follows:
MR (this selected item relates to products KS600 KS900 KS1000 )
EB (this selected item relates to product KS1000RW )
CX (this selected item relates to product KS1000 )
MM (this selected item relates to product KS1000 )
WV (this selected item relates to product KS1000 )
---------------
I would like to be able to setup a form that a user uses to provide a quote:
It would start with using the Category combo box which lets you select one of the choices (i.e. KS1000) but the combo box would also have multiple column headings ie. Category/Thickness/NoInPack. Once selected then the next several individual field boxes (ie. thickness, NoInPack) are automaticallly populated with the selection just made in the Category combo box.
NOTE: Many categories can be chosen just for one record.
I therefore do not want to start setting up fields like Product1 product 2 etc and their associated fields like thickness1, thickness2 etc.
I'm failing in the relationships section. Please see attached database.
I have tbl_category: CategoryID (1) --------> (many)fkeyCategoryID from tbl_Product
I have tbl_Product: ProductID (1) -------->(many) CustomerID from tbl_customer
I know that i need a junction table somewhere.... but i'm a newbie when it comes to this stuff.
Any help would be appreciated.
View 8 Replies
View Related
