Search results

:) That would be awesome but we have 20 different crews and 4000 pieces that are rotating. You got me thinking in the right direction though! Thank you for the help.

plog your correct i know the second record is a problem but it is created because i have a Check in form and a check out form. do you have any thoughts how i could have the checkin date populated on the same record? I origanly thought i could make a querey to get it somehow by using the...

plog TransactionsT Field1[TransDate], Field2[CrewName], Field3[EquipStatic], Field4[BarCodeN], Field5[DateIn], Field6[DateOut], 2/10/14, Joe, Out, F-01, Is Null, 2/1/14, 2/10/14, Joe, In, F-01, 2/10/14, Is Null, 2/10/14, Joe, Out, F-02, Is Null, 2/1/14...

Hi plog, When I first wrote the post the 3 records with the date 2/1/14 were all shifted to the right under the Date out record column but shifted over to the left when I posted it. What I can't figure out is the criterion in a query to recall only the transactions with a DateOut and no DateIn...

Top of the morning I had a thought about a new column in the query stringing the BarcodeNum and CheckInDate together, and anouther new column combining the BarcodeNum and CheckOutDate together. The I can make a query from the two new fields. Here's to hoping!

Help I am about 4 years into Access and love it. I am not extremely smart, but enjoy making this stuff. So why have I stopped lurking and signed on? Well to hopefully learn more. I have spent 2 weeks trying to figure this out to no avail. I put together a check in check out database. I think it...

Hi All, I have read many posts on your forum and don't know why I haven't joined a ways back. My name says it all. Pretty much self taught with the necessity is the mother of my need to learn. Plus i find this stuff is really cool. Kind of the more I learn the cooler it is. Thanks