What Calculation To Use?

Jan 2, 2006

What would I use for a formuls to find all product that are in stock.
like I have a price for all products that i stock, but some i don't have in stock. How would I query for the ones that I have in stock?
In my table I have it as UnitsOnHand, I have it as how many, like 1 or 3 or 4 etc. And also a field for Paper or Metal.
How would I query just for paper and not metal?
I am also going to need a query for the lowest price and the highest price.
Please understand I am New and I have allready search through all the post and can't seem to find anything close to what I am trying to do.
Any and all help would be great

Thank You
WackoWolf

View Replies


ADVERTISEMENT

IF Then Calculation

Oct 11, 2005

Trying to calculate a few fields. 1st field is [delays] and 2nd field is [Planned]
The Plan scheduled for 60 and the Delays are an entered value. In the on update command button on the form I want code that will take the value above 60 and add then to the value in the [Delays] So if delays is 10 and the planned is 70 then planned will change to 60 and delays will = 20

any help

Jon

View 2 Replies View Related

Q:Calculation

Oct 24, 2005

Hi All.

I have 3 tables in Access:
tblCurrency (Fields: IDCurrency, CDate, CRate)
tblOrder (Fields: IDOrder, OName, ODate)
tblCalculation (Fields: IDCal, Rate1, Rate2, Rate3, COrder)
IDOrder is related to COrder with "One to Many" connection.

I have Form frmOrder, based on tblOrder. For Example Form has 1 record:
IDCal OName ODate
1 XXXX 2005.10.24

For this record related table has 2 records:
IDCal Rate1 Rate2 Rate3 COrder
1 10 3.5 15 1
2 6 4.2 12 1

tblCurrency for Exapmle have one record too:
IDCurrency CDate CRate
1 2005.10.24 0.2

In frmOrder I have textBox txtRate. Here I need to be calculated:

=Sum (Rate1*(CRate from tblCurrency Where tblCurrency.Cdate = tblOrder.Odate)+Rate2*Rate3 for Each record related to tblOrder).
By Exapmle: (10*0.2+3.5*15)+(6*0.2+4.2*12)=106.1

Please help with expression.
Thank You in advance.

View 3 Replies View Related

Need Help With Calculation

Jun 9, 2007

hey i hope some one can help me...

I am making a database for products and suppliers. Many suppliers can supply each product.

The product details are in a table called products, the suppliers details are stored in a table called suppliers and the suppliers offer for each product is stored in a table called prices.

the structure is as follows:

Table: Products
Product Name
Trade Price

Table: Suppliers
Supplier Name

Table: Prices
Product Name
Supplier Name
Supplier Offer

I have form that shows the product details and a subtable linked to the table:prices.

The problem

I need to add a field in the subtable called "Percent off trade" which is the trade price - supplier price / trade price * 100

i created a query showing the same records as the prices table plus the field "trade off price" and set the Field to:

Percent Off Trade: ([Forms]![Products]![Trade Price]-[Prices]![Supplier Price])/[Products]![Trade Price]*100

But this doesnt give me the correct percent :confused:

I hope i have explained this query and would really appreciate anyone who takes the time to suggest anything that could help

thanks in advance!

View 5 Replies View Related

Calculation

Nov 21, 2007

How can I multiplicate two numbers from two columns in a subform, show their result at the end of the row and then calculate sum of those results on the main form. This is something what I know how to do but the problem is following:

The total sum on the main form should be multiplicated wit 0,5 % and then reduced for a value of a specific row sum. It should be something like this: (Sum of rows sum * 0,5 %) - Sum of the specific row = Total sum on the main form. And all of this should be on a report too.

View 1 Replies View Related

Need Help In Calculation

Jan 20, 2008

hi,


i'm working in a database and i face some problems in some calculation

this is my table which contain these fields:
NOC number
Company Name
Warning Letter


Note: each company has many NOC

Here what i need from the query

1- create a field which contain a total of warning for each month
2- create a field which contain a total of warning for each NOC
3- create a field which contain the total of warning for the company

View 3 Replies View Related

Help With A Calculation!

Feb 26, 2008

This is probably an easy calcualtion I am overthinking...
I am trying to make a query where I am calculating the "Total Value" of each customer's order of each item for the current week. The item "my company" is selling is fish, sizes small, medium and large all at different prices. I'm not exactly sure what they mean by "Total value", but I assume I take the cost times the quantity...but then what is the difference between Total Value and total ordered (in dollar amount)? Any suggestions?

View 2 Replies View Related

Calculation

May 25, 2005

I wonder if someone can point me in the right direction with a calculation problem. I have never done calculations in access before but want to make a balance sheet for a club account that I am designing. Very much in its trial stages, I have a form with three currency text boxes in it, set up as continuous. MoneyIn and MoneyOut are in the main form whilst Total is in the footer. All I want is to be able to put in a value in MoneyIn or MoneyOut and for the Total to update. Problem! I dont have a clue where to start! :rolleyes:

View 2 Replies View Related

Calculation Help

Jun 20, 2006

Here is a part of my database nicely zipped for you guys to help me with.

whats happening is when i click the totals button whatever the highest cost option that is selected with a "Y" should be displayed in the totals text box.

example:

Installation of heating system - "Y"
Replacement Kitchen and Bathroom - "Y"
Total should be "£90"

The code behind the button works fine with every choice but not the installation of the heating system. When this is selected "Y" the code seems to be ignoring it.

Any help will be much appreciated.

View 4 Replies View Related

Payroll Calculation

Dec 6, 2005

I am trying to type a code based on 1 & 2 criterias. However, I am having a problem on the first criteria because it is adding 8 hours when it shouldn't. Can someone help to either fix my code or write a new one? Thank you very much!

Criteria 1: If the day_of_wk is 1, calculate time-reg_time/60, If the day_of_wk is 1 and time is less than 0, calculate time-reg_time/60+24

Criteria 2: If the day_of_wk is 2, calculate time/60, If the day_of_wk is 2 and time is less than 0, calculate time/60+24

My code: pre: IIf([day_of_wk]="2",[time]/60,IIf([time]<0,([time]-[reg_time])/60+24,([time]-[reg_time])/60))

View 4 Replies View Related

Time Calculation

Jan 25, 2006

i have two date/time fields

sdate (start date) 01/01/2006 14:30 - format(dd/mm/yyyy hh:mm)
edate (end date) 02/01/2006 14:31 - format(dd/mm/yyyy hh:mm)

i need to get answer in HH:MM (24:01)


pls help me

thnx best regards
ibu

View 4 Replies View Related

Time Calculation

Jan 25, 2006

i have two date/time fields

sdate (start date) 01/01/2006 14:30 - format(dd/mm/yyyy hh:mm)
edate (end date) 02/01/2006 14:31 - format(dd/mm/yyyy hh:mm)


i need to get answer in a textbox as 24:01 (hh:mm)


pls help me

thnx best regards
ibu

View 2 Replies View Related

Time Calculation

Feb 8, 2006

Hi all,


I'm a beginner, and i want to know how to calculate time difference. For ex, if i substract 23:45 of 02/09/2006 with 00:10 of 02/10/2006 then i get a - "ive" value... Please somebody help me with a vba code for this...

thanks
Senthil.

View 1 Replies View Related

Date Calculation

Feb 11, 2007

I want to resolve date calculation problem.

I have one form field with users total sum of lenght of service (format of field looks like yy/mm/ddd) in another form field I have data with users date of employment in a firm.
In the third field I want to show total sum of lenght of service (previouse lenght of service and lenght of service in our firm) in format like in first field yy/mm/ddd.

What is a easiest way to calculate a third field in a form.

Thanks in advance !!

View 3 Replies View Related

Speed Of Calculation

Apr 5, 2007

Hey,

I noticed something strange in access 2000: sometimes it takes a long time to calculate a report and other times it goes rapidly. I don't see any process taking a lot of CPU %.

When i do the same thing in Access2003, it goes rapidly every time.

Can anyone help me?

Rik

View 1 Replies View Related

Stock Calculation

Apr 19, 2007

Hi All

I am seeking the solution to a problem with calculating stock adjustments

We use a job code which comprises several stock items and labour which = a $ value

I have a form "work in progress" where I enter all the job details including the job code, the aim is to reduce the individual stock items from a table "Stock" when the job code is entered.

JobCode 25WE = 1 x power point, 25metre cable , 9 x clips

I have tried several methods but to no avail, is there a way of doing this

Thanks in advance
GeoffK

View 1 Replies View Related

Access Calculation

Jul 18, 2007

i Want to make something in access for my job but i dont know how ... I have many years to use this software.

The idea is to have a FORM with many boxes .... http://img329.imageshack.us/my.php?image=58740895rq8.jpg

when i press product 1 and then product 2 i want to calculate, to give me the sum ....... i ll need to have many products i want to make calculations show i ve create one table from which i want to take the prices ...is it possible or it can be with an other way ?? :confused:

http://img525.imageshack.us/my.php?image=90673797oy7.jpg

Does anyone have a similar to saw me? :o

I need ideas !!!!


thanks!!!!

View 10 Replies View Related

Simple Calculation Help

Jul 20, 2007

Well, I hope this is simple, but for some strange reason, very difficult for me.

I'm having issues setting up a calculation between 2 tables. for example:

Table1 ID Quantity


Table2 TransID Used


The "Quantity" from Table1 is a set number but the "Used" will change. all I want to do is have a Form and Report that will subtract the "Used" from Table2 from "Quantity" from Table1.

I've tried: =Table1.Quantity - Table2.Used
=Quantity - Used

what am I doing wrong? all my attempts have failed, even though I have setup a relationship between the 2 tables.

any idea?

thx

View 6 Replies View Related

Calculation Problem

Oct 20, 2004

see this thread...
http://www.access-programmers.co.uk/forums/showthread.php?t=69237

hi everyone,

can we please start this thread again...

- since may'04 (when we started this thread), i have tried many of the suggestions in the replies to this thread, and as i am no expert in access i repeatedly ended up at the beginning.

- if look at the history of this thread, you will notice that i need just a very small and simple db.

- since may'04 i did alot of reading and 'self-study' on access, and i'm sort of "getting the picture" now, but could find nothing to sort out my problem.

- most of you guys seem to know alot! about programming in access, and i have great respect for you... but if anyone could please suggest something SIMPLE! to sort this problem i'm having. (or is this wishfull thinking on my part?) :)

have a good day !
Regards,
Piet.

View 2 Replies View Related

Date Calculation Help!

Nov 4, 2005

Hi, I have a table that has a start date field, a duration field and an end date field. I was wondering what I need to do so that the end date is calculated and entered when the duration is added onto the start date to produce the end date?

Should the date fields be set as a date, data type?

Sorry if this does not make sense ;)

Many thanks, Tobi

View 1 Replies View Related

Another Calculation Question

Feb 26, 2007

Hi there.

I have inherited a access database from someone who left the company and I am not to clued up on how to use access, but have found something annoying.

What they have is a row with some customer information and then a sub section / table where some data can be inserted relating to that customer.

In the main row, there is a column where the customer has purchased a certain number of hours, in this example 75 and the column next to it is the hours remaining.

Now when I enter some data into the sub table column 'hours', I would like it to calculate the remaining hours by doing a subtraction from the total hours.

So for example:
Total Hours =75
New data (hours) = 5
Left should = 70

Can this be done?

Below is a link to a hosted image of the table.
http://img86.imageshack.us/img86/5018/dbzw6.th.jpg (http://img86.imageshack.us/my.php?image=dbzw6.jpg)

I really hope someone can help me out with this.

Regards
Rob

View 3 Replies View Related

Calculation In A Table

Feb 14, 2008

Hi all - I have a table that is keeping track of projects we are working on. There is a field with the overall cost of the project and a field with the percent paid. I would like a field that calculates that amount still owed. Is this possible?

Thanks!
Amelia

View 2 Replies View Related

Calculation Using Just The Last Two Records

May 10, 2005

Hello All. I am new to these forums but appreciate very much any feedback on my question:

I have a table in my database that retains weights for our clients. The table contains the following fields:

ID
ResidentID (relates to the residents table that has name, etc.)
Date
Weight

Each month with a client is weighed, the date and weight is entered into a subform.

I am attempting to perform a calculation in a query and/or report that would automatically give the weight gain/loss between the last two entries.

Any suggestions on how to do this? There is of course the "last" function, but I cannot figure out how to get the record just prior to the last.

View 2 Replies View Related

Query Calculation

May 16, 2005

Hello, I have the following criteria for my Query >=0.8*[Projects]![EstimatedHours]. This tells me when we've used 80% of our actual hours. How would I go about the criteria line if I wanted it to return above >= 50% hour use, but below 80%? Thanks

View 1 Replies View Related

Date Calculation

May 31, 2005

Hi Every1

I need sum quick help
I want to pick out the date from my table that is 2 weeks old?
Any ideas how to do this?

thanks

View 11 Replies View Related

Null In A Calculation

Jul 12, 2005

Ok, so sorry if this has been asked before but I couldn't find my answer searching.

Basically my expressions in a query are giving me #error because there are some null fields being calculated.

I would like to know how to consider all null values as 0.

Is it something like this? IIF [FieldName]=Null,0

There are about three or four different fields that need something like this.

Also, I'm kind of new at this :o so could someone please tell where exactly to put the code for this?

thanks so much in advance.

joëlle

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved