Duplicate query results is extremely frustrating, but are they really duplicates ? When a record appears more than once, it could be that the record meets the query criteria multiple times or the output includes one or more one-to-many fields . The good new is, when you use the query as a filter in reports...

No I'm sorry to say I don't have an answer to the gas price crisis, but I do have good news about city names. Do you have slightly different ways of spelling the same city in your database such as North Pleasantville, N Pleasantville, and N . Pleasantville? Have you steamed "it's all...

If you are frustrated by looking at columns on records and wishing there was a way to remove them, your wish has been granted. Well, it has been granted in some areas including the Activity tab of records, Student Billing Detail tab of payments, the Line Items tab of an Invoice, and the Reports Page...

If your fiscal year ended June 30, you may suddenly start receiving errors such as Period Closed or Period Not Found when posting to General Ledger. These errors happen when transactions post to a hard-closed, soft-closed, or an undefined fiscal year. To resolve the error: Review the Batch Validation...