Hi....I have developed a financial database for a university continuing education program to reconcile with the Universities system.
I have a table for forecast/annual budget and a transactions table that all the actual income and expense data is entered into.
I want to create a query that compares "budget" to "actuals".
The query works fine when it has "actuals" only
When I add the table with the "budget" all the numerical results go crazy...figures appear multiple times etc.
I would be glad to do this in a report, but can't get that to work either.