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

    Help with SQL

    Hi, I am trying to get the first delivery date for each order in a recordset that will have many orders for each customer and many deliveries for each order. I need to get the Customer details, the order details and show the first delivery date for each order. The Tables I am working with are...
  2. AnalystDBA

    Create View Statement in Stored Procedure

    Hi All, Can I use a Create View Statement in a Stored Procedure in Informix v7.31. I am trying to created the stored procedure and I keep getting a Syntax error. I can't seem to find the error and was wondering if it was the Create View statement in my stored procedure. Any help would be...
  3. AnalystDBA

    MS Access chewing up memory

    Hi All, I have an application in Access and sometimes I get a Windows message telling me that Resources are dangerously low and I should close uneeded programs. I have an AMD Athlon XP1800 with 256MB DDR Ram. Its not the quickest machine around but its not exactly slow either. MS Access just...
  4. AnalystDBA

    Convert Number to Text

    Hi People, Does anyone know of a function or have a function that they have created that will convert a number to its text equivilant. ie Number = 1240 Text = One Thousand Two Hundred and Forty Cheers, AnalystDBA
  5. AnalystDBA

    Nested Select Case

    Hi everyone. Simple question. Is it possible to nest a select case statement within another select case?? Cheers AnalystDBA
  6. AnalystDBA

    Can't open Sorting and Grouping window

    Hi All, Can anyone help with this?? It may sound stupid but I can't open the sorting and grouping window in report design view. I click on the sorting and grouping option on the toolbar and the report loses the focus but the Sorting and Grouping window appears to be hidden for some reason. I...
  7. AnalystDBA

    Subreport in report producing IPF

    Hi all, Can anyone help with this one? I am using Access 97 I have a basic report based on a static table in Access. I am trying to insert 2 sub reports into the main report to total data for each segment of the report (ie sales by territory,area and manager with a total for area and...
  8. AnalystDBA

    Incorrect Date Criteria in report

    I have an Access report based on criteria entered by the user. The problem I have may not necessarily be Access related. When I run the report on my machine the report opens fine with the correct information. When someone else tries to run the report on their machine the report does not return...

Part and Inventory Search

Back
Top