Search results

That correct...thats where my logic was off... it is simpler to sum and them find the percentages.. thanks guys!

ok guys i need help figuring out something here.. i am trying to incorporate this into a formula in a form in the retail industry we all determine profitability based on gross margin % and $.. example if an item cost $250 and you sell it for $599 you can take 250/599 = .417 which tells you...

quick question guys... if i have a sales order that the sales order # is an autonumber and i manually delete the records my next new record still follows the last number i had before that is now deleted.. example sales order 1001 sales order 1002 if i delete all the records on the table and...

quick question guys... if i have a sales order that the sales order # is an autonumber and i manually delete the records my next new record still follows the last number i had before that is now deleted.. example sales order 1001 sales order 1002 if i delete all the records on the table and...

email sent..thanks

..thanks in advance for any help.. the file zipped is about 1.94 mb.. i cant attach it here... can i email it to you?

i havent been able to figure out how to get my subform to work properly.... i've posted in the forms section (http://www.access-programmers.co.uk/forums/showthread.php?t=99624 ) it is really important that i figure this out so that i can keep my job.. how else can i obtain help? even if i have...

anyone? :(please help

hey guys i been working on this issue for a long time and still cant figure it out...please help me out if you can.. i have a inventory table that stores items, a customer sales table that stores customer information. i have a form that i named the "sales invoice" it stores and gets the data...

Thanks...makes sense...

if i have formula in a text box can that calculation be stored in a table??? example sales total sales tax grand total where grand total = sales tax+sales total if the control is bounded to a field in a table once the formula is entered doesnt it loose the connection with the field...

If in a form i have a box that calculates something i cant change that..is there a way around it? for example on a sales invoice consider the following fields.. sales total sales tax grand total grand total=sales total + sales tax... but what if i want to change it?? not the formula.. but...

i am looking to have something similar done...anyone?????

i still cant figure out how to get it all done.. i am fairly new to access:o

this is what i would like it to look like...or something like that

I have an Inventory table that keeps records of goods. It includes [manufacturer],[Quantity],[Cost],[Item #], Description],[sold to #] and so on............. Then I have a Sales Table that controls the customer's data such as [sales order #][customer name],[address],[sales date],[tax],[unit...

i would be interested in something like this too

hello everyone.. i am newbie to the site and its been pretty cool so far... so what do you guys do for fun? I enjoy drag racing and autoX with my car....:cool: when i need to relax i go fishing, and i enjoy playing basketball and other sports.. I recently sold my motorcycle since its time...

I am creating a database for sales purposes. It has an iventory table with a form that controls it and a Customer table with a Sales Form that controls it. Now I created a subform based on the Inventory table that will be on the Sales form. It sort of works but not the way i want it to work...

wow...that simple! hahaah.. thanks a lot.. i most have accidently clicked on it before.