Search month

[seanog2001]

I want to be able to search my table with a query in which it instructs the user to enter a month and it returns all the values in te table for that month.

the problem is that the date values in the table are in the form 18/08/2006

Is it possible to do this sort of query

 

[Karma]

I want to be able to search my table with a query in which it instructs the user to enter a month and it returns all the values in te table for that month.

the problem is that the date values in the table are in the form 18/08/2006

Is it possible to do this sort of query

There are probably a number of ways of doing this but this should work.

In the query add a new field with this in - goes where the field from a table would normally be.

MyMonthSearch:Month([Name of the date field here])

In the criteria.

[Please enter the month - as a number]

You should be aware that if you have two or more years worth of data it will return all records for those years.

HTH

K.

 

[seanog2001]

There are probably a number of ways of doing this but this should work.

In the query add a new field with this in - goes where the field from a table would normally be.

MyMonthSearch:Month([Name of the date field here])

In the criteria.

[Please enter the month - as a number]

You should be aware that if you have two or more years worth of data it will return all records for those years.

HTH

K.

Nah mate this doesnt work its asks me to enter a parameter value

enter date field here:

I put in a date then it asks me to enter a month in numeric form which i did and it returned nothing

 

[Karma]

Nah mate this doesnt work its asks me to enter a parameter value

enter date field here:

I put in a date then it asks me to enter a month in numeric form which i did and it returned nothing

MyMonthSearch:Month([Name of the date field here*])

* this is the name of the field you want to search on i.e. your field from your table like MyMonthSearch:Month([Employee_Start_Date])

HTH

K.

 

[seanog2001]

MyMonthSearch:Month([Name of the date field here*])

* this is the name of the field you want to search on i.e. your field from your table like MyMonthSearch:Month([Employee_Start_Date])

HTH

K.

Workin for me now cheers mate!