Search results for query: *

Thanks! I just embedded a new query within my query to grab the top 3, then pick the last one in my query - brilliant. -Tort

bump

That would work for this particular instance, but my database is actually an Item Table with over 200,000 unique items. Another Item group might be Pants XS through Pants XL. I need to always return the 3rd value (most likey "item M", but not always). Thanks, Tort

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

OK....Got it to work. Now how do I pass the variable strInputFileName back to a box on my form? Here is the call that grabs the file: Dim strFilter As String Dim strInputFileName As String strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)", "*.XLS")...

Woa, lots to comprehend. Were would this code go exactly? In a Class Object maybe? or a Module? The error I get is 'Cannot define a public user-defined type within an object module' Where would it go? Tort

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

Worked like a charm! thanks.... One question... the Me! - what does that indicate? Or can it be anything as long as its consistent. -Tort

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

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

Thanks, The Select Distinct did it - i was looking for a way to grab unique occurances of several fields. -Tort

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

Tried that too....no good. might try it on a 98 machine to see if that helps.

Did that - no good. It cant seem to route through to the external nic on the 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...

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