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...
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
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.