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!

  • Congratulations Chriss 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: *

  • Users: tracy1234
  • Content: Threads
  • Order by date
  1. tracy1234

    How to work around 22 inch section limit?

    I am creating a survey form with many questions. My boss wants all of the questions to appear on one long form. I see that the detail section is limited to 22 inches long. How do I work around this to get all of my survey questions on one form?
  2. tracy1234

    How to include report name in database path?

    I'm tinkering around with a program to send e-mails from Access to Groupwise. The program (written by Dimitri Furman and found at http://www.mvps.org/access/modules/mdl0059.htm) creates an e-mail attachment and then let's me specify the path to the attachment. Right now I can attach my whole...
  3. tracy1234

    How to get last 30 days of records

    I'm trying to pull the past x days of transactions via a select query that's using a pass through. My select looks like this: SELECT [pt get fulfillment invoices].* FROM [pt get fulfillment invoices] WHERE ((now())-[pt get fulfillment invoices].[TRX_DATE]) >=[Past ? Days]; Past ? Days is for...
  4. tracy1234

    Problem with (select top 10...) placement

    I have one table that shows customer_name, item, qty_billed. I'm trying to return the top 10 items billed to each customer based on summing the qty_billed. Here's what I have based on danvlas' May 13, 2003 thread where he gives this syntax: "Select * From [My table] As A Where Mytotal In...
  5. tracy1234

    How to return decimal value in pass-through query?

    I'm using an odbc connection from MS Access to return data from an Oracle table. This table contains decimal values ex: 0.5. When I run my query outside of Access in Toad, the decimal values return correctly. But when I run the same query inside Access via a pass through query, the data is...

Part and Inventory Search

Back
Top