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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Page footer not displaying in grouped report
I have created a report with 2 grouping levels - FSID & Department. I labored long & hard to find code so that the page header and footer would not display on the initial page of each FSID grouping. My code nearly works...except on page 2. Below is my code: Private Sub...- kellbell
- Thread
- Replies: 4
- Forum: Microsoft: Access Reports
-
Way to allow different formats for different records in same field?
Hi, I am working on a database that's main purpose is to output financial metrics. My problem is that not all metrics are formatted the same. For example, Advertising as a % of Gross Profit is a percentage, while Gross Profit per unit is Currency (with no decimal points). I have a table that...- kellbell
- Thread
- Replies: 14
- Forum: Microsoft: Access Modules (VBA Coding)
-
Date inserted to table does not match value of SQL stmt
I have written code to update the [Date] field of a table. According to Debug.Print, my SQL statement appears to be retrieving the correct information, but when I open the corresponding table, the date entered does not match. My code is strSQLUpdate = "UPDATE tblTotalDealerMetrics " & _...- kellbell
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
Proper syntax for variables in SQL statement
I am working on an access database where my queries are performing multiple calculations for financial analysis. In order to do these calculations, I have used the DLookup function and assigned the result to a variable and then performed calculations with these variables to get the financial...- kellbell
- Thread
- Replies: 8
- Forum: Microsoft: Access Modules (VBA Coding)
