Organizer Advantage is powerful yet easy to use database manager for Windows.
Advantage Designer lets you modify our solutions or easily create new databases.
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
easy-to-use database manager and database designer for Windows
- Organizer Advantage
- Getting Started Videos
- Main Window
- Tabbed Toolbars
- Add Data
- Reports
- Labels
- Search, Replace
- HTML Reports
- HTML Wizard
- Import, Export
- Backup, Restore
- Options
- User Interface
- User Interface 2
- Color Styles
- Maintenance
- Email Setup
- Company Info
> Custom Fields
- Multi-User, Login
- How To .. - Statistics, Views
- Templates
- Add-Ons
- Install, Network
- Web Search, Add Data
- Premium
- Upgrade, Update
- Organizer Deluxe, Pro Users
- More
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
TAX_RATE = 7.5 %, TAX = SUBTOTAL * TAX_RATE
Copyright © 2024 · All Rights Reserved · PrimaSoft PC