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

    Excel and SQL 2000

    Hi. We are working with SQL server 2000. We have developed an interface in Excel (VBA) that returns a record set to a worksheet then moves that data into memory. What we actually want to do is return the record set directly to memory. Can anyone help with the most straight foward way to achieve...
  2. Sammy25

    Securing tables and queries

    Hi, we would like to secure the tables and queries data and design from viewing by particular group of people by assigning permissions. We have a form that queries the tables and display the results in a grid control. However instead of looking into the tables, we would like them to only be...
  3. Sammy25

    Huge sql query, very slow performance, pls help

    Would anyone know how well Access can handle large number of tables and handling the queries? Perhaps it's not the best database design, but I have with me a database that stores values for 42 variables (x dimension) by 267 variables (y dimension) by 8 units of time (z dimension). I need to run...
  4. Sammy25

    Access Report: How can I manipulate the data before it's being printed

    I have a query that queries multiple tables, and contains a calculated field. I am hoping to find a way where I can: 1. Change the forecolor of the field IF the calculated field = yes 2. Calculate the queried field by multiplying it by 10 3. After making these changes to the query, display the...
  5. Sammy25

    Query for two primary keys on same record

    Access 2000 Thanks
  6. Sammy25

    Query for two primary keys on same record

    Hi PHV. You still around? When we tried your suggestion (query below) we recieved the message "undefined function 'left' in expression". SELECT W7_Weighted_MeansTbl.Means, W8_Weighted_MeansTbl.Means FROM W8_Weighted_MeansTbl INNER JOIN W7_Weighted_MeansTbl ON Left(W8_Weighted_MeansTbl.ID,7)...
  7. Sammy25

    Query for two primary keys on same record

    Looks good. Will give it a go. Thanks PHV
  8. Sammy25

    Query for two primary keys on same record

    Cool. Example of our database is Field 1 Field 2 P1-I1-Y1 Data P1-I1-Y2 Data P1-I2-Y1 Data ..... The query result we aim to achieve Y1 Y2 P1-I1-(Y1&Y2) Data Y1 Data Y2 In the query result example above we have queried across...
  9. Sammy25

    Query for two primary keys on same record

    The primary key represents a combination of three seperate elements. However we are endeavouring to query for different combinations of any two of the three elements. For example, our ID consists of Year, Industry and Price and we want ot be able to display records containing either Price and...
  10. Sammy25

    Query for two primary keys on same record

    We are trying to query an access 2000 database for records belonging to two different primary key values for the same record in the result.

Part and Inventory Search

Back
Top