Search results

I'm using Access 2003. I need to embed in my macro, a command to export the select query data to an Excel spreadsheet. Is there an action or something I can use to accomplishe that? Thanks, Krazy (Bill) Kasper

Crystal Reports 10.0 - Summing-Grouping Problem Contract # 12345 has four machines (111, 222, 333, and 444) Contract # 67890 has two machines (999 and 888) Each machine has a “base amount” (e.g., Machine 111 has a base amount of 20,000) Each machine has multiple invoices (some have one invoice...

I have a formula in my Crystal Report as follows. It works fine except it doesn't identify records when Sum ({@ExcessUsageAsOfDecember31},{OptimizeIt.LeaseMasterContractId}) is NULL. I tried inserting IS NULL in several places but keep getting syntax errors. I appreciate it anyone can help me...

Using Crystal Reports 10 - I need to use a “formula” to calculate "Average Monthly Usage" for the past 12 months. My ODBC table.fields are: {FootageSummarySerial.FiscalYear} {FootageSummarySerial.FiscalMonth} {FootageSummarySerial.ActualUsage} My code so far is: IF...

I'm trying to split a name field in my ODBC table into first name last name and change the case to "proper". The table field {OptimizeIt.OrderRepName} is one field formatted as lastname, mi, firstname I started using the following code which gives me the last name but not sure where to go from...

The Order Rep Names in my ODBC table appear as: Lastname, Firstname OR Lastname, Mi. Firstname I need to change them in my Crystal report to appear as: Firstname Mi. Lastname When I do the same thing in a VBA report my code is: Function ParseFirstComp(OrderRepName) As String ParseFirstComp...

I'm trying to set a formula in my report (Crystal 2003) to show that when a date is greater then or equal to 1/1/2009 OR if the field is NULL to print "LSE" else print "NOT". I'm having trouble with the following formula as it doesn't like the ISNULL: IF {LeaseMaster.LeaseDispositionDate} >=...

Using Crystal Reports 2003 and accessing several database tables (via ODBC) I need to select all of the material ids associated with invoices that contain a specific material id. There are about 15,000 invoices that will contain approximately 70,000 material ids. (There is no restriction on the...

I need to change the EmployeeName field in my report (based on a query) to Proper case and change it from LAST, FIRST or LAST, MI, FIRST (Results should look like:John Q Smith). The name styles in the source table vary as some are LAST, FIRST, MI; others are LAST, FIRST. Also, some are all...

I have a Multi-Column List Box named List10 that is populated via a query (qry_OptimizeIt3). I’m looking to create three Buttons, one above each column that will re-sort the list in ascending order based on the specific column. For example: FIRSTNAME LASTNAME AGE John Doe...

I have a multi-column (3 columns) list box that works well to select one set of records or all sets of records (based on the first field in the list box). I need it to also select multiple sets of records (Multi-Select = Extended). I modified my code based on code I found on some Internet site...

Access 2003 – Multi-Column List Box – Select Multiple Items I have a multi-column (3 columns) list box that works well to select one set of records or all sets of records (based on the first field in the list box). I need to it also select multiple sets of records (Multi-Select = Extended)...

I am trying to define several categories of product (Parts, Bndl, E1, Ink, and Paper). The following are fields in one of my tables: MaterialId, MaterialDesc, and ProductHierarchy. I have the following VBA case statement that works well in my report. However, when I include two additional...

I really appreciate any help you can provide. Although I am only vaguely familiar with VBA I think my problem has to do with the way I am naming things or the “Select Case” statement in my code. In my report: The text box is named txt_MyPrice The Control Source is =mod_CreditItem() In my code...

I am a novice user of MS Access 2003. I’m trying to develop in MS Access 2003, a report I developed using Crystal Reports. I link via ODBC to several tables in a Data Warehouse. In my Crystal report, I define several fields which are calculations based on fields in one or more of the tables or...

I am trying to use the Unique Count function to count the records in my report, however for some of the records (those where the field = A) I want to count all of the records. Is there a modification I can make to the Unique Count function? Sample Records: Record1 A Record2 B Record3...

I have a report that pulls thousands of transactions. When I come across 2 transactions where every field is the same except STATUS, I want to select the transaction where STATUS = I. Can someone help me format this Select Statement? Thanks, Krazy

Using Crystal Reports X. Need to select data when the serial number within a contract changes, and only select the transaction that has a null install date. I believe the formula would be something like: Within ContractId If SerialId changes Then IsNull({InstallDate}) Else...

I need to report on a large selection of data elements (11,200). Crystal X give me an error message saying the array is too large. I tried breaking it up using the "and" and repeating the request (e.g., and {ServiceDetail.ContractId} in ___) with the next group of elements, etc., but then...

This is a tough one! Really need expert help. I have two Crystal reports, each one accessing a different set of tables. Each report is grouped by CustomerId. I can link the two sets of tables using the CustomerId field. Using sub-reports, I can have one report print following the first report...