Search results

I have a big table and I use 3 queries to split it into 3 excel files. However, it looks like the 3rd query does return less records: 1st query: "ProductKey1" field = like "E" 1st query: "ProductKey2" field = is null 2nd query: "ProductKey1" field = like "F 2nd query: "ProductKey2"...

nevermind. My original query was wrong so I got bad result. It works now.

you are right with the algebra. However, I used that formula but then I did not get the result I wanted. I want to have the change % after the sum of price1/2 * qty. see below for an example: database productLn productcd shipqty price1 price2 A D 5 $2 $2.5 A E 2...

Hi, I have a database which has product lines, product code, ship qty, sales price 1 and sales price 2. I tried to create a query to summarize the data at the product line's level to look at the change % between (sales price 1 * ship qty) and (sales price2 * ship qty) . The initial...

Thanks for you guys' help! It works.

I have a text column which I want to remove the single qoute(s) in the records. What is the command to remove the single quote? E.g 1. Original data = 1,234,567 EA New data wanted = 1234567 EA E.g 2. Original data = 1,234 ROL New data wanted=1234 ROL Any idea?

I changed the 1st option's step 3 to be an append query and it works like what I need. Thanks!

For example, I have a make query to create a new table with 3 columns like below: col1 col2 col3 USA red skirt JAP red pant CHF blue sweater But I want a new table like this to include a primary key column ( It is similar to have a primary key column when import a table) : col1 col2 col3...

I got some lucks that the lines I revised yours are green color in the vba module. But now I have a few questions: a) I tried to execute the module but I got an message to ask me what the macro name is. How I can attach this module in an marco? b) I think I still miss the codes to set and...

I want to add a new primary key column (such as 1,2,3,4,5 and so on) when a make query is executed. Is it a way to do that?

Thanks for your codes! I will tackle the codes if I can make it work in my database.

I know very little about the code but will give it a try. I understand your step 1 & step 2 but not sure how the code should be for step 3. Would you give me an example so I can use it? Thanks for your help.

I have a big table to hold 12 locations' sales data. There are 4 different products in the table. Now, I need to transfer the table to an excel file by plant by product type for monthly review. In order words, I will have 48 excel files in total after the data transfers. What is the most...

It works. Thanks very much!

i am new to X2007. Where to press the "SHOW ALL ACTION" BUTTON?

I want to use the "SetWarnings" action in a macro but I received a message of "The text you entered isn't an item in the list. Select an item from the list, or enter text that matches one of the listed items". Any idea of an alternative way to do the same functions like SetWarnings in X2007?

this is a huge database with a size of 1,668,884KB. I compacted it to a size of 1,202,784 Kb after your advise. However, I still get the warning message of not enough memory and can't undo the action if I click yes to confirm the action. The query is to update query to update a table of...

i have a query to update a table of 360,0 00 records. Every tiughime I execute the query, I receive a system message that my pc doesn't have enough memeory to undo the action. What I do next is to click yes. It's kind of annoying. Is it a way to bypass or turn off the message?

your pc might need more memory to process the query?

Sorry to have doubt about your MID function. I use my MID function like that in Excel a lot so I thought the MID function would be the same in Access.