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

    Ack! Same query with different results on different computers!

    I open two copies of the same exact database on two different computers. The tables and queries are identical. There are two nested queries. The first query merges two large tables - a 1st half 2001 and a 2nd half of 2001 with data by month. It merges them by first finding all possible key...
  2. nnaacc

    How to use group selection

    I have a report set up using record selection, and it can query for one customer at a time based on 2 parameter values: the customer name and the sales person. The customer could be a buyer or seller so my record selection has an OR statement: ( ({Orders.buyer}={?Cust} and...
  3. nnaacc

    Convert Report from table 0401 to 0501

    I've got a report that uses 2 tables, one of them twice. They are linked, with multiple selection formulas, formulas, graphs, etc... Both of the tables end in 0401 for April, and I need to switch them to 0501. Is there a quick way to do this? It seems I have to add the 0501 tables, edit the...
  4. nnaacc

    IIf in a formula field and Group

    I'm using CR 8.0 I've got three tables: buyers =* orders *= sellers Every order has a buyer or a seller, but not always both. I filter for a certain client - either as a buyer or seller. I need to sort by the client order type, which is located on the buyer or seller table (depending on...
  5. nnaacc

    Record Selection problem

    I'm having a heck of a time with nested record selection formulas. I've got on 3 linked tables - Buyers =* Orders *= Sellers I need to display all orders which had XYZ as a buyer or seller, and only info from the -1 version of the buyer or seller table. The problem I'm having is: how to...
  6. nnaacc

    Making periodic updates to a shared database

    I've got one database with all the tables and a database password, and another with queries, forms and reports that is secure with users and groups. I'm about ready to give about 100 people access to the database... and a little nervous to see how it will work. One problem I already forsee is...
  7. nnaacc

    Filter form records using subform

    I've got a form of firms, with two subforms - contacts (one to many relationship) and mailing lists (one to one relationship).<br> <br> I can filter records on the form, and the subform records are filtered.<br> <br> When I filter using a field in one of the subforms, that subform is filtered...

Part and Inventory Search

Back
Top