Search results

Brilliant, thanks for your help

Hi Folks, I've put together a simple planning query that checks the number of times that different sized moulds are required each week over a period of time. The problem is that formating the week number it only uses a single digit for week numbers between wk 1 and wk 9. Then sorting by week...

Wow, I'm impressed that you managed to do so much in so few lines of VBA I really appreciate the help on this

This is easy enough to do on the Orders table, becuase it has the ship date in it. However, the product and component tables don't have a ship date. So I have to start with the table on the bottom of the three, e.g. components and then onto products before finishing with the orders table. My...

Yes, I want to delete the archived records from the older tables

Hi Everyone, looking for some help getting the code on this one right. I could probably get this to work on my own, but I am self taught and would probably not be able to achieve the result in the most efficeint manner. I've put together a simple database to illustrate what I am trying to...

That has hit the nail on the head, apart from having to adjust when the Week 1 begins in the year, I was able to transfer this no problem into my main system. Now I just have to repeat everything for frames accross the different product lines we are monitoring Thanks to all for you help and...

I really appreciate all the effort you went to here and your qryDataFrames table is almost right. The difference being on my production system, each frame being produced is setup in the office and when it's produced gets a tick in a yes/no field. I probably should have done this in the first...

Having difficulty with this one, can't get the columns to match up - I think it is becuase the week number from the original table is an actual date formated "ww", where as the week number from the new source is a number. Any idea how to convert the date into a number?

I've never used LEFT JOIN before, I'll give it a go Thanks

I've thought about using another datasource to create the table headings, but... 1. I'm not entirley sure how to do this 2. Would such a datasource require manually inputing each week with a new week number? I'm trying to avoid as much intervention as possible so that this system can run...

Looking for help on this one, hoping it's a simple solution for the more experienced users. I have a crosstab query that is part of a production report screen and we review this data on a week by week basis. From the Screen Dump in the attachment you will see that the query returns a count of...

I missed that, but still when I make those changes I'm getting the inflated production numbers What way have you built the second query?

Hi Arnelgp, just gettting back to this issue. I tired your suggestion and added an extra query, you haven't suggested differently, so I used the same data source for the second query and changed the date format from days to weeks. However, the results that I'm getting back are not correct - see...

But to use NZ do I not require to have an entry with a Null value? In this case, I don't have any enteries

The problem is that until sombody enters the completion of a Window on a Monday morning, there isn't anything to count. So the data for last week appears under the heading for this week.

There is probably a simple answer to this, but I can't find it right now. I have a cross tab query that takes the quantity of windows installed and tabulates them into quantities produced by week. The problem is that on Monday morning the first week column (20-32 in example) shos the total for...

I may have a solution on this; File -> Options -> Current Database -> Caching Web Service and SharePoint table -> (tick) Never cache Let's see what happens

Or in this case, not use cache. I'll see if I can get that to work - I only need one of the linked tables to operate in this way for the Dlookup solution to work

I can see where you are going with this, however, will it not just Dlookup data that is available in the cached linked table and carry on as normal