i am trying to get records from Orders.ShipVia (Northwind database). i have a query in access that does exactly what i need, it returns the name of the shipper. in my aspx page, the exact same sql statement returns the shipper ID number instead of the name. any ideas on why its doing this? in the database you choose which shipper you want for an order from a dropdownbox, i assume it has something to do with this.
thanks in advance
Here is the entire sql statement:
SELECT Orders.OrderID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Orders.ShipVia, [Order Details].Quantity, [Order Details].UnitPrice, [Order Details].Discount, CCur([Order Details].UnitPrice*[Quantity]*(1-[Discount])/100)*100 AS Revenue FROM Products INNER JOIN (Customers INNER JOIN (Orders INNER JOIN [Order Details] ON Orders.OrderID=[Order Details].OrderID) ON Customers.CustomerID=Orders.CustomerID) ON Products.ProductID=[Order Details].ProductID WHERE (((Customers.CompanyName)=@strCustomers)