Query with specific months

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to make a query from my data in which I can have all person with each
months birthday in a seperate query.
Example:
Everyone in my database with a birthday in November.
 
Are supposed to know how you are storing a person's birthdate? Can you tell
us what you mean by "in a separate query"? You should only need a single
query that you dynamically change the queried month.
 
I have a database with clients birthdays and other information. I want to
make a query for each month from the table so what I can look at clients
sorted by the month. Many of the clients go back to 1971 to the present. I
would like to have everyone in a query my birth months. Example. Jan, Feb,
March and so on.

I hope this is some clearer. I put in the criteria cell Between #11/1/# And
#11/30# and the query showed my only the person for year 2006. I am on the
right path but not getting everyone.
 
I have a database with clients birthdays and other information. I want to
make a query for each month from the table so what I can look at clients
sorted by the month. Many of the clients go back to 1971 to the present. I
would like to have everyone in a query my birth months. Example. Jan, Feb,
March and so on.

I hope this is some clearer. I put in the criteria cell Between #11/1/# And
#11/30# and the query showed my only the person for year 2006. I am on the
right path but not getting everyone.
Click to expand...

To calculate someone's birth month, add a new field to your query
design:

BirthMonth: DatePart("m",[MyPersonBirthDate])

Now you can specify criteria for that new field to any month you like, 1
- 12.
 
can you give me an example. I have a field for birthday and want to group
my month. give me the formula please.

Armen Stein said:
I have a database with clients birthdays and other information. I want to
make a query for each month from the table so what I can look at clients
sorted by the month. Many of the clients go back to 1971 to the present. I
would like to have everyone in a query my birth months. Example. Jan, Feb,
March and so on.

I hope this is some clearer. I put in the criteria cell Between #11/1/# And
#11/30# and the query showed my only the person for year 2006. I am on the
right path but not getting everyone.
Click to expand...

To calculate someone's birth month, add a new field to your query
design:

BirthMonth: DatePart("m",[MyPersonBirthDate])

Now you can specify criteria for that new field to any month you like, 1
- 12.
Click to expand...
 
What I have is a database with name, address, birthday. I want to made a
query for each month to put names of people with birthdays in Jan in the Jan
query etc.

I have entries that go back to 1971 which need to be in each months
catagory. I do not know how to write the criteria so it will select everyone
who has a birthday in each month and will put all in each month. I tried
In(November), "November" and neither worked. I just need someone to write
out in plain language exactly what to put.

wwmoore said:
can you give me an example. I have a field for birthday and want to group
my month. give me the formula please.

Armen Stein said:
I have a database with clients birthdays and other information. I want to
make a query for each month from the table so what I can look at clients
sorted by the month. Many of the clients go back to 1971 to the present. I
would like to have everyone in a query my birth months. Example. Jan, Feb,
March and so on.

I hope this is some clearer. I put in the criteria cell Between #11/1/# And
#11/30# and the query showed my only the person for year 2006. I am on the
right path but not getting everyone.

:

Are supposed to know how you are storing a person's birthdate? Can you tell
us what you mean by "in a separate query"? You should only need a single
query that you dynamically change the queried month.
Click to expand...

To calculate someone's birth month, add a new field to your query
design:

BirthMonth: DatePart("m",[MyPersonBirthDate])

Now you can specify criteria for that new field to any month you like, 1
- 12.
Click to expand...
Click to expand...
 
You don't have a "database" with fields, you have an unnamed table with
fields. Assuming your birthday field is an actual date, try create a query
like:

SELECT *
FROM tblWithNoName
WHERE Month([Birthday])=[Enter Month Number];


--
Duane Hookom
MS Access MVP

wwmoore said:
What I have is a database with name, address, birthday. I want to made a
query for each month to put names of people with birthdays in Jan in the
Jan
query etc.

I have entries that go back to 1971 which need to be in each months
catagory. I do not know how to write the criteria so it will select
everyone
who has a birthday in each month and will put all in each month. I tried
In(November), "November" and neither worked. I just need someone to write
out in plain language exactly what to put.

wwmoore said:
can you give me an example. I have a field for birthday and want to
group
my month. give me the formula please.

Armen Stein said:
I have a database with clients birthdays and other information. I
want to
make a query for each month from the table so what I can look at
clients
sorted by the month. Many of the clients go back to 1971 to the
present. I
would like to have everyone in a query my birth months. Example. Jan,
Feb,
March and so on.

I hope this is some clearer. I put in the criteria cell Between
#11/1/# And
#11/30# and the query showed my only the person for year 2006. I am
on the
right path but not getting everyone.

:

Are supposed to know how you are storing a person's birthdate? Can
you tell
us what you mean by "in a separate query"? You should only need a
single
query that you dynamically change the queried month.

--
Duane Hookom
MS Access MVP


To calculate someone's birth month, add a new field to your query
design:

BirthMonth: DatePart("m",[MyPersonBirthDate])

Now you can specify criteria for that new field to any month you like,
1
- 12.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top