Search results for query: *

I have a form in Access that displays a record from a Data Entry table. I created a module that would select the record from the Data Entry table (as displayed in the form), and append it the Master Data table. I created a macro to run this module, and linked it to a button on the form where...

My manual states that a macro linked to a CommandButton control is located in the code module for the spreadsheet that the Commandbutton is located in. I want my CommandButton Control to activate a macro in my personal Worksheet (as the macro moves data between several different spreadsheets...

Hi, I have a crosstab report. It is breaking down the groups by sales regions. It is then reporting for each sales region the total (SUM) of the outstanding Accounts Receivable balances for that region, and the number (COUNT) of the number of accounts per region. I have also included the...

Hi, I currently have a MS Access table that gives a field value when it occurs for the first time but not subsequent occurrences - ie. the blank cells underneath, in the subsequent rows/records are assumed to have the same value as above. In essence I'm looking for a macro/global way of...

I have a situation where I want to find the first record that has a blank (or null) value (in a certain field), and then copy the value of the record right above it. Here is a sample type of data file: Order number Item Number Date Sold 1234 A 05/09/05 1234 B...

Hi, I have a Crosstab report that I created. It currently shows the following field in the shown sequence $ Total Count % of Total % of Count I would like it to display as: $ Total - % of Total Count - % of Count I have tried to manually move the fields, but that does not work. I...

Hi, I have a report that groups and summarizes sales by region. Sample data looks like this: Percent of Total Region $ Sales Sales Region A $ 1000 20% Region B...

Hi, I have a Crosstab report that I created. It currently shows the following field in the shown sequence $ Total Count % of Total % of Count I would like it to display as: $ Total - % of Total Count - % of Count I have tried to manually move the fields, but that does not work. I...

I am trying to create an Accounts Receivable crosstab report, where the columns are set on the number of days outstanding. For each record, I have a field that already displays the number of days outstanding for that record. I want to be able to group my columns into the following days ranges...

Record Selection Problem and IsNull formula I have a report that I am trying to create, but am not having any luck getting the Record Selection formula to work properly. The scenario (CR10 – Access Database) : My company has several different divisions, and each division sells the same...

I recently took a class from New Horizons for Crystal Reports - 10. One of the resources that they gave us as part of the class was a workbook and a CD with some sample files. I have a report here at work that is almost exactly the same as one of the lessons in the class workbook: When I use...