Web Development

Ask something
Discussion Locked

Access 2000 Date & Time Format

0 helpful
7 replies

by ian.mcpherson 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm trying to run a report on employees birthday by month. Everytime I'm prompted for month and I hit "1" for january, I get all the Januarys Plus septemeber and october (10 & 11). It only does this with January and no other months. I have triedchanging the month to 01 in the table in which it pulls the data from. Any suggestions?? This is Access 2000 running a report

7 replies

by ann777

The report parameter should be changed to retrieve hits when "month<2" for January ; else it will pickup that first 1 and treat all months that begin with a one as January (January, October, November and December all begin with "1").

by dklippert

Here are a couple of suggestions:

_____________________
In the criteria section of the query grid for the field that contains the date:

month([datefieldname])=3

the 3 being the month you are looking for. this could also be written for prompting for the month like this:

month([datefieldname])=[enter month]
_____________________
---or---
_____________________
Create a Month column

AMonth: Month([YourDateField])

Set the criteria to
[Enter a Month Number]
____________________

by dsa

Create a query with the information you need plus a field you name: Mn: Format([BDate],"mmm") or Mn: Format([BDate],"mm").

The first you can enter the month using a 3 letter string. If you use the second one, you use the number 01-12 as your input.

This discussion is closed to new replies.