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

    Export multiple queries to one Excel file

    I have 4 queries that I want to export. I want them to be 4 tabs in the same Excel file. I want to do this in a macro (a form has a command button that will run the macro). I found a few options for exporting in the macro commands, but none of them want to add a tab... they all want to...
  2. jcmeyer5

    Form control as query field

    I have a form that I enter information into a table. I want to calculate 2 queries based on the current record in the form. I have the whole "using the control as criteria in a form" thing working for me. What I want to do is mark the records with a report ID. The report ID is an autonumber...
  3. jcmeyer5

    Leaving subform based on value

    I have a subform within a form. This form is good for entering accounting records. The form is HEADER, the subform is DETAILS. In DETAILS there are accounting transactions. In the accounting world, debits (positives in my case) and credits (negatives in my case) need to net to zero. I dont...
  4. jcmeyer5

    Counting order values below a certain amount

    I have a table I created with a make-table query. It has 4 fields. Order Number - Ship Method - Catalog - Amount I want my table to look like Ship Method - Catalog - count of orders $25.00 and under - count orders $25.01 to $50.00 - count of orders $50.01 to $100.00 - count of orders $100.01...

Part and Inventory Search

Back
Top