Replies

Thanks Paul-that’s what I did. Now I will have a master table of locations also. Thanks again

The warehouse locations are A1-01 to A1-55 up to A8-01 to A8-55; then “B” shelf starts and so on taking you up to Z1-01 to Z8-55. Every warehouse location spot is designed to hold a box. As boxes get taken off “is Null” for shredding that location opens up for another box. We refill all the “is Null” with new ones. If A1-03 to A1-10 does show up in the list “is Null or contains something in the contents field” then we have no idea that spots are available. I wish we did have a master table of locations. Thanks so much for trying to help with this

No the “location is not the primary key. Category,Contents, Location, and Storage date. I’m looking for any locations that might have got deleted in a append and delete query. There are over 14000 location spots. If we have boxes in A1-01 and in A1-02 and spots A1-03 to A1-10 are blink I want to be able to use that space.

Thanks Zeddy, I do have excel 2007

The table structure is the contents in box and the locations of the box is all in one table. The table fields are- Date sent to warehouse, Contents of what is in your box, Location of the shelf the box is in at the warehouse, and date that box can be distroyed. The contents in a box or that box location at the warehouse will never change. So the charts between 500-88400 will be located on shelf B3-28A until the distruction date. Thanks for helping me

I would like it to run a report on it’s own. I’m using access 2003. How can this be done?

I’m not sure how to write that
Result = DateOfDeath – DOB
would it be in the query or on the form that I’m using?
How do you even write that? Result:([DateOfDeath-[DOB]) this did not work for me I get a error

RetiredGeek thank you sooooo much–your the best

Column A contains Names–B contains addresses –and C contains Zip

I’m talking about forwarded messages I receive. Microsoft outlook 2003 is what we have

Does the main office send the 70,000 list of expired patients every week?

Yes the main office sends the expired patient list every week

I’m looking for people born on a specific date (including Year) In the database the year maybe wrote 01/01/1966 or 01/01/66

The ending balance is in column G and there are no blank cells in the midst of the data

I did the Size to Fit Form. I have sent a attachment of what it is doing

This word attachment might be clearer