Search results for query: *

Hey Cheech thanks Is there a way to attach the javascript to the end of the image link I currently have which is simply the recordset value? <%=(Recordset1.Fields.Item("image1").Value)%>

I have a page which calls a recordset image. When you click the image the link is set to <%=(Recordset1.Fields.Item("image1").Value)%> so it opens up in a new window bigger. I want to know if there is way to attach to the link a java script which will add a close window behavior? Thanks. Steve

Hi and thanks in advance. I have a query, the works, and it basically shows the order information from a typical e-commerce database. Now when I run this query, and for this example lets say I am the customer and I order 3 distinct items in various quantity. Now when I run the query it shows all...

Ok your right OrderReferenceID is text and DetailOrderID is number so now how would I need to write this: SELECT DISTINCT DetailOrderID, OrderReferenceID, UserID, OrderUserID, DetailProductName, DetailQuantity, DetailPrice, OrderShipping, OrderTotal, OrderDate, Firstname FROM Orders o...

Not sure I understand in what capacity?

Getting closer, but now when I test this I get type mismatch in expression??? SELECT DISTINCT DetailOrderID, OrderReferenceID, UserID, OrderUserID, DetailProductName, DetailQuantity, DetailPrice, OrderShipping, OrderTotal, OrderDate, Firstname FROM Orders o, OrderDetails d, Users u WHERE...

I want this query to show the unique orders per persons firstname, which in this case happens to be the full name I have 3 tables Users, Orders, OrderDetails. SELECT DISTINCT DetailOrderID, UserID, OrderUserID, DetailProductName, DetailQuantity, DetailPrice, OrderShipping, OrderTotal...

You guessed right Jerry, and now shows the top row of the query but no data? Under OrderID it says AutoNumber??? Hmmm. Thanks for your help with this.

I dont get an error but when I switch to preview the query it doesnt display any data and there are records and relationships. Steve

What am I missing here? SELECT OrderID, DetailOrderID, OrderUserID, DetailProductName, DetailQuantity, DetailPrice, OrderShipping, OrderTotal, OrderDate, Firstname FROM Orders AS o, OrderDetails AS d, Users AS u where o.OrderID = d.DetailOrderID and o.OrderUserID = u.UserID

I have an online web database IIS server, with and access e-commerece db. I wanted to know if I could connect to this database via excel to extract data as need be? It is a web server so read permissions are off for the database so New Web Query will not work unless there is something I missed...

Thanks Skip I tried that but when I try to map to the database throught the url I get access forbidden read access turned off. Steve

I have an online web database IIS server, with and access e-commerece db. I wanted to know if I could connect to this database via excel to extract data as need be? thanks for any help with this. Steve

by why = 10?

Can the where criteria be where the order id lets say = order detials id? Thanks. Steve

I have a e-commerce relational access database. I have to create a query that uses 3 tables Orders: OrderDetails: Users: The orders table has a one to many relationship with the ordersdetails tables as such: orders 'OrderReferenceID' & orderdetails 'DetailOrderID' And the users table has a...

Hey thanks for your help on this. btw. I got the following error messages at this line . Microsoft ODBC Microsoft Access Driver Syntax error in query expression (o.oderreferenceid = od.detailorderid) inner join users us on (o.orderuserid = u.userid)

I have to create a view that uses 3 tables Orders: OrderDetails: Users: The orders table has a one to many relationship with the ordersdetails tables as such: orders 'OrderReferenceID' & orderdetails 'DetailOrderID' And the users table has a one to many relationship with the orders table as...

The table names in your statement look correct.

The table names in access are Orders, OrderDetails, Users in access.. Thanks. Steve