Recent content by amp

Thanks! I've got it going with only a few changes. The subquery was almost exactly spot on. I was confusing in the way I explained what I needed; the dates on the record should basically be the start (movedate) and the end date for when the item was in a particular location. I also found this...

I have an Access database that is used to keep track of certain unique items. It is important for us to know the current and past locations where each item was kept and when the item is moved from location to location. I have a table to keep track of this information. table Locations...

I don't need to worry about losing indication of precision in graphs as all of the values to be stored will be considered precise enough for simple comparison. For averages, max, min, and such, I don't need to know exactly how many significant figures should be in my answer as it is largely...

Having a problem storing signifigant figures in a table. Basically, I need to be able to store trailing zeros after a decimal point. The number of trailing zeros is variable from record to record. Example - I need to store the following: 25 25.0 25.1 25.10 25.100 While each of the two...

The problem is that not every move in the Location table has a move date. Previously, moves were recorded, but not dated. They also were not always entered in sequential order. With this query, when all the moves for a Product ID have no Move Date, the query will return a blank Location (even...

I have the following tables: Product: (parent table of products) Product ID Product Description ... Location: (child table of locations where products have been moved and dates) Product ID Move Date Location ... The product ID field is a left outer join between both tables (show all...