Organizer Advantage is powerful yet easy to use database manager for Windows.
Advantage Designer lets you modify our solutions or easily create new ones.
Take control of your data with our simple or buinsess database software solutions.


 |  Organizer Advantage HowTo/Help  |  Designer HowTo/Help  | 


Advantage Help > Options > Custom Fields


Custom Fields Settings

You can use Company Info and Custom Fields in Calculated, Query-Edit, and SQL Query of Numeric, Integer, Text fields. The format is:
@:Y1, @:Y2, etc. for Custom fields.
If you want to use any Custom fields as numeric values in expressions, use @:NY1, @:NY2, etc. (N means Numeric).

Example

Enter tax value into the Custom 1 Field (7.5). Use Info to enter explanation about the value. In the Designer define TAX_RATE = @NY1

custom fields, use in calculations, how to refer to them

TAX_RATE = 7.5 %, TAX = SUBTOTAL * TAX_RATE

custom fields, define your state tax

 

Copyright © 2021 · All Rights Reserved · PrimaSoft PC