By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 3,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Access Help

P: 2
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
Jul 15 '07 #1
Share this Question
Share on Google+
4 Replies


hariharanmca
100+
P: 1,977
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
Jul 16 '07 #2

P: 7
.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]
Jul 16 '07 #3

P: 2
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
Jul 17 '07 #4

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

Expand|Select|Wrap|Line Numbers
  1. SELECT CDate([Enter the beginning performance review date]) AS BegDate, CDate([Enter the end performance review date]) AS EndDate
  2. FROM tablename
  3. 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.....
Jul 17 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.