Search results

Sorry, formatting as in presentation; the way it is presented is important.

Hi folks, I wonder if some of you good people could point me in the right direction? I have attached a sample of part of a report I am trying to re-produce in Access and am struggling with. I have a query producing all the equations I need, so the numbers themselves are pretty...

Well, I'm guessing that if it's good enough for you then it will be plenty good enough for me. Thanks

That's great, I will get busy and test that this evening and see if I can make it work. I'm a million miles away from being live with this, so it's all learning and testing at the moment. Genuine thanks for your input. One more question. I'm currently using Access 2003, would it be smart to...

Brilliant! So if I have a 'JobID' table that can relate to customers that JobID table will re-load the data from any job I choose?

Yes, we want to be able to compare and report month to month. We need to keep it, not overwrite it, I'm just not able to do that. The history is important for running totals and overall yields etc. So we need to be able to recall it. I see immediately that there is a solution there in...

Yes and yes. It's sales and it changes all the time. We are just taking a 'snapshot' and reporting the consumption for a given period. What will happen is that we take last times data, move the closing stock figure into the opening stock field, add purchases and closing stock figures again and...

The Product Usage comes from a query on the Products table, and that data is always there yes. I've not progressed from there, but if I were to do the job again next monthe then it would just be overwritten yes. There is nothing being moved out of the database at the moment, only reports.

I haven't re-designed anything, nothing's changed so I still have the same un-resolved problem. Maybe I have failed to properly ask the original question? If so, my apologies and I will try again. I have multiple customers. What I do is calculate product usage through their business and...

Oh geez, where did I go wrong here? Did I ask the wrong question in the wrong place or what? Why so negative? Aren't forums supposed to be about sharing knowledge and solving problems? I thought I had done the right thing and been humble enough to parade my ignorance in the hope that people...

You see, I thought that this was where I was at. I have thought it through, sketched out what I am trying to achieve and not duplicated any bits of information. I have the tables that I believe I need; customers, jobs (sites), products, categories and sizes. I think that possibly the size...

I fully intend to take all advice offered, so normalization will happen as soon as I understand it well enough. The advice I have so far is for one product table, but I'm sat down here with a piece of paper and a sketch of what I think it should look like and can't for the life of me...

I looked up 'normalization' when you first posted, so again am trying to understand terms that are new to me. If a product table of that size is not an issue then I can see that one x product table would work; that's one issue cleared up. As far as the actual DB size goes, I don't think I...

Ok, setting aside my Excel logic and trying to understand databases, I will try and explain what I'm doing. I have many customers, my project is to report on product movements through their businesses. Their products, will be often times unique to them, either in name or cost/retail price. I'm...

If I was just trying to manipulate and store one set of data I would be pretty much finished by now I think, I've found the queries and forms logical and the calculations work as I expect them to; it's great once you get started. My trouble is in understanding how to deal with multiple sets of...

Ok, at the risk of throwing myself to the wolves, this is where I have got up to. I thought it best to take this one step at a time, and my logic was to get the reporting and data storage side working before I started trying to relate multiple customers to jobs. The reports that I can...

No offense taken, well not much, but I did search online and guess what I found? I can see that Access and Excel are very different and am busy trying to understand those differences. I can also see that it will be a long project and I'm not in any rush, we already have a solution but I can...

Hi Guys, thanks for a geat forum. I have read myself bug-eyed and learned heaps already, but I need some specific pointers. I'm just starting to develop an Access database application based on some Excel sheets that we have been using for years. What I have within Excel is many customers set...