Search results

Thanks a lot!! You code works very well. As you mentioned the only disadvantage is that you can run it for a fixed number of records. I still keep fingers crossed someone can advise a more flexible method :D However if not definitely I go with your code. Really appreciate help.

@JHB Unfortunately, I am getting the same error message but I have to admit it sounded as a brilliant idea:D @namliam I am so sorry I keep getting error message: "Syntax error (missing operator) in query expressions ''. I noticed missing ; at the end so I added it but still can't get it...

Data and all calculations are in Ms Access. I use Excel only as an output file to retrive data from Ms Access

Hello! I am trying to concatenate multiple rows into one record. I googled it and found many functions in VBA that do the job. However my problem is that my query will be linked directly to Excel file and then I get an error message saying that Excel could not recognise this function. I could...

Many thanks for your help above. Is there any workaround? If I type the full calculation without any aliases it works fine but then it is not really convenient especially that some calculations are really long without aliases.

Hi, This drives me mad, I cannot sort below query in descending order by absolute value. If I do not use sort, all works fine but as soon as I try to sort by absolute value I get message to 'Enter Parameter Value'. I just cant understand why. I tried to replace Abs([Variance (W2 - W1)]) with...

Problem solved :cool: I missed a statment in Where to exclude blank rows :banghead: Thanks a lot for all help.

I dont. I checked Union and both tables and there are no duplications. The problem only starts when I join them together.

At the moment it shows the same record two or three times. So all values are the same but I get two rows with exactly the same values.

Hello! I have a problem with below query. It doubles some records. I kind of found the issue but I do not know how to fix it. Basicially I have two tables, which are Linked tables and they are linked to two Excel files. Each of the tables has almost the same information: Stock Number...

Hi plog, I have attached a spreadsheet that is currently filled manually. This is the end result I am trying to achieve. I used data from my sample database. I hope this illustrates what I am trying to achieve. The idea is to link the query to Pivot Table in Excel, so I can manipulate data in...

@ MarkK I cannot really redesign database if I do not know how to achieve desired outcome. At the moment I have two simple tables with three columns each. They look exactly like tables with raw data I have but as I said I cannot change tables if I do not know how they need to look like to get...

Hello, I have attached a sample of a database, which hopefully illustrates my problem well. Table 1 has all the items I am trying to sell with sell by date after which I cannot sell this item. Then in Table 2 I have forecasted sales. So now I am trying to calculate stock consumption to see if...

Hi Gina, Many thanks for your suggestion, it sounds like a good idea. I know how to do most of it but I am not sure about Complete (Yes/No) field and how to use it as trigger to either append or delete records? Would you be able to explain a little bit more please? Many thanks.

I have 3 tables: 1. with orders from customers, 2. with details about products like prices etc, 3. with supplier details like addresses etc I set up relationship beetween them and now I have query that links them both. I have created a form that submits parameters to the query, so I can get...

Is there anyone who would be able to help me with my problem? I know exactly what I need to do. I have only a problem with this step of my design.

If I have done it this way the table would be really big. I had to split data into two forms. I create a Sales Order Template. So there is some data at the line level like product codes, prices, quantities etc but you have also data at header level, like supplier name, delivery address etc. So...

Hi, Thanks so much for your prompt response. I use command button to trigger this on the form. And above is just the whole code. I know for sure that I will have more than one record each time. I tried to loop it but without any luck ;/ It is unbound form because some data are retrieved from...

Hello! I have a tabular form with many rows of records. Users add some additional information and now I would like to insert it into a new table. I tried to use below code and it works but it inserts only first row out of many. So I just wonder how to amend it to insert all data? Pls help :D...

I am still trying to fix it, so would appreciate any help I can get. Many thanks!