Access Help

[jimmy0305]

Hi i am jimmy,
I need help with access.
I created a crosstab query which has row headings as employee name and column heading as job type and the calculated field as hrs.this query is used to give me list of employees worked on a particular job and particular hrs.But now i want another query with the same details but worked from a starting date to ending date.I used the" Between... and " command .All I can do is give the dates and print the report.But i need a user to type his own dates and get the output from that.

Kindly help me,

Thanks,
jim

[hariharanmca]

Hi i am jimmy,
I need help with access.
I created a crosstab query which has row headings as employee name and column heading as job type and the calculated field as hrs.this query is used to give me list of employees worked on a particular job and particular hrs.But now i want another query with the same details but worked from a starting date to ending date.I used the" Between... and " command .All I can do is give the dates and print the report.But i need a user to type his own dates and get the output from that.

Kindly help me,

Thanks,
jim

Hi,

Welcome to TSDN




Good luck

[ajetrumpet]

.All I can do is give the dates and print the report.But i need a user to type his own dates and get the output from that

User specified criteria is usually entered into a control of somekind. Could you maybe run the report with a command button?? Sounds like your report is based on the query, so that would probably work...

You could enter your control names in your code line....
Between [source1] AND [source2]

[jimmy0305]

well i have a crosstab query and i tried to give dates but it says microsoft jet database engine does not recognize as valid field name...

thank you

[mlcampeau]

Not sure if this will help. I have just a regular query that I pass date parameters to in the following manner:

SELECT CDate([Enter the beginning performance review date]) AS BegDate, CDate([Enter the end performance review date]) AS EndDate
FROM tablename
WHERE (((table.field)>=CDate([Enter the beginning performance review date]) And (table.field)<=CDate([Enter the end performance review date]))) OR (((table.field2)>=CDate([Enter the beginning performance review date]) And (table.field2)<=CDate([Enter the end performance review date])))

Please note that I obviously removed a lot of info from this sql statement, and just left the pertinent info. Where it says table.field, that would be what you are comparing the beginning date to and table.field2 is the what you are comparing the end date to.

Hope this helps.....