Search results

Hi again. I have created a query that seletcs customer data from from an orders table. However one of the main problems I have encountered is that the Post Code is wrong for town/city entered. Now is it possible to write a query that matches first 3 or 4 digits of a postcode and changes the...

Hi there, I have created 2 queries that when ran create a table with a list of orders ready to be imported to a text file. However I need some help on running a macro to export specific columns from the table into a text document. Anybody know how I can go about doing this? I have in my tables...

Thanks! Cheers fella

Is it possible to place in a post code if a space does not exist. I played about before and got my code to place a space between characters like this Left([ship-postal-code],Len([ship-postal-code])-3) & " " & Right([ship-postal-code],3) However this creates a problem, if a post code has a...

It worked fine! I do have one more question though, how do I filter out GB orders? Is there a 'NOT' function for the query?

I want to create a query that puts these countries into an ICS code Expr3: IIf([ship-country] DE, AT, BE,"CAI","ICS") however I do think there is something missing from this but not sure what. Could somebody help me please? thanks.

Expr3: IIf([ship-country] DE, AT, BE,"CAI","ICS") Something like that, not sure what the missing piece is, when query is run the other countries will be ICS and not CAI. Anybody have any ideas?

Your're a legend mate! :D It worked, Any ides on how to include the the EU as ASI and non EU as IST?

My UK orders will be different because if my first order its £20 to £40 this will be TRD, if it is £40 and more than TRDS. I hope that makes sense.

Codes never changed, because they're what we've created.

Okay my boss has requested that I create query based on price and country. For instance if an order is 20 to 40 pounds it returns a shipping code of TRD, if orders are 40 pounds and over it returns TRDS. This is based in the UK. However if an order is based in EU such as France this returns a...

Running a query based on todays date Hi, is it possible to run a query based on today. Basically I have a created a query that looks up customer orders and places them in a table to exported into a text file. However I do not wish for duplicate orders, for instance if I wanted to run my query...

Hi thanks, I have added it into the field, however the customer details with the quotations marks has not appeared.

A query to remove any unwanted characters Hi there, I'm wondering if it is possible to create a query with a select query to delete any unwanted characters. For example I created a query to select customer details addresses and names etc, however some of the addresses contain quotation marks...

Theres a .co.uk y'see that we wanna keep separate

well we don't I believe orders are split using the it, es, uk, de and fr. That part is fine, I was wondering which I would need to include in my new query to pull those Amazon.IT, FR, DE and ES into same table. So you've said I should use the OR function to pull the specific data from IT, FR, DE...

Okay I'm trying to create a query that pulls in data from an order report. What I wish to do is pull in customer orders from a Order Report that specifies on european orders. For Example I have set it up to pull in orders from "Amazon.it". I now wish to include an "AND" or "OR" or "IN" to pull...

Wont that mean I'd have to manually update each stock count when a customer buys a particular product? I can just somehow create an update query to automatically change the quantity of stock?

Okay this is very simple, I wish to create a query based on my sum to update my stock count. I have created a query that performs a sum of taking what was ordered and subtracting it from what is in stock. This returns a figure of how many are left, what I wish to do is take that figure and...

Nevermind I found it