Recent content by vennardk

any input at all?

Been getting this error message for the last few days and I am unaware of how to fix it. I am trying to run one query that does Quantity*Unit Price*Discount*Tax Tax is a query that is an IFF statement along the lines of "If ship State="MI" AND Product.Taxable="Yes", 1.06, 1" Here is my SQL...

The table is very simple: Design View: ID Tax Status Name Table View: 0 Tax Exampt 1 Taxable I looked at the relationship tables to see what this table does... It is a one to many relationship to the Orders Table. So [Orders Tax Status]. [ID] is linked to [Orders].[Tax Status]...

raskew, My first post had my edited code. Here is the Original code for Order Details Extended: SELECT [Order Details].*, CCur([Quantity]*[Unit Price]*(1-[Discount])) AS [Extended Price], [Order Details Status].[Status Name] FROM [Order Details] LEFT JOIN [Order Details Status] ON [Order...

First off, I need to say that I am trying to teach myself the ins and outs of access so I am still very new. I use the design mode for my queries. I realize a lot of experts use the SQL view but I can't quite grasp that yet. I am taking the northwind traders example and modifying it to work...

Ok, a little background. Each person in my database has a unique record. In each record I would like to make a history of purchases for that person. In a different database, I have records of all past purchases. However, I have no common relationship between the two databases. My thought is...

They are placing orders on a web site. Where can I learn how to write it into the website? I assume just search google for OScommerce forums?

I would like to know if it is possible to design something in access 97 to automatically update a table everytime someone purcheses product/s off my internet based store. I am using OScommerce New Zealand. I have put all the available products in an Excel sheet that I can simply import later...

Worked like a charm! Perfect! Thank you very much!

Working with Access 97 (willing to try your ideas even if your not sure! ) I have a query that calculates the distance between a Zip code entered and a list of cities. What I need is to sort by closest cities to the Zip. Here is my code. I'll explain what I've tried below it. SELECT...

Hey everyone, I am looking to do a few "complex" things. Please remember that complex is relative right? Anyways, I'll give you the background. I have an online store that uses OScommerce. It is ran by digiadmin. My thought is that I would like to keep shipping addresses and billing info on...