 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / January 2008criteria data in report
I pull a report from a query. When I do so, I am prompted for date parameters (part of the query). I would like the values that I enter for these parameters to show up on the report. Any suggestions? Thanks >I pull a report from a query. When I do so, I am prompted for date > parameters (part of the query). I would like the values that I enter for > these parameters to show up on the report. Any suggestions? You can get the parameters into the query as calculated fields. Here's an example: SELECT MyTable.*, [Enter Start Date] As FromDate, [Enter End Date] As ToDate, FROM MyTable WHERE MyTable.DateField Between [Enter Start Date] And [Enter End Date] Having set up the query that way, the parameter values will be available as fields FromDate and ToDate, and you can include those fields on your report.  SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) Sorry -I'm a novice. So you are saying that I need to write a formula in the Criteria section of the query? I don't understand the formula. The table name I want to use is "transcript orders". The field I want to criteria on is simply "Date" Are SELECT, FROM and WHERE commands that I need in the formula? What is "MyTable.*,"? The more you can break it down for me, the better - me knowledge is very limmited. Thanks, LE > >I pull a report from a query. When I do so, I am prompted for date > > parameters (part of the query). I would like the values that I enter for [quoted text clipped - 13 lines] > Having set up the query that way, the parameter values will be available as > fields FromDate and ToDate, and you can include those fields on your report. >Sorry -I'm a novice. So you are saying that I need to write a formula in the >Criteria section of the query? [quoted text clipped - 26 lines] >> WHERE >> MyTable.DateField Between [Enter Start Date] And [Enter End Date] The query grid is simply a tool to construct a SQL string. Dirk - not knowing anything about your tablenames or fieldnames - has offered you a SQL string. What you can do to get the same result is open your query in design grid view. Copy and paste the prompts from your Critera line into vacant Field cells in the top row of the query. Or, select View... SQL; you'll see something resembling what Dirk posted, with your actual table names, fieldnames and prompts. You can copy the Between... And... prompts into the SELECT clause following his example. John W. Vinson [MVP] <a clearer explanation than I was able to manage> Thanks, John. SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) > Sorry -I'm a novice. So you are saying that I need to write a formula in > the > Criteria section of the query? No. I was suggesting that you define calculated fields in your query that would hold the parameters. > I don't understand the formula. The table name I want to use is > "transcript > orders". The field I want to criteria on is simply "Date" Just for future reference, "Date" is a bad name to use for a field. There's a built-in function named "Date" and having that as a field name can lead to problems unless you handle it just right. I suppose it's too late to rename that field? We can work around it if we have to. > Are SELECT, FROM and WHERE commands that I need in the formula? No. Those are elements of the SQL statement. It's not a formula, it's the "SQL View" of a query. What I posted was an example. > What is "MyTable.*,"? "MyTable" was just the name of the table I used for my example. "SELECT MyTable.*", in SQL, means "select all the fields in the table named 'MyTable'". > The more you can break it down for me, the better - me knowledge is very > limmited. I think we'd better approach this from a different angle. You say your report is based on a query that has date parameters. Please open that query in SQL View, and copy/paste the SQL statement into a reply to this message. SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) > > Sorry -I'm a novice. So you are saying that I need to write a formula in > > the [quoted text clipped - 29 lines] > report is based on a query that has date parameters. Please open that query > in SQL View, and copy/paste the SQL statement into a reply to this message. Dirk - someone else suggested that I past the prompts into blank fields in the query. This seems to have worked just fine. THanks for the help! > Dirk - someone else suggested that I past the prompts into blank fields in > the query. Yes, that's the visual equivalent of what I was trying to get at via SQL. I'm glad you got it working. SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.