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!

Register Log in
  • Congratulations Rhinorhino 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: databuilt
  • Content: Threads
  • Order by date
  1. databuilt

    Conditionally Supressing Duplicated Detail

    I hve a report that is printing detail records, including address information. I would like to suppress a field if duplicated ONLY while the customer name remains the same (and is supressed. Example: Customer Sales Zipcode Phone B. J. Gift Shop $150 19302...
  2. databuilt

    13 Month Crosstab

    I need to create a crosstab table that will take input parameters of {?BeginDate} and {?EndDate} for a 13 month period and display colum values for each month starting with the first column representing the month including the BeginDate. The date values coming out of the database are hybrid...
  3. databuilt

    CR9 quits unexpectedly

    I've run into some problem creating a report that previews and saves fine but when I close and try to repoen it, the program quits after a few seconds without any error message. The same query is used for other reports without a problem. I'm just swaping some column data and a group select...
  4. databuilt

    Grouping By Sum

    I want to group report results by a category code related to the sum of a field. Specifically, the query returns sales at a detail level. GF2 grouping is by Customer (with sum[sales]) I would like to have a GF1 grouping by volume category (0-100, 100-500, etc.). I have a formula which associates...
  5. databuilt

    Using LIKE operator in IIF function

    I am constructing a query for a form (and report) which has input parameters. One of the parameters is for the item number and the users want to enter partial data and return all matching items. The problem I am having is in scripting the criteria. I am using : For field: IBLITM criteria...
  6. databuilt

    Converting Date to Number

    Is there a formula function available that will convert a date (say, 4/14/2003) to it's Julian number (37723)? I am using an unput parameter of Date as a condition for a Julian date field. In SQL I can use CAST({?Date} as int). Does Access have an equivalent function? I am using Access 2000.
  7. databuilt

    Left join problem

    I have created a report that displays sales by Sales Rep By Category. I have been requested to modify it such that it contains rows for null sales data (i.e. a complete listing of categories for each sales rep showing actual or null sales). The SQL I am working with is below: SELECT dr.drdl01...
  8. databuilt

    Left /Right ?Join Grouping Problem

    I am trying to create a report where I am grouping sales data by a sales rep for a special promotion items. Under the sales rep, I want to show the complete list of promo items, even though the rep may not had had any sales. Here is sample of the query that returns the sales but when I group by...

Part and Inventory Search

Back
Top