Search results for query: *

Guys, what can I say. Thank you very, very much for all your help. I've tried: Result=DMin("[COMP]![Factor]","[COMP]","[AGE AT 2002] >" & Age) and it works! :D LittleSmudge, I've yet to take my eyes off the chapter on ADO. It's tad confusing right now but the...

Guys, what can I say. Thank you very, very much for all your help. I've tried: Result=DMin("[COMP]![Factor]","[COMP]","[AGE AT 2002] >" & Age) and it works! LittleSmudge, I've yet to take my eyes off the chapter on ADO. It's tad confusing right now but the...

Kyle, the field [AGE AT 2002] does not have a standard increment. Neither does [Age]. FYI, I'm using Acess 2000. LittleSmudge, I've never done a recordset before so I'm catching up on the reading as I reply. Guys, I really appreciate both your advice and pointers. Helm.

Kyle, that is correct.

btt... Anyone? Thanks.

Michael, Can I safely assume that I copy and paste the above as a module and then type the following into the column in the query? Result:basAvgVal ([1997],[1998],[1999],[2000],[2001]) Thanks a mil.

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...

CosmoKramer, I'd actually found a solution on Microsoft's website using RAvg in a module. It worked the first time I ran the query but after that, Access kept crashing. I exported it into a new database and it ran flawlessly agin the first time round and then came the crashes. I coudn't get it...

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...

jacksonmacd, Thank you very, very much for your help. It works! What a relieve! This is the great thing about forums like this. It offers novices like myself a chance at understanding things with the help of pros like yourself. Once again, my sincere thanks.

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...