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 derfloh 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: *

  1. chazgaz

    Sub-Report with Sub-Reports

    Is it possible to insert a report(as a sub-report) if it contains sub-reports? I currently have a profile page that has data displayed in a group header section and it also has 4 sub-reports. I have tried inserting the 4 sub-reports in various sections and everything I have tried works when I...
  2. chazgaz

    Search SQL Commands

    Is it possible to run a search on the crystal management console that looks at the sql commands for all scheduled reports? For example, if I have 500 scheduled reports on my server and let's pretend they all reference the same database table but the sql command is slightly different for all of...
  3. chazgaz

    Multiple Rows to Single Row

    I have a table that creates a new row of data each time an employees record is updated. In the example below, I have an employee that has been hired, terminated, rehired, reterminated, and rehired again. I would like for my query results to associate the employee terminate row with the...
  4. chazgaz

    ODBC - Tables vs. Queries

    I currently have 2 Access databases that are completely separate from one another. I have an ODBC set up for each database so I can run some Crystal Reports. My question is related to what fields are available to me when I make my ODBC connection through Crystal Reports. Database 1 - Only the...
  5. chazgaz

    Locating Duplicates and Flagging in another column

    WOW...It appears to work great. Thank you very much. I am very new to these types of queries and would have never come up with this. Thank you
  6. chazgaz

    Locating Duplicates and Flagging in another column

    I have a query which produces two columns called PKGID and ERPNO. The ERPNO field includes either a number or blank. The PKGID includes a number which can be duplicated numerous times. I have added a column called STATUS in which I have built an IF formula into that looks at the ERPNO column...
  7. chazgaz

    Locating Duplicates and Flagging in another column

    I have a query which produces two columns called PKGID and ERPNO. The ERPNO field includes either a number or blank. The PKGID includes a number which can be duplicated numerous times. I have added a column called STATUS in which I have built an IF formula into that looks at the ERPNO column...
  8. chazgaz

    Filtering Duplicate(s)

    I am looking for a way to filter a field (Batch Name) with duplicate entries based on criteria involving another field in my query. My database captures the time mail was received (in this case lets say 11:30) and a start time and an end time for various batches of documents being indexed...
  9. chazgaz

    Summing Time Fields

    I still get the data type mismatch in criteria expression error
  10. chazgaz

    Summing Time Fields

    This option states that I cannot have an aggregate function in the GROUP BY clause
  11. chazgaz

    Summing Time Fields

    I get a message that states that I did not include the specified expression Int(DateDiff("n",dbo_LogTable!TimeStarted,dbo_LogTable!TimeEnded)/60) & ":" & Format(DateDiff("n",dbo_LogTable!TimeStarted,dbo_LogTable!TimeEnded))as part of an aggregate function. Thank you again...I am also trying to...
  12. chazgaz

    Summing Time Fields

    Thank you everyone for your help but I am still stuck. Hopefully you all don't get sick of my stupidity. Here is what my SQL view looks like... SELECT dbo_LogTable.ScanDate, Int(DateDiff("n",dbo_LogTable!TimeStarted,dbo_LogTable!TimeEnded)/60) & ":" &...
  13. chazgaz

    Summing Time Fields

    I am having trouble with this solution. I am very new to access and I am trying to accomplish this exact same thing. I have a table that includes a start time and an end time. I have built a query that calculates the elapsed time. What / Where do I put this formula so I can sum up my daily...

Part and Inventory Search

Back
Top