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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: arman28
- Content: Threads
- Order by date
-
organised data structure
I have two table Import and Export. They have multiple columns but I have picked Import Style(I_S), Import Color(I_C) and Import Quantity(I_Q) as well as Export Style(E_S), Export Color(E_C) and Export Quantity(E_Q) to show what I want to accomplish. The tables have no PK or FK and the only...- arman28
- Thread
- Replies: 16
- Forum: Microsoft: Access Queries and JET SQL
-
sort matching data in ms access
I have two Import and Export tables as shown below; Import |Style | Color | Qty | --------------|-------|------ 1/2/03 | A201 | Red | 100 1/9/03 | A201 | Red | 20 1/4/03 | B204 | White | 80 1/7/03 | A201 | Red | 100 1/1/03 | C102 | Green | 100 Export | Style |...- arman28
- Thread
- Replies: 22
- Forum: Microsoft: Access Queries and JET SQL
-
how to summ similar items
This is what I am trying to do.. Import Date | Shoe Style | Shoe Color | Quantity | ------------|------------|------------|----------| 11/20/2003 | A2003B | Red | 100 | 11/19/2003 | A2003B | Red | 20 | 11/20/2003 | A2005B | White | 80 |...- arman28
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
