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!
-
Congratulations strongm 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: *
- Users: DukeofEarl
- Order by date
-
Fields from the Report recordsource
You also must have this field as part of the query behine the report. If its not selected it doesn't exist in the returned recordset. DukeofEarl- DukeofEarl
- Post #3
- Forum: Microsoft: Access Reports
-
Problem in Switching Import table to Link table
You have to delete all the tables in your client database, then import all the tables from the server. You can then use the tools->Add-ins->Linked Table Manager to update the server database. DukeofEarl- DukeofEarl
- Post #4
- Forum: Microsoft: Access Reports
-
Access 97 Report
That is correct. There are two calculated controls. The IIF expression is in the txtDebitControl andnthe txtCreditControl is unbound. Nothing calculates and of course it prints blanks in the report footer. DukeofEarl- DukeofEarl
- Post #3
- Forum: Microsoft: Access Reports
-
Access 97 Report
I am using a IIF function in a report footer to SUM negative and positive values. This isn't working. I reference the [Fielda} as follows: =IIF ([Fielda]< 0, Reports![Reporta]![txtDebitControl]+ [Fielda], Reports![Reporta]![txtCreditControl]+ [Fielda]) [Fielda] is part of the query and is...- DukeofEarl
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
