Input Masks & Queries

[Guest]

I have set up a form which includes an input mask on a date which concludes
with it in the following format "Month Year". I now wish to run a parameter
query which brings back all records which match a particular "Month Year".
Unfortunately it will only bring back any items entered as "September 2005"
as opposed to "19/09/05". The input mask changes 19/09/05 to September 2005
in the form but does not recognise the input mask in the query. Is there a
way around this?

 

[JohnFol]

what's the "Where" part of the query?

 

[Amy Blankenship]

Could you give more details as to how you have this set up, including the
full SQL of the query?

Thanks;

Amy

 

[Guest]

The "Where" part of the query is the "Month Year".

 

[Guest]

The input mask on the table is set as follows:-

mmmm yyyy

This allows the user to enter a date and it automatically states on screen
the month & year. Alternatively they can manually type in the Month & Year.

The full SQL in the query is as follows:-

SELECT [Base Data].*, [Base Data].[Summary Month]
FROM [Base Data]
WHERE ((([Base Data].[Summary Month])=[Enter Summary Month]));

Regards David

 

[Amy Blankenship]

So if you enter the parameter manually, it works as expected?

How are you calling the query in your code?

-Amy

The input mask on the table is set as follows:-

mmmm yyyy

This allows the user to enter a date and it automatically states on screen
the month & year. Alternatively they can manually type in the Month &
Year.

The full SQL in the query is as follows:-

SELECT [Base Data].*, [Base Data].[Summary Month]
FROM [Base Data]
WHERE ((([Base Data].[Summary Month])=[Enter Summary Month]));

Regards David

Could you give more details as to how you have this set up, including the
full SQL of the query?

Thanks;

Amy