Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. detwings9

    comparison statement

    I'm having trouble figuring out how to get a field built in a query. I want to compare one field in the query with another and have the result show the lower value. Any help would be greatly appreciated. I guess there is no IF [Expr1]<=[Expr2], then [Expr1], else [Expr2] I hope this explains...
  2. detwings9

    Autonum Starting Point

    Is there a way to set the starting point for an Autonum attribute above 1. I would like to have it start at 10000
  3. detwings9

    Fields keep rounding?

    I am setting up a database with 2 number fields. I will need to do calculations with these numbers later. I have them set as fixed with 2 decimal places. Everytime I enter data into the fields, it rounds them up or down to whole numbers. How can I get this to stop?

Part and Inventory Search

Back
Top