Search results

A Sku refers to 1 product here - like an identifier for each product anyways, I'm attaching a database here which contains just 1 table! The records look like this right now (as shown in the table). what I want is to list the products in order of when the QTY_ON_HAND is depleted. so...

Hi vbaInet! This is what I want to see: QTY_ON_HAND is the inventory we have right now w1, w2, w3 etc = number of products sold in each week (data is upto 26 weeks) I want the product skus in order of when the inventory is finished! for example, for the first product, the QTY_ON_HAND...

Hi jdraw! I'm attaching pictures of my the table and the query which I have so far. thanks!!!

Hi guys, I have been given this table which contains a list of products, the quantity of products - and the other fields are weeks from 1 - 26 - each week field representing how much orders are required. I have to find out by when each product's quantity will be finished! for example if...

thanks!!!!!!

Thanks again!! I will definitely post some questions in the table section to make sure I get it right this time. Yes, if you have any links - that will be great! the more stuff to read, the better understanding I suppose!

Thanks! will work on that

file attached!!

Hi, I have a query based on a table - this table has many fields, with each field representing a report. table looks like: ActivitiesID . . . .employeeID.. dte. . . report 1...report2..report3.. Now, I know this table is not normalized, and an obvious solution is to normalize is, but it's...

thanks again :) I did a similar thing, but added "date()" part in it to get the current week/day/year.

and if you want to change add the chart title and/or edit axis, then open the click property sheet on the pivot chart. under the first tab (which should be general), you should see "ADD" on screen's middle left. click that to add titles

I had a similar problem and I think this is how I dealt with (did it a while ago). open the query in pivottable view instead. Select "sum of 1" and then click Property sheet, and then go to second tab (which should be captions). try this. I'm sure experienced users of this forum will be able...

yea I didn't know anything about normalization and I guess I am learning the hard way :( hopefully, I will make proper tables in my next database application though. anyways, so the reporting code works fine. Weekly/quarterly/year to date data works as well. two things though: how do I get...

some of the fields are common - i wanted a separate table for each subform, and this seemed to work then :/

thanks vbaInet. I ended up working on it last week and here is what I did: I put =datepart("getinterval(), [dte], 7, 3) as the expression in the query. Then using Report wizard, I grouped on it and it worked :) just 1 offtopic question, If I have two tables, with the same fields (not the...

ok! I spent last 2 hours or so trying to fix it. the report opens, but I can't group it right. when I click "weekly" from the combo box - the report should display something like week 1 - - - 2010 - - - SUM of data (for that week and 2010) ------------ 2011 - - - SUM of data (for that...

I think I was referring to the wrong column in the combo box. I think I see what it is. I will post you back. thanks!

yes. That makes sense. Sorry for the late reply. anyways, I tried implementing what you had suggested. I made a copy of my database and just wanted to experiment it with 1 query and 1 report, but it gives me an error saying "the expression is typed incorrectly or too complicated to be...

I tried the sample, but couldn't get it working. any ideas of how to get this working, vbaInet? thanks

thanks! works :)