Summary: Hi: I have a lot of problem to set-up a weighted average in my form (i.e, =[field1*weight1]+[field2*weight2] etc / sum[weights]). It gives me a "#Name...
Summary: I'm new to Access & need some help summing fields from different tables. I have 3 tables: Table Fields Products: Prod Name, Opening stock Supplie...
Summary: I have been trying to manipulate data from a fairly complex database. I am creating a report that is counting a specified field once it has gone throu...
Summary: I would do it as three tables: TABLE 1 (PLAYER): P_ID: A unique ID for the player P_LASTNAME: Last name P_FIRSTNAME: First name P_HEIGHT: Height (in i...
Summary: I am trying to calculate my cost per unit based on the hourly rate paid and the actual time spent on the specific job. I have columns with the followi...
Summary: I need to perfrom calculation at the lowest level in a product hierarchy and then roll up the result without recalculating at higher levels. How this ...
Summary: In my access data base I have tables call tape details & tape category. Fields are receved amount, received date & tape categoy. I want to calculate ...
Summary: Hello, I'm wondering if we can do math fraction operations and also store in columns, by keeping it always in fractions format (dividend/divisor) incl...
Summary: If statements are IF something is Then do, this...Else...do something else. So, your If statement should read similar to (forgive the context, as I d...
Summary: Dear Friends I have developed a Software. Now I need to trap the stability of my product. Please furnish the formulae which can help me in the above s...
Summary: In the interest of the first one to post on the forum and because I'm having a tough time wrapping my head around this one, here goes: I have a table ...
Summary: hi, I need help on making a SQL query to find the total processing time of a document by each user by each day. The database is SQL server 2000. The...
Summary: Okay, here's the deal. Let's say I have a column of numbers. A 2 B 3 C 5 I want to create a calculated field in a query that finds the percentage of ...
Summary: have to summarise something in ms-access. am using access 2003. i have a query with the following fields. (this query has some other fields also. this...
Summary: I want to automate a process that I perform on a weekly basis for my job. Currently, I have a bunch of SQL scripts that I run through JMP, a comprehe...
Summary: I agree with Jennifer, The query I would use would: 1. request start date for the current week 2. calculate the end date using DateAdd to add 7 days o...
Summary: I have the following table and I want the difference for each Product/Process combination to the next process. The next process is not fixed, so it is...
Summary: I need to for one carton at a time, actual weight ((sku1_weight * qty) + (sku2_weight * qty) +...), find the least heaviest weight (based on lowest po...
Summary: I have two very different reports that I have to run to get all the info out of an inventory database. The first one extracts the current inventory, ...
Summary: Hello Forgive my poor SQL knowledge. Im looking after an SQL 2005 machine which i inherited. I typically just need to maintain it, however, Im after g...
Summary: PROBLEM 1: ---------- i have 2 function that use paramaray as argument FUNCTION func1(Paramarray arg()) //some code here func2 arg //more code here en...
Summary: I'm capturing number of days between two dates with the formula =Now()-N9 in cell O9(for this particular cell, the formula repeats from O9 to O58. The...
Summary: I have created a time card database that calculates total hours. Also, I have two tables employees and time cards. In the employee table all of their...
Summary: for excel 2003...... i have a large range of cells that have mostly different dates, some are similiar. What i need is a formula to count th dates tha...
Summary: I have a series of reports that I have created in MS Access. These reports need to include Mean and Mode at the end of the report. I know how to calcu...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
