Easy birthdays question...

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

I have one table in my database named, Clients. It has the following fields: FirstName, Surname, Address1, Address2, Address3, DOB, and LetterSent.

My question is, how do I show all the clients who have a birthday coming up in the next 7 days?
Once I have that information displayed, the user is then supposed to put a tick the LetterSent checkbox for each client.
Then, say the query was run later that day, the clients who appeared in the query earlier on would now not appear as they have a tick in the LetterSent field.

So I think I need something like this, I just don't know the correct syntax!
SELECT Clients.FirstName, Clients, Surname, Clients.DOB As UpcomingBirthdays
WHERE Clients.DOB = Between today and 7 days from today
AND Clients.LetterSent Is Not Ticked


Sorry for the n00b question!
Thanks,
Paul


.

Relevant Pages

  • Re: Accessing query fields from code with in a report
    ... At the deepest level, if a client can have multiple addresses, there seems to be a one-to-many relation between clients and addresses, so it might be a good idea to put the addresses in a related table. ... The addresses table will have a field indicating the address type, and another field indicating the priority, and your query will draw the top 1 preferred address of the right type for the client and feed it to the report. ... I have a mailing label form where I have to access Name1, Name, Address1, ...
    (microsoft.public.access.reports)
  • Re: Name parsing routine
    ... 'Joe Anderson ... free-entry name fields into title, first name, middle name, surname, ... after values in a structured report, and get the clients to distribute ...
    (microsoft.public.vb.general.discussion)
  • Re: Naming Standard conventions for NT Groups
    ... Most clients use peoples names either as [firstname, surname] or [surname, ... One of my clients has several separated networks administered differently. ... and some use the persons national insurance number. ...
    (microsoft.public.sqlserver.security)
  • Re: Logon name > 20 characters
    ... We are running a win2k3 native domain with 2k and XP clients. ... We are planning on changing our naming convention (due to an extra 35k ... first initial, middle initial, first fourletters of surname. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Count Records Between A-K and L-Z
    ... Microsoft MVP - Excel ... cases based on the surname of the client. ... For instance, Jane ... all clients with a surname between A and K and Jill manages all ...
    (microsoft.public.excel.worksheet.functions)