help with database creation

[terrep263]

i need help to figure out the following:



i want to create a data base that will out put service due dates. the dates are due every thirty days and will output the persons name, phone number, address,zip, type of equipment and service tech. any help would be appericiated i am new to this so please give details.

[Tanis]

I would suggest you crrate a table with your fields,Name, Phone etc. As it seems to be such a small DB I would further suggest you put all the fieldas in one table. Don't forget to have a date field fldDate. You can the create a query with all you fields in it. One of the fields needs to be a calculated field. In the field row put DueDateateAdd("d",30,[fldDate])
This will return all those records with a date 30 days from whatever is in fldDate. You can run the query anytime you wish, or create a report to run from the query, the choice is yours.