MySQL Forums
Forum List  »  Microsoft Access

Advanced Search
New Topic

Re: formulas in forms to mysql
Posted by: joe lobocki
Date: June 28, 2006 08:45AM

ok, two questions:

how would i make it decimal in a view? and


CREATE VIEW `book`.`view` AS
SELECT Description, Size, Pack, List, Net, Discount, NetBtl, SRP, Vendor, Date, (SRP*NetBtl) / SRP as GPM FROM products;

is my query, (SRP*NetBtl) / SRP is the formula, but it wont do it in order of operations like it was doing in access, am i missing something?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
formulas in forms to mysql
6216
joe lobocki
June 07, 2006 10:03AM
Re: formulas in forms to mysql
2571
Bob Field
June 07, 2006 10:13AM
Re: formulas in forms to mysql
2052
joe lobocki
June 12, 2006 10:30AM
Re: formulas in forms to mysql
2017
Bob Field
June 12, 2006 01:06PM
Re: formulas in forms to mysql
2026
joe lobocki
June 20, 2006 09:30AM
Re: formulas in forms to mysql
1894
Bob Field
June 20, 2006 11:42AM
Re: formulas in forms to mysql
1967
joe lobocki
June 22, 2006 07:12AM
Re: formulas in forms to mysql
1900
Sebastien Caisse
June 22, 2006 07:33AM
Re: formulas in forms to mysql
2035
joe lobocki
June 22, 2006 08:32AM
Re: formulas in forms to mysql
1899
Sebastien Caisse
June 24, 2006 05:19AM
Re: formulas in forms to mysql
1892
joe lobocki
June 26, 2006 08:46AM
Re: formulas in forms to mysql
2024
joe lobocki
June 26, 2006 10:06AM
Re: formulas in forms to mysql
1942
Sebastien Caisse
June 26, 2006 12:51PM
Re: formulas in forms to mysql
1987
joe lobocki
June 28, 2006 08:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.