Hi Tom, I appreicate the input. It's a little beyond what I can do right now though. I don't know anything about vba functions. I can handle multi-tables as I have setup a few other DB's that needed multi-tables & queries. I did however get help with forms as I was having trouble with them. I might sit down & re-work it again another day when I'm bored but I did already go ahead
Lisa, Go to Microsofts website. They have database templates there that you can download for free. In fact, they have one that is an address book that I believe will take care of your needs. check it out. Here is the link: http://office.microsoft.com/en-us/templates/CT101426031033.aspx "Lisa - NH" wrote: Hi. I setup a DB using the Contacts Template. I'm finding it's not going
You really need three tables for this, Employees, CardTypes and CardMailings. As the others have said Employees would have an EmployeeID column as its primary key, and column such as Firstname, LastName etc. CardTypes can have a text CardType column as its primary key as the text values, unlike names, can't be duplicated. The CardMailings table models a many-to-many relationship type between
"Carolyn Marenger" <cajunk@marenger.com> schreef in bericht news:77014$47a1adcc$cf70133e$440@PRIMUS.CA... Carolyn Marenger wrote: How do I perform a select statement that would locate all records in which the day and month are in the next say 30 days regardless of the year. Basically an upcoming birthday/anniversary list. Thanks, Carolyn The following command worked
Kim wrote: On Jan 29, 11:31 pm, Carolyn Marenger <caj...@marenger.com> wrote: How do I perform a select statement that would locate all records in which the day and month are in the next say 30 days regardless of the year. Basically an upcoming birthday/anniversary list. Thanks, Carolyn Have a look at the function date_sub(), and you find more date functions here
