Search results

here's some sample data: tblclient - id (primary key) - name - dob - phone - address - email - lstcontact tbltrans - transid (primary key) - id (foreign key from tblclient) - servicedescription - servicetype - price - expirydate (there's more fields in each table, this is only a sample)...

Thanks for the response. I forgot to mention that I already have those fields in my tables. I'm pretty sure I've got all the necessary fields. What i'm looking for is for someone to help with the actual code/expression that will go in the query. I want it to pull a clients records where...

my client table is called clienttable assume have 3 fields in there: clientid clientname clientdob -> short date field i want the query to only show me clientname and clientdob (no client ID) for clients with a birthday coming up in 30 days. I've searched this forum but none of the...

I'm building a database to store client information and I would like to be able to generate monthly reports that specifies clients for me to contact. I want the report to show clients with an upcoming birthday (within 30 days), clients whom I haven't contacted in over 60 days (i have a date...