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

    Choose middle or different Value than First or Last in Query

    I have a query where I'm selecting the First value of a text field. Is there anyway in the query to choose either the middle value, or a specified value? In my group by - I have 5 fields... Shirt XS Shirt S Shirt M Shirt L Shirt XL I can choose First and the query returns Shirt XS in the...
  2. tortelvis

    Add Browse Button to Form

    I'd like to add a functional "browse" button so the end user could browse for a file to input. The full path would be returned to an input box on the form. Anybody know where to start? Thanks, Tort
  3. tortelvis

    Trying to populate form from query

    I have a form, where a user can enter a date range and click 'go'. This runs a sequence of query's that ultimately gives 1 record with 4 variables. (right now in a make table query) My question is - how do i get this record to then display on the form after its done running? If i add a...
  4. tortelvis

    Kinda Weird query....help!

    I have a table with three vars. Customer_Order, Item_ID, Seller I need to make a query that pulls only the customer_orders where seller has multiple entries per customer_orders. Something like this.... Customer_Order Item_ID Seller 10001 xyz 121212 10001...
  5. tortelvis

    How to pull first instance of ID into a table

    I have a table with duplicates, and I need help writing a query or sql statement that will pull the first occurance of an ID field and all the other fields with it into a new table. Anybody? Thanks -Tort
  6. tortelvis

    How to get RAS modem to surf the internet - Win2K server

    I have a windows 2000 server with two nics and ICS turned on. One nic connects to my broadband connection, one to my internal lan. Everybody on the lan can connect and surf out no problem. Now I am trying to add a modem to the server so a dial up user can access the internet. I have installed...
  7. tortelvis

    DHCP Clients cannot see the domain - static can

    I am setting up a windows 2000 server with Proxy Server 2 and two nics. I have not been able to connect to the server using dhcp yet with a win98 se client, even though dhcp is installed and configured on the server. As soon as I give the client a fixed ip and gateway to the server, it will...

Part and Inventory Search

Back
Top