Recent content by dutchbob

Hi IIkhoutx, Thanks for your information, I will check it out. I have encountered that Access2013 has discontinued some features that I really need for this problem, so I must find another way. (Maybe via Excel) Thank you for your time. Bob

Dear all, I am currently working on making an automatic report for my boss in which I must see whether new products really sell. So I have already done some work and I have figured out that I can make a graph like in the attachment. It is done by creating the graph with sales in the y axis...

Thank you! I wish you a nice day, problem solved.

This is excelent, but I only need an indicator that tells me which products are launched before and which after the set date. The rest is excellent.

I will try this, thank you. I am a rookie in Access, this is the first project with it and so far so good.

This query separates the data by looking for the productnumbers with selling data before 2013 SELECT [RoI Actual].[Number] FROM [RoI Actual] WHERE ((([RoI Actual].FiscalYear)<#1/1/2013#)); This query searches the complement of those data points and makes a list of the product number of...

Note that this is the outcome of two queries. I want those to combined, but also that they are distinguished. I hope that I am clear

After the separation the data looks like this, but combining them in one access table is the main problem.

Yes, managed to do it. I have here the "raw" data of the system (it is only a set of quickly made test data) and the outcome figure. Notice that product 4 in the dataset is the only product with a date after 2013, so sales data of that file are split from the rest and then combined within the...

I have an upload error, I states ivalid file. (this is the first thread that I've posted here)

How can I upload a spreadsheet?

Hi vbaInet, Thanks for helping me. I do not have a problem creating the graph itself, but I am trying to first split a table, values with first sale date before a certain value in one table and products with the first sale date after a certain data in a second table, and then combining the two...

I see.. Thanks anyway for helping me out so far.

Cannot post links, so must do it this way

I will make it somewhat easier, sorry to be so vague, but the entries are confidential and I have no way to make it clearer. I have filled the entries in another database that you can find here: dropbox. com /s/vou1a2tap2u0xt5/Access%20Forum.accdb?dl=0 Thanks in advance, Bob