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 bkrike 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: Templar333
- Content: Threads
- Order by date
-
Another DLookup Q.....
Still working on my employee benefit query and thanks to you folks, I've come quite aways. The next thing I'm trying to do is this and I'm sure I got it all wrong.... Column in query requires an input from a lookup table [COMP] that has only 2 fields, [Age] and [Factor]. Taking another field...- Templar333
- Thread
- Replies: 12
- Forum: Microsoft: Access Queries and JET SQL
-
Average
Hi All, I'm working on a new query and this is where I'm stuck. The table that it draws info from has 5 fields that are actually employee wages for 5 consecutive years; 1997, 1998, 1999, 2000 and 2001. In the query, I'm trying to calculate an average for the 5 years BUT some of the fields are...- Templar333
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
-
Newbie with DLookup question.
Hi All, I'm new to Access so please bear with me. I'm creating a query (called PRDB) from a table (Members) which holds information about members. One of the field's is the 'Date of Birth'. One of the columns in the query is to be used to calculate benefits. The calculation to be perform is...- Templar333
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
