Exploring the field properties

In the previous movie we took a look at how we can apply aliases to our column…headers to be a little bit more specific about the types of data that we're…returning in our queries.…Now, we can go into our qry_Products one more time and we can see the saved…aliases that we created in the last movie.…Now, I'm taking a look at our table here that's being returned by this query and…I'm noticing a few other areas that we can clean this up.…Let me go ahead and maximize this.…And let's take a look at retail price.…Now, I know this is supposed to represent a dollar value, but our decimals…are all over the place.…We've got 2 decimals here, we've got no decimals here, and we've even got values…that have only a single decimal.…

So I want to clean that up a little bit.…Same thing with Markup $, and Markup % actually has a different problem here.…Right now we're saying this as a percent, but it's written as a decimal fraction.…So for instance, we've got our Wholesale Cost of $10, our Retail Price is $15,…which represents 150% markup, but we're multiplying that by 1.5, so this the…