MS ACCESS :: One PC Not Able To Calculate Formulas Ect.

Array Formulas (scary Formulas)
Desperate help required - I am about to throw my laptop out the window, closely followed by myself!!!

I am self taught and rely on books or perseverence normally so apologies for lack of technical terminology. I have spent days on this to no avail- I believe this needs to be some sort of array formula but am open to any suggestions and advice!

Problem;
I have two workbooks, I need the result of the scary formula to be shown on the summary sheet in one field.

I need the formula to look at the other sheet and recognise (for each of the 100 or so rows) if the entry in column G is "F" or if it is "W" to recognise the number in column N and add it to all the other ones that also fit this spec.

Basically, the summary figure is the sum total of all the numbers in column N that have F or W in their associated column G.

A thousand thank yous to anyone who has the time to help!!!
Laura :confused:

View Replies !

Formulas
Ok I have Access 2000 and I am a little rusty.
I have a table created that stores all of our relevant production information.
What I want to do is print out a report that shows the daily sales, as well as create totals (forumulas. For the life of me I cannot figure out how to get Access to calculate '# of Units x price per unit= total.' and put that in a report.

I understand I can use the form to enter data into the DB. Will a report do the calculations that I want? Or a query?

I am kinda at a loss and I need to figure this out.

Thanks

View Replies !

Using Formulas In Access
hi, i currently use acces to record the concrete order, used, wasted and waste %.

i was wondering if it possible to use access to calculate these, like excel does, and are the formulas similar to type in?

here's what im currently doing:
(For argument sake, i'll put the formulas from row 3 in)

Column A: Estimated Metres : Data manually input
Column B: Used Metres : Data manually input
Column C: Waste Metres : =IF(ISBLANK(B3),"",(A3-B3))
Column D: WAste % : =IF(ISBLANK(B3),"",((A3-B3)/A3))

The main bit i want access to do is in bole. ignore the rest, its just to keep my sheet tidy.

Can Microsoft Access do something similar. There is more, but i'l start here, so i can learn bit by bit.

Any info would be great. Thanks!

View Replies !

Queries With Formulas
I am in process of creating a new tracking report. I have to do a scoring system where the number of contacts you get a day equals a daily score. The problem I am having is getting this score to work with entries that are equations. One that I am working on is calls per hr/per day. I have inbound and outbound calls that have to be added-that part works. I then need to divide that number by the time worked for the day- that works. I now need to get that end result to match a score or ranking number. An example would be if a person takes 30 inbound calls and makes 125 out bound calls and works 7.5 hours. My calculation is (30+125)/7.5=20.6. My totals are now expressions because they read: Expr3: (([Extnout]+[ACDCalls])/Expr1). By the scoring set up, 20.6 needs to equal 4. How do I get the expression to read a score and make it equal.

View Replies !

Formulas In Access
If i was to use a forumla in excel to add a number of cells together i would use this forumla =sum(c1:c4) rather than having to use =sum(c1+c2+c3+c4) In access i want to add a number of fields together so that i can caluclate the number of days we have had pallets in our warehouse. I have tried entering the formula =[days stored 1]:[days stored 4] ( i have also tried enter "=sum infront aswell")but it comes back with an error message. but when i enter =[days stored 1]+[days stored 2]+[days stored 3] and this gives me the correct sum. is there any way i can use ":" in the formula since i have a 100 fields called days stored(number) and i will be very painful having to type the formula in the long way.

thanks

View Replies !

Follow-up Dates Formulas
How do I enter a formula/calculation in a table for follow up dates. I have a basic start date. In my form/table, I want the program to insert the following follow up dates automatically: one month, 3 month and 6 month.

View Replies !

Problems With Formulas From Excel
Hi,

i currently have a spreadsheet with 6 columns and about 80,000 rows in excel.
I have been told to move it to access to make it faster. but am having problems.

each column has a number in it eg: 1, 5, 23, 45, 56, 43
say i need to find any rows containing eg: 5, 1, 56

currently (in excel) i use an extra column with this formula

=isnumber(MATCH(5,A1:F1,0)*MATCH(1,A1:F1,0)*MATCH( 56,A1:F1,0))

and it tells me which row has the numbers in it with either true or false, and then i filter the trues to get all the rows that have the numbers i need

and the numbers i want to find will change all the time

i have tried to copy the whole spreadsheet to access and it comes across, but my formula doesnt work

Is there any way around this, should i be doing something else?

Thankyou for your help:)

View Replies !

Formulas To Values And Then Storage
I am hoping someone can help with the following...

I have a form which calculates values based on (of corse) the info entered on the form and some subforms for example...
here is one of my formulas

=Form!QuiltTypes!QuiltPrice*[TotalInches]

I am assuming that because this is a formula the value will not be saved in the table... or at least its not doing that now.

Can someone tell me how I can move my formula values to my table for storage?

This is my first time here so if you need more info or anything please let me know.

View Replies !

Use Of Formulas In Access Reports
Hello,

I need to replace certain values by an abreviation. Is it possible to use a function similar to the following (Excell) formula in a field in an Access Report?

Code:=IF(A1="XXX";"AAA";IF(A2="YYY";"BBB";IF(A3="ZZZ";"CCC";" ")))
If so, what syntax should I use, because this doesn't work in Access.

Thanks in advance!

View Replies !

Date Formulas In A Table,
I have this database, and one field is a start date, and another field is a date to mail out a thank you letter. I want this field to automatically display a date 5 days ahead of what the start date field's date is. I've seen how to do this in a form, but I need to do this from a table, and since I'm relatively new to access, I don't know where to put the formula, I can't figure it out, and I can't find anything pertinent in MS's help...

View Replies !

Dynamic Query Based On "formulas" Stored In Table
Hi,

I have a table that looks something like this:

Company Product Sales
1 A 5
1 B 2
1 C 7
2 A 8
2 B 1
2 C 2

I want a query to produce a table showing Products A though D which is
the sum of Products A and B. Result:

Company Product Sales
1 A 5
1 B 2
1 C 7
1 D 7
2 A 8
2 B 1
2 C 2
2 D 9

I have many rows and many summations and the current union query and
supporting queries are pretty messy and not easily changeable. What
I'd like to do is have a third table which would hold the summed
product names and the formula used to get to it (Product D, A + B) and
have a query that can be dynamically based off of that table. Do I
need to use VBA? Does anyone have a better idea? Any help or even a
good search term would be appreciated!

Thanks!
Nathan

View Replies !

Forms +List Boxes +Text Boxes With Formulas
I have a form with a List Box (List BoxA) that returns a value from a query. I then have a Text Box (Text BoxB) that uses the value from List BoxB and multiplies it by let's say 2. It works giving me the correct value but only becomes visible after I click inside List BoxA. How can I make it visible as soon as the form is opened? I tried refreshing the form data, didn't work and I tried a requery macro which didn't work either.

Thanks,

Lester

View Replies !

Calculate A Value
How would i go about getting the field 'GMargin' (Gross Margin) to be calculated from subtracting 'SellingP' from 'PurchaseP' (Selling and Purchase Prices)?

How do i do this? Help me please :)

View Replies !

Calculate
I have a field which I enter a short time such as 3:13, 5:45, etc

Now i am creating a report which at the end of the report I would like to include an unbound text box, which displays the total amount of time for that field (pls note that the total will never exceeds 24 hours) What is the best formula to use in order to calculate this ?

Cheers

View Replies !

Calculate Hh:mm To Mm
Hello,
I am trying to sum minutes from a database using an Access query, but the format in the database is hh:mm. I know the query to use in Oracle:
ROUND(SUM((substr(actual_time,1,(instr(actual_time ,':' )-1))) *60 + (substr(actual_time,(instr(actual_time,':' )+1),2)))
but not sure of the syntax to use in an Access expression.
Any ideas?:confused:

View Replies !

Excel Can´t Calculate.
HI,

Excel is having difficulties calculating a workbook of mine. It complains about cirkular references, so I had to set the iterations manually.

The workbook holds about 5000 records and I´m using a cosinus function.

The thing is I don´t know what to do. Excel calculates the workbook, but it doesn´t do it right. What setting should I use with the iterations?

I´m thinking of running it in excel 97. Will that help?

I really need to be able to run this workbook. Does anyone have an idea?

Fuga.

View Replies !

Date Calculate
I want to calculate a data from anthony table, like (20 Jan 2005) + 365 days
will be 20 Jan 2006, how can i do it.

The Table setting is just like below:
Constituent (DataID,...);
Student (DataID, DOB,...);
School (DataID, 4YearsOld(As a Date Format),...)

Anyone can help me, Thank you.:)

View Replies !