Hi everyone, I'm Patricia, Lead Author for Access 2003 VBA Programmer's Reference.

Thanks for visiting the Wrox p2p forums.

We'll do our best to answer any questions posed about the book as well as questions on Access programming. We're all quite busy these days, so if it takes us a day or two to respond, please forgive us.

We'll do our best to answer all questions as completely as possible!

Thanks for visiting the Wrox p2p forums!



Patricia Cardoza
Outlook MVP

Lead Author, Access 2003 VBA Programmer's Reference

__________________
Patricia Cardoza
Outlook MVP

Lead Author, Access 2003 VBA Programmer\'s Reference

Can you please read my "Book's Audience" post?
Thanks

Terry Waltz

Hi, I need some help. I am a beginner.
Could you please look at the code below.
I am trying to write a simple function that will calculate a total record count based on a simple query (with two part where clause). The functions only half works. I get a result, but it is always the wrong result. It’s as if the second criteria in the where clause is ignored. Why would this be?
Thank you in advance for any help you can give.


Public Function f_work_count(artistID As Long, intWork_type As Integer)
Dim sqlString As String


sqlString = "select id, work_type, production_type, production from t_work_main where work_type = " & intWork_type & " and ID = " & artistID

Dim db As DAO.Database
Set db = CurrentDb

Dim rs As DAO.Recordset
Set rs = db.OpenRecordset(sqlString)

f_work_count = rs.RecordCount