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. crystal0streaks

    Multiplying information 7 times

    i added a join between tblTerms and DISTRIBUTOR_MAILTO_BILLTO and the multiplication is gone. thank you so much! -crys
  2. crystal0streaks

    Multiplying information 7 times

    tblTerms has more than one record, it has 7. no, BRYANT INTERGRATED TECHNOLOGIES and CROW SECURITY are not repeated multiple times in the BILL_TO field of DISTRIBUTORS_MAILTO_BILLTO. this is why there should only be one of each company listed in teh query. this is the problem. -crys
  3. crystal0streaks

    Multiplying information 7 times

    tblTerms is strictly for the date manipulation. no links. "COMPANY" is the primary key in both "CUSTOMERS" and "CUSTOMERS_DISTRIBUTORS_MAILTO_BILLTO" i had to not link them so i could have two companies on one line with the addresses (example, i'm shipping out a package to one company, but...
  4. crystal0streaks

    Multiplying information 7 times

    everything is EXACTLY the same. checked it numerous times looking for differences. there should only be one line of each company. -crys
  5. crystal0streaks

    Multiplying information 7 times

    this is the SQL for the query... SELECT DISTINCT [DISTRIBUTORS_MAILTO_BILLTO].[BILL_TO], [Customers].[STREET], [Customers].[CITY STATE ZIP], [Customers].[PHONE], [Customers].[FAX], [Customers].[CONTACT], [DISTRIBUTORS_MAILTO_BILLTO].[REP], [DISTRIBUTORS_MAILTO_BILLTO].[INVOICE #]...
  6. crystal0streaks

    Multiplying information 7 times

    i looked at my data and plugged in some differences, but it did not work. anyother ideas? thanks for the suggestions! -crys
  7. crystal0streaks

    Multiplying information 7 times

    That worked to an extent. now it's repeating 3 times, not 7. and 'DISTINCTROW' did nothing. -crys
  8. crystal0streaks

    Multiplying information 7 times

    I have a query taking from a couple tables and queries, everything works fine, but the information is duplicated 7 times...how do i fix this??? -crys
  9. crystal0streaks

    Pasword and Hiding a Worksheet

    Thanks for the help and advise. I will take it all into consideration. Thanks again. -crys
  10. crystal0streaks

    Pasword and Hiding a Worksheet

    This is why I am trying to password and hide the sheets. But if this is not possible or will create more problems than it's worth, ok. thanks. -crys
  11. crystal0streaks

    Pasword and Hiding a Worksheet

    I probably should have specified, the worksheets don't have my clients information on them. They are price lists. I have three different type of clients, and they all have different price lists. -crys
  12. crystal0streaks

    Pasword and Hiding a Worksheet

    I am sending a Excel book to some clients and was wondering if it is possible to password protect a hidden worksheet. I would like to have 4 worksheets available, but only one visible. I will give specific clients passwords to open one of the three hidden worksheets. How can this be setup? I...
  13. crystal0streaks

    Combo boxes Linking to Other Data

    If the person orders more than 7 different items, a new order form (Invoice [Report]) will be made for him/her. There are only 7 slots on the Invoice (Report) so a new one will have to be made anyway. The 7 will not change, so we do not have to worry about that. That sounds correct...
  14. crystal0streaks

    Combo boxes Linking to Other Data

    ...prepaired) Current_Date Company Invoice# PO# Terms Due Date Rep Ship Date Ship Via Account# Special Instructions UPS Tracking # Shipping Quantity1* Description1* Description1b* Unit Price1* Hyperlink Past Due Paid *=Repeate to 7 I know this table is *really* scewed up according to the...
  15. crystal0streaks

    Combo boxes Linking to Other Data

    where's "the next column"?" In the same Table that we select the Model#, the very next column (to the right of the Model#). "I'm still not clear on what you want to do with the price information once you get it?" When I select the Model#, the price for the Model# will be filled in the Price...
  16. crystal0streaks

    Combo boxes Linking to Other Data

    I'm reading the document, but I'd still like to keep a dialogue with you, so to answer your statement... Unless there is completely different information stored about the different customer types, you should probably only have a single customer table with a field that determines if the customer...
  17. crystal0streaks

    Combo boxes Linking to Other Data

    You want to update Price based on what Model is selected?" Yes "What are the tables that you have that contain the Model and Price information?" Ok, this gets tricky, there are three types of customers I'm dealing with, SystemsInt, Dealers, and Distributors, and all of them can order the...
  18. crystal0streaks

    Combo boxes Linking to Other Data

    I'm still new to access and I've tried many things to automatically input data into specific columns and it hasn't worked. In my main table, I have combo boxes for [MODEL#] and I would like to have the combo box link to the [PRICE] column so it will insert the appropriate price. I have the...
  19. crystal0streaks

    Combo boxes and Lookup Tables

    I have a table that has combo boxes of [MODEL#] and [PRICE] how do I make it so when I select a Model# the appropriate price is automatically inserted in the [PRICE] column? I've been told I should do this with a Lookup Table, but when I use the wizard it creates a combo box like the one I...
  20. crystal0streaks

    SQL based on query

    A lookup table seems to be exactly what I'm looking for. Thanks for your help. -crys

Part and Inventory Search

Back
Top