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: paula
  • Content: Threads
  • Order by date
  1. paula

    Changing strings to dates

    I'm working with a report based on a SQL view set up by one of our 'experts'. For reasons only known to himself, one of the fields (MOD_DATE) has been created as a string (DD/MM/YY). The appearance on the report is suitable for my needs (date is in English format), but obviously can't be...
  2. paula

    Changing data type from string to date?

    I'm working with a report based on a SQL view set up by one of our 'experts'. For reasons only known to himself, one of the fields (MOD_DATE) has been created as a string (DD/MM/YY). The appearance on the report is suitable for my needs (date is in English format), but obviously can't be...
  3. paula

    Embarassingly basic question

    Here's a nice easy one for you folks... Somehow I've managed to work with Crystal Reports for some time now, without having to involve myself with or understand SQL or SQL servers (or even much about relational databases. Until now. I'm now trying to develop reports based on complex SQL...
  4. paula

    How to display records when one field is empty?

    My report looks something like this (based on a SQL database - knowhow items records): Title Created Date Created By Assigned To Some records will hold data for 'Created By' but not 'Assigned To'. Where this is the case, the record does not show in the report at present. I...
  5. paula

    Crystal, SQL & aliases

    Bit of a long shot, this one! I'm having problems getting the information I want from linked tables (knowhow/research database on a SQL server). Table 1 holds most of the obvious record fields (e.g. item ID, title, date added, added by ID etc.). However, to get the full name of the person...
  6. paula

    Crystal, SQL and using alias tables

    Bit of a long shot, this one! I'm having problems getting the information I want from linked tables (knowhow/research database on a SQL server). Table 1 holds most of the obvious record fields (e.g. item ID, title, date added, added by ID etc.). However, to get the full name of the person...
  7. paula

    Groups in Cross Tabs?

    I need to create a simple report based on monthly totals, in the following format: May June July August Total Records added: 12 10 56 23 Unfortunately, each record added to the database concerned only has an individual date, so I need...

Part and Inventory Search

Back
Top