Search results

thanks to you, we finally know to avoid using date fields for grouping. We tried your alternate method. We added 2 columns (Year & Month) to the report source query, then sorted the report first by the Year, then by the Month, then by the Date. The group footer was for Month with an interval...

Attached is a snapshot of the report output. The date range entered was Feb-2009 to Dec-2009. In the Sorting and Grouping box, the first line has the date field with Footer = Yes, Group On = Month, Group Interval = 3, Keep Together = Whole Group. The second line (to force the rows into...

We need totals every 3rd record, not page breaks. And we need as many groups to show on each page as possible. The group footers are occurring at the wrong times when we grouped on the month with a group interval of 3 (especially the 1st group). The date range can start on any month. Would...

Basically, we want to sort by date and have a group footer every third record. We've tried at least a dozen variations, including adding a row number to the source data and grouping on that (Group On = Interval, Group Interval = 3). That last variation gave us a 3-record break at the start...

We have a report that shows monthly records (no day in date). It's based on a query where the user enters a date range (e.g. Feb-2009 to Dec-2010). We want the report to show the month records in calendar order, but group totals for each 3-month range (not the calendar quarter). But the...

One of the problems we found after a server crash was the loss of the mdb version of a database utility. We just have the mde. We need to be able to make improvements to the forms and reports in the database. Is there any way to create an mdb database from the mde database?

This problem was solved by physically cleaning the underside of the Office 2003 disc.

We have Office 2003 installed on our company PCs. Recently, we needed to add InfoPath onto several PCs. After putting the Office 2003 CD-ROM on a network drive and starting the install, we get a message about a CAB file that can't be found. Browsing shows that the file is definitely on the...

The filter is necessary - the start and end dates come from a form. We need to be able to vary the date range. That means the number of columns will vary each time.

In Access 2003, I have a crosstab query where the Column Headings are months found in a date field (formatted as "yyyy-mm"). The Row Headings are the Accounts. The Value column is the sum of currency values in the Paid field. The records are filtered to be those within a date range of another...

That worked. The other command let me specify acSpreadsheetTypeExcel9 to get the correct Excel version. Thanks.

I have to create an Excel spreadsheet from an Access table using a macro. The filename is constructed from textbox values in a form. In a custom function, I use DoCmd.OutputTo and specify acFormatXLS as the OutputFormat. But the resultant spreadsheet is an older version of Excel. I need the...

I have a large spreadsheet where B46 =AVERAGE(G42,L42,Q42). But if any of the values are zero, I want the average to ignore the cell (divide by 2 or 1 instead of 3). There's an Excel help topic on this situation that averages the range A2:A7 with the array formula...

We are running SQL 2000 Enterprise and MS Office 2003. We've defined a linked server to an Access database on our network. When the database opens, it runs a multi-step macro and then closes. We want this macro run every night, so how do we create a job to open this database?

We need to run an Access macro at 5:30 AM every morning thru SQL Server 2000 Enterprise. We've created a linked server (ForecastDb) to the database (Forecast.mdb) that has the macro (mcrForecast). But what T-SQL code do we put in the nightly job to run the macro? The macro runs too many...

A new report in Access 2003 worked on all but one person's PC. That PC displayed the error message "The expression is typed incorrectly, or it too complex to be evaluated". The data source for the report was a query. Since one of the query columns was for a currency field that was null in the...

We have 2 daily Access 20003 reports that have so much in them that we have to use legal-size paper to print them even in landscape mode. However, we can print them legibly on letter-size paper if we open the snapshot and click File, Print, Preferences, Advanced and then select Letter from the...

That For...Each approach looks promising. I tried turnning it into a function that would return the concatenated string of all the fieldnames and non-zero values. The idea was to make a query that would select each record in the table and output 2 columns: the Account and the result of the...

Lesson 4 shows how to get to various records in a RecordSet, but I need to know how to get the fieldnames and values of all the fields in the current record of the current database. Is there another lesson that shows this?

I have several Access 2003 tables where the first field is the Account Number and all the rest of the fields represent specific months. The number of months varies with each table. The names of the month fields are of the form "2006-03". The values in those fields is the amount that was paid...