Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
FIFO inventory calculation
Hello all, I need to design a simple inventory system based on the FIFO (First In First Out) principal. Currently I have an excel spreadsheet that gives the resulst I'm looking for but would like to bring this into Access. Where I'm having trouble is translating the excel calculations into...- RonAle
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
-
Return Previous Date
Hello, I'm basically trying to return date before the DMax date. for example if My table has a date field with these values 1. 4/25/07 2. 4/22/07 3. 4/19/07 4. 4/12/07 how would I return the value 4/22/07?- RonAle
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
Calculating growth rate in Cross tab
Hello all, I'm able to do a simple crosstab query with Category and Year as row headers and Quarter as column header. I also added a column that provides Grand total for Year. Where I'm stuck is trying to compute year-over-year growth for total year and for each Quarter compared to same Quater...- RonAle
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
