Search results

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...

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...

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...