Price Calculation In Access Like Excel
Dec 11, 2007
Hi all,
Help me solved my problem with price calculation in Access.
Please kindly view below excel file.
http://www.hwakeat.com/templates/AT05HKGP01/pdf/Products.xls
I like to do formula price calculation in Access like my sample excel file. How many table should I create & How to build query? Whenever exchange rate change or MarkUp price rate change, I only want to type once & it will affect the whole access.
I have tried so many ways in Access but it doesn’t work like my sample excel file.
Please Help me!!
View Replies
ADVERTISEMENT
Jul 29, 2013
I have a table called Books, in that table there is 4 columns ChapterName, Auther, ITEM, Price.
Each book has a item number, and each book has a few records with the same data, just the first column is different where its the ChapterName, each book has a price, but only once, meaning in the first record of each book it will be a price in the column price
Now I want a Query where i can get which book dont have a price at all, and which book has more than once a price, how can i do that?
View 1 Replies
View Related
Mar 25, 2013
I need to calculate qty with price in a form.
View 14 Replies
View Related
Nov 21, 2005
Hrmm, im sure there used to be an Excel forum, i seem to have lost it :/ Hope its ok posting here:
What im trying to do is, for a range of dates from 1/1/2005 to 31/12/2020 get the Qtrly Financial Period before...
So, for instance:
A date of 1/1/2005 makes the period before 1/10/2004 to 31/12/2005
A date of 1/5/2005 makes the period before 1/1/2005 to 31/3/2005
A date of 1/8/2010 makes the period before 1/4/2010 to 30/6/2010
Fiscal Period (for those that dont work with them) are, 1st April to 30th June, 1st July to 30th Sept, 1st Oct to 31st Dec and 1st Jan to 31st March of any year.
So what i want is 3 colums in excel, Column 1 = Period Start, Column 2 = Period End, Column 3 = Date
Can anyone figure the forumla out? Doesnt matter where its done in, just as long as the end result can be in Excel....
View 4 Replies
View Related
Apr 25, 2013
I am using Excel and Access 2010.
I have an excel spreadsheet with 8 tabs. They are all in the same format and column order. They are employees grouped by region. My ultimate goal is to merge all of these onto one excel tab, relatively instantly. I created a master tab and tried doing array formulas and Vlookups, it worked but my spreadsheet was way too slow.
My solution? Import and link them to an Access database, step complete. Create an XML export then import into Excel.
My problem? The only way to update the excel tab with the combined tabs is to save the excel file after changes, go back into Access, re-export to XML, then go back into excel and refresh the data.
My questions, is there any way to automate this process to the point that I can change excel, save, then hit refresh on my excel tab with the XML import to auto-update?
View 7 Replies
View Related
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
Jul 3, 2005
I just want it to deduct:
one numeric field from another - to get a miles travelled number ?
one currency figure from another - to get how much more/less fuel was used than last month ?
also to work out:
an average of 3 figures
to multiply one figure by another ?
Is this possible ?
How easy is it ?
This is because I want to move my Excel spreadsheets to Access so I can alalyse it better and create custom reports. But despite browsing Access for a while, I can't find the features I need, or anything in the help file to help me.
I've been using Access for a few years (Access 2000) and have created two custom databases from scratch.
Jay Evans
IT Support Co-ordinator for Simply Drinks Ltd
View 3 Replies
View Related
Jul 12, 2005
Could someone please help me with a calculation expression? I want the calculation to be in an unbound text box on the main form ([Primary View])which should calculate the sum total all records shown in the subform that contain a calculated field in the subform ([CBR Data Subform]!Rentable). The subform is set up in the main form to show records that pertain to one record in the main form. Right now, I have the following shown in the textbox:
=([CBR Data Subform]!Rentable) and I get a result but its not what I need.
I have tried:
=Sum([CBR Data Subform]!Rentable), &
=DSum([CBR Data Subform]!Rentable)
and I get error messages.
What other expression can I use or how can I improve the expression?
Thanks,
View 9 Replies
View Related
Nov 13, 2006
I need to find the average in a combination of 4 fields. In the footer of my sub form I have written =sum([amt paid in]+[dividends] / [units bought]-[units sold]). I have placed an unbound box in the detail portion with the following =[table1 subform].[form]![av dollars]. When I run the program, I get an outlandish number as the answer. I am a novice at this and any help would be greatly appreciated.
View 1 Replies
View Related
Mar 19, 2015
I'm trying to build an calculated expression, in a table/query, similar to what you can see attached (view jpeg in att.)
View 1 Replies
View Related
Aug 7, 2007
Hi, I am creating a table in 07 and I want my table to be able to calculate the difference between two amounts. I have the column "price" which shows the total amount, another one called "money paid" which shows how much of the total amount they have paid so far and the third is "money owed" which is the difference that i want to be calculated automatically.
Do you know any way to do this??
View 5 Replies
View Related
Dec 17, 2004
I need to be able to count the number of records in a report table in order to perform a calculation. For example record count/ total.
Thanks
View 1 Replies
View Related
May 23, 2013
Let's say that you have a cookie jar that's to be shared with two children, let's call them Jack and Jill.
You know that to start with (t = 0), there are 100 cookies in the cookie jar
Now the strange thing about Jack and Jill is that they start eating cookies on different days and that their cookie appetite depends on the number of cookies in the jar when they start, Specifically
Jack has an appetite of 10% of the total cookie jar and he starts eating on day one.
Jill eats after Jack and she has an appetite of 5% of the jar.
So what this would look like is:
Day 0 - Cookie Jar has 100 cookies
Day 1 - Jack eats, Cookie Jar has 100 - 100(10%) = 90 cookies
Day 2 - Jill eats, Cookie Jar has 90 - 90(5%) = 85.5
Problem:
1. Given that I have a table containing the starting number of cookies e.g.:
CookieTable
Startingcookies
100
2. Given that I have a table containing a record for Jack and a record for Jill, each with two fields: Eating Start date, Appetite % e.g.:
AppetiteTable
Child, EatingDay, Appetite%
Jack, 1, 10%
Jill, 2, 5%
What will the query look like that:
1. Calculate the number of cookies in the cookie jar over time e.g.
Day 0, Day 1, Day 2
100, 90, 85.5
2. Calculate the total number of cookies eaten by Jack and Jill e.g.
Child, Cookies Eaten
Jack, 10
Jill, 4.5
View 1 Replies
View Related
Dec 9, 2013
I have played with this problem for 3 days and have come close but not quite solved it. My problem, I have several drivers delivering several orders, the orders are named 101, 102 and so on lets say to 150. Due to locations of the drivers, some deliver more orders then others. I want to be able to create a report that looks like
"Driver #1 101 - 106"
"Driver #2 107 - 110"
Driver 1 delivered 6 orders. Driver #2 delivered 4 orders and so on.
I have tried the 'count" which gives me the number of orders per driver but having trouble figure out the design of the calculation in the query.
View 2 Replies
View Related
Jun 16, 2013
I'm pretty new to Access. I was wondering if it's possible to make a calculation for a specific row in an Access form.
I placed an example in the attachment (I made it quick in paint, because the actual Access form is in my language "Dutch" ):
Value1 and Value2 come from a database, so the amount of rows can change. When I click on "Calculate" on the first row, it should calculate 12 * 13 and show the solution only on row 1. If I click on "Calculate" on the second row, it should show the solution of 10 * 20 only on row 2.
I tried to solve this by using the following VBA code:
Private Sub Calculate_Click()
Solution.Value = Value1.Value * Value2.Value
End Sub
But if I click on the first "Calculate" button, it will fill all solutions with the first calculation (12 * 13).. The same happens when I click on "Calculate" on the second, third row etc.
View 2 Replies
View Related
Jun 7, 2013
In Access 2010 is it possible to have a tblKits with a column on it Reactions 8. Then on a form a field Used. When thee user inputs 2 into the Used field can the Reactions on in the tblKits be updated to 6 automatically?
View 1 Replies
View Related
Oct 21, 2012
how i can export the data from Access to excel using Access VBA for the specified sheet using data linkage with access database. Like we used to do it manually in excel as external data from access.Like we have some codes for linking excel file to database mentioned below;
DoCmd.TransferSpreadsheet acLink, , "region", "F:DB PracticeBook1.xlsx", False, "region"
Can we have something like this to link database table in excel file automatically.So that the excel size won't be that big and also it saves processing time.
View 5 Replies
View Related
Jan 2, 2006
After being a member on this site for a while now I would like to get some opinions on "cost of application development" I know the forum covers a wide geographic area and the members cover a wide spectrum of degrees of expertise on Access and application development. So the question is this..What would your rates be and how would you determine your charges for developing Access applications for a business?PS... Please include your location if not in your profile.
View 13 Replies
View Related
Jul 9, 2007
Hi
I have a problem which hope will have a simple solution, which has been
driving me mad all day
I have a client who has two prices for the same service depending on speed
of turnaround
These prices are entered into the Client table seperately using the CDetails form.
I then wish to use this information using a combo box for selection within
another form called SDetails.However I can only get the combo box within
SDetails to put one of the two prices rather than either of the two choices,
because of the bound column within the combo.
The combo when pulled down looks something like this
Price 1 Price 2 Client Name
I would prefer for
Price 1
Price 2
so that I have the choice of the price I want to choose.
Having spent time and many brain cells, I have ground myself to a stop.
HELP!!!!!! if only for the sake of my sanity
View 1 Replies
View Related
Oct 13, 2007
I am creating a db that handles orders.
My problem is that the products being sold are so at different prices depending on the customer. (e.g I am selling 100 burgers to Mcdonalds for £50 whereas to Burger King I am selling them for £35).
Therefore I have split my 'Products' table into two. A 'Products' table which contains the product name and category. And a second 'Prices' table which contains the Product name, Customer and the price.
I have setup a relationship between the two tables based on product name
How to I go about looking up the different prices depending on which customer I have placed an order for?
can it be done in a table or do I need to create a query to sort it all out.
View 8 Replies
View Related
May 15, 2007
I am in need of some assistance. I've been looking on here for an answer, but can only find solution that would give me a by column lowest price, and I need to compare the prices by row. What I have is a table of vendor prices for part numbers we sell. What I want to do is compare all the prices the vendors for each part number and return the lowest and 2nd lowest fields in a query. Here is an example...
Part # vendor 1 vendor 2 vendor 3 Lowest Vendor Price Low Vendor #
10526 .75 .97 .67 .67 3
10527 .60 .82 .85 .60 1
Thanks for any ideas....
View 4 Replies
View Related
Sep 13, 2007
I have a stock control database which i have nearly completed. This has Manufacturer, which is linked to products, which is linked to Sub Product(which also has field partCode). i.e. Manufacturer1 can have 3 products, and each of these products could have 5 subsystems and partcodes. Each partcode is unique to that subsystem/product/manufacturer.
I then have a pricing spreadsheet in excel, which has many tabs. A new column has been added for each item for Manufacturer,Product,Subsystem and Partcode.
I need to import these manufacturers,products,subsystems and partcodes, but into the tables with the correct relationships, i.e. product1 and product2 are products of manufacturer1 and so cannot come under manufacturer2, and so on.
I hope this makes sense, Thanks in advance for any help you can give!
Emily
View 14 Replies
View Related
Sep 11, 2005
ok i didnt know what section to put this in so i put it here. what i wanna do is add a price change history to my database. for example is the price of an item is changed in my database i want to be able to see what the previous price was and when it was last changed, either in forms of reports doesnt matter i just need somewhere to view this info. problem is i have no idea where to start.
any help provided is muchly appreciated thanks.
View 4 Replies
View Related
Jan 18, 2005
Hi all,
Before I start, please know that I am what you call a newbie to a certain extent even though I created in the last 3 years a very complex and efficient database for my business.
This is going to be hard to explain, but I'll try.
The time came to stop creating the Price List in Excel and copy and paste in Access.(mainly to make it easy for other person to maintain and understand)
I know more or less the tables that will need to be created.
My problem is how to store calculated fields in a table (I know I really shouldn't, but how else can I accomplish this), since all the costs and selling prices are the result of complex formulas.
If this information is not enough to understand my question please let me know.
Thank you for any help.
Emilio
View 10 Replies
View Related
Jan 22, 2005
Hi all,
I started a new thread, because it is a new subject even though is related to my Price List thread, I hope is OK.
If someone can please take a look at my attached Excel Price List (particulary the factors sheet) and give me an opinion of how my tables should be created.
I cleaned the Price List was too big to attach and it will be easier to be understood, in its entirety is kind of all over the place, exactly why I need to make simpler in Access for another user to update if I am not around.
I am below including what I think the tables should include, but not sure exactly how they should be, please be reminded that I am un unexperienced newbie.
----------------------------------------------------------------------
tblSuppliers
SuppliersID
SupplierName
SupplierCode
tblMarkup
MarkupID
MarkupName
MarkupAmount
tblTaxes
TaxID ------Do I need This?
TaxName
TaxAmount
tblExtras
ExtrasID
ExtrasName
ExtrasPrice
SupplierID
tblDiscounts
DiscountID
DiscountName
DiscountAmount
SupplierID
----------------------------------------------------------------------
Thanks for any help,
Emilio
View 6 Replies
View Related
Nov 2, 2005
I am building a database in Access which I would like to eventually link to my website in order to sell hotel bookings online. I believe I have set all the fields up properly but when it comes time to set the price I'm lost. Each hotel has about 3-5 different prices throughout the year depending on the date. How can I design a table(s) to accommodate this? Any help is appreciated.
View 3 Replies
View Related
