Recent content by fsmith

SELECT [MUST MEMBERS].[Date of Birth] FROM [MUST MEMBERS];

I used the query wizard to create a query that contains date of birth from my database. It did not asked me to specify "select".

No I am not sure the query is 'select' or anything like that. Did I set up the query wrong?

I see two columns in your previous response. I have one. It has the date of birth. do I need to add two more columns in my query? Access keeps saying it needs a destination. . .

I need to know if the member will turn either 26 or 65 in December.

Do I need to figure out how old the members are before I create the query?

When you say 'in the column next to field . . . where do I click? There are cells labeled Field / Table/ Sort/Show/ Criteria / or. I am brand new to access and am figuring this all out as I go.

My database contains date of birth. I need to create a query that will find all members who are turning 65 or 26 in December this year. Can someone give me step by step instructions on how to create this query?

Created a form that uses two tables but it is not pulling data from either table. . .

Khalid Thank you so much for pointing me in the right direction. I would have made a mess! I am restructuring my tables.

Thank you for heading me in a direction.

How does one make a form update the data in one table and add a line of data on another table?

Hello. My name is Missy. I am new to Access. I am not a programmer just an employee who wants to streamline the way we perform our job functions. I am learning as I create a database. I joined this Forum in order to get assistance from folks in the know . . . you. I am an...