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 Chris Miller 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. mykebass

    Oracle Recordset

    You're a bit of a smart-arse, but I did test out your solution and it was much faster. Thanks for the advice.
  2. mykebass

    Oracle Recordset

    I would not be opposed to that solution, but I'm trying to determine if that method is any faster than the above code?
  3. mykebass

    Oracle Recordset

    Our team is attempting to retreive data from an Oracle 9i database via ADO connection and write its contents into an Access table (for further manipulation). At present, we do not have access to create a stored procedure on the server, so that is not an option. Question is what is the fastest...
  4. mykebass

    I want to print for each change in my grouping

    All, I've done a search and had no luck. I have a simple report grouped by a value. I would like to print each group on its own report. Is that possible?
  5. mykebass

    Group and Sum

    I've actually tried this, but I get prompted for the parameter value of the field I'm attempting to sum on the report.
  6. mykebass

    Group and Sum

    Hi. I have a report in which I group by Date and Market and I would like, on the same report at the end, sum the totals of only the markets. For example the report is currently like this: Group 1: Date: 3-27-05 Market: Chicago 500.00 Market: Denver 250.00 Market NY 100.00 Group 2...
  7. mykebass

    Is Null with Between

    1) you are checking for Null by subtracting 2 dates - is this right ACtually, no. The - sign in this case acts as an OR statement. I'm stating that if A or B textbox are null then criteria should just be * (give me all records), if false criteria should be between A and B textbox. But just...
  8. mykebass

    Is Null with Between

    Hi. I'm using the following in a criteria, but Access just hangs. Any thoughts what I'm doing wrong? IIf(IsNull([Forms]![frmMain]![txtbegdate]-[Forms]![frmMain]![txtenddate]),*,between [Forms]![frmMain]![txtbegdate] and Forms![frmMain]![txtenddate] )

Part and Inventory Search

Back
Top