If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
My apologies -- I must have stopped reading after your question about the
Access version. I changed the query criteria to read as you asked. I saved info and attempted to open the form (I selected the report which brought up the form with parameters). I entered valid dates. I attempted to preview and got error message -- "typed incorrectly or too complicated to evaluate.". I then opened the report in design view, selected properties, chose the SQL query, determined that it was changed to your criteria. I attempted to run the query and got the same message. I did attempt to use control + F6, but nothing happened. Did I misunderstand you? Thanks "Al Camp" wrote in message ... jwr, OK on 2003, I'll try to find it, but... what about my instructions, and other questions? You were supposed to do some query testing for me. What happened? If we're going to solve your problem , you need to read my posts, follow the instructions, and get back to me with what happened... in detail. No new questions until we solve the first one! Al camp "jwr" wrote in message . .. This is an Order Entry Template -- I am using Access 2003, but it was on 2000 also. Another question for you -- I have created a query and then a report from that query. Within the query are numerous tables. When I, for instance, want to see the payments made against an invoice, I get a payment for each line item rather than a total amount paid by date. should I be creating individual queries and then one query to combine all of the individual queries for my report? Thank you so much for your assistance and for your patience with me. I am very short on knowledge of access. Joy "Al Camp" wrote in message ... OK... What version of Access are you running? I found an Orders database in Access97, but I don't see the form or report you describe. Is Orders a sample or template? Let's determine if just the query will run clean. If so, then it's the report that has a problem. Your query criteria... =[forms]![Report Date Range]![Beginning Order Date] And =[forms]![Report Date Range]![Ending Order Date] Just for now, use my criteria... Between Forms![Report Date Range]![Beginning Order Date] and Forms![Report Date Range]![Ending Order Date] Now... Open your form, and enter 2 legitimate dates for the range, and leave the form open. Use Ctrl-F6 to access the other database objects and open the report in Design view. Go into query design grid for the query behind the report, and run it (while your form is still open). Here's the big question... does the query run correctly? Does it return the appropriate records you want? It should NOT prompt for any parameters... it should automatically get them from the open form. hth Al Camp "jwr" wrote in message .. . Yes, the Report Date Range form asks for Beginning and Ending Order Date. The criteria below is against Order Date: =[forms]![Report Date Range]![Beginning Order Date] And =[forms]![Report Date Range]![Ending Order Date] "Al Camp" wrote in message ... OK, we're getting there. I don't have that database so we'll have to wing it. The form that calls the report should be named [Report Date Range], and it should have 2 DateType fields on it called [Beginning Order Date] and another named [Ending Order Date]... where you enter the two dates required for the report Do that for a first step... because that's what the report is looking for. Now... The properties of the report ties into a query with the beginning and ending date as criteria. I need to know what that criteria is... exactly as you see it in the query, and what field it is entered against. (Order Date maybe?) Here's what I would expect to see... Between Forms![Report Date Range]![Beginning Order Date] and Forms![Report Date Range]![Ending Order Date] Let's try that, and see where we are afterwards. Hang in... hth Al Camp "jwr" wrote in message . .. Al -- This was created when I used the Order Database with Access. This is what I see: Report Header: Sales by Customer Beneath Sales by customer is a box with the following information: ="For Orders Rec'd Between: " & forms![Report Date Range]![Beginning Order Date] & " and " & forms![Report Date Range]![Ending Order Date] When I attempt to run the report, I get a box that "pops up" asking for the beginning and ending dates. I enter 1/01/05 or 01/01/05 and get the error message. The properties of that text box a Text box with control source being the information I listed above. The properties of the report ties into a query with the beginning and ending date as criteria. I am not sure what you mean by "Are the parameters the criteria for a legitimate Date/Time field on your report?" Let me know if I did not answer your questions. thanks "Al Camp" wrote in message ... Please provide a bit more info... Is you query a parameter query? If so, what is the parameter statement? (ex. Between [Enter Start Date] And [Enter Stop Date]) Are the parameters the criteria for a legitimate Date/Time field on your report? What is the field name and type? Al Camp "jwr" wrote in message ... Sorry -- I entered 01/01/05 No quotes and no # signs. "Al Camp" wrote in message ... jwr, It would have been helpful had you indicated what you keyed in (exactly) in response to the prompt... I'm assuming your entering a Date parameter against a Date field using normal date formatting. Normally, dates are entered as mm/dd/yy 01/01/05 or, you can drop the zeros 1/1/05 No " quotes, no # poundsigns. hth Al Camp "jwr" wrote in message ... I am using Access Orders Database. On the Orders by Customer Report (and other reports) when I attempt to preview, a box pops up asking for a date range. When I first input the date range I got a message that read - "Incorrect format." I changed text box properties to short date. Then I got the message -- "Typed incorrectly or too complex to evaluate." I changed the format back to blank as it was originally. I am still getting the message typed incorrectly, etc. and am unable to preview the report. ="For Orders Rec'd Between: " & forms![Report Date Range]![Beginning Order Date] & " and " & forms![Report Date Range]![Ending Order Date] |
#12
|
|||
|
|||
jwr,
I found the Order Entry Template. I had no data, but I was able to test the Report Date Range form, and the Sales By Customer report. Even though the report came back with no data, the date entry worked fine. I used several legitimate date ranges. I even entered illegitimate dates like 88/88/88, but I got an appropriate "Invalid entry" error... not a "too complicated" error. If you have not changed the Report Date Range form in any way, or the Sales By Customer report, and you really are enetering legitimate dates, then I have no idea where the problem could be. If you have made any changes *at all* to either the form or report, then delete them, create a seperate new OrderEntry MDB, and import the form and report from there into your MDB. That would put you back to a pristine Report Date Range form, and a Sales By Customer report. At this point, that's all I can suggest. Please feel free to create a totally new post with this question. This one is getting a bit "buried." Perhaps someone else may have some new ideas. hth Al Camp "jwr" wrote in message ... My apologies -- I must have stopped reading after your question about the Access version. I changed the query criteria to read as you asked. I saved info and attempted to open the form (I selected the report which brought up the form with parameters). I entered valid dates. I attempted to preview and got error message -- "typed incorrectly or too complicated to evaluate.". I then opened the report in design view, selected properties, chose the SQL query, determined that it was changed to your criteria. I attempted to run the query and got the same message. I did attempt to use control + F6, but nothing happened. Did I misunderstand you? Thanks "Al Camp" wrote in message ... jwr, OK on 2003, I'll try to find it, but... what about my instructions, and other questions? You were supposed to do some query testing for me. What happened? If we're going to solve your problem , you need to read my posts, follow the instructions, and get back to me with what happened... in detail. No new questions until we solve the first one! Al camp "jwr" wrote in message . .. This is an Order Entry Template -- I am using Access 2003, but it was on 2000 also. Another question for you -- I have created a query and then a report from that query. Within the query are numerous tables. When I, for instance, want to see the payments made against an invoice, I get a payment for each line item rather than a total amount paid by date. should I be creating individual queries and then one query to combine all of the individual queries for my report? Thank you so much for your assistance and for your patience with me. I am very short on knowledge of access. Joy "Al Camp" wrote in message ... OK... What version of Access are you running? I found an Orders database in Access97, but I don't see the form or report you describe. Is Orders a sample or template? Let's determine if just the query will run clean. If so, then it's the report that has a problem. Your query criteria... =[forms]![Report Date Range]![Beginning Order Date] And =[forms]![Report Date Range]![Ending Order Date] Just for now, use my criteria... Between Forms![Report Date Range]![Beginning Order Date] and Forms![Report Date Range]![Ending Order Date] Now... Open your form, and enter 2 legitimate dates for the range, and leave the form open. Use Ctrl-F6 to access the other database objects and open the report in Design view. Go into query design grid for the query behind the report, and run it (while your form is still open). Here's the big question... does the query run correctly? Does it return the appropriate records you want? It should NOT prompt for any parameters... it should automatically get them from the open form. hth Al Camp "jwr" wrote in message .. . Yes, the Report Date Range form asks for Beginning and Ending Order Date. The criteria below is against Order Date: =[forms]![Report Date Range]![Beginning Order Date] And =[forms]![Report Date Range]![Ending Order Date] "Al Camp" wrote in message ... OK, we're getting there. I don't have that database so we'll have to wing it. The form that calls the report should be named [Report Date Range], and it should have 2 DateType fields on it called [Beginning Order Date] and another named [Ending Order Date]... where you enter the two dates required for the report Do that for a first step... because that's what the report is looking for. Now... The properties of the report ties into a query with the beginning and ending date as criteria. I need to know what that criteria is... exactly as you see it in the query, and what field it is entered against. (Order Date maybe?) Here's what I would expect to see... Between Forms![Report Date Range]![Beginning Order Date] and Forms![Report Date Range]![Ending Order Date] Let's try that, and see where we are afterwards. Hang in... hth Al Camp "jwr" wrote in message . .. Al -- This was created when I used the Order Database with Access. This is what I see: Report Header: Sales by Customer Beneath Sales by customer is a box with the following information: ="For Orders Rec'd Between: " & forms![Report Date Range]![Beginning Order Date] & " and " & forms![Report Date Range]![Ending Order Date] When I attempt to run the report, I get a box that "pops up" asking for the beginning and ending dates. I enter 1/01/05 or 01/01/05 and get the error message. The properties of that text box a Text box with control source being the information I listed above. The properties of the report ties into a query with the beginning and ending date as criteria. I am not sure what you mean by "Are the parameters the criteria for a legitimate Date/Time field on your report?" Let me know if I did not answer your questions. thanks "Al Camp" wrote in message ... Please provide a bit more info... Is you query a parameter query? If so, what is the parameter statement? (ex. Between [Enter Start Date] And [Enter Stop Date]) Are the parameters the criteria for a legitimate Date/Time field on your report? What is the field name and type? Al Camp "jwr" wrote in message ... Sorry -- I entered 01/01/05 No quotes and no # signs. "Al Camp" wrote in message ... jwr, It would have been helpful had you indicated what you keyed in (exactly) in response to the prompt... I'm assuming your entering a Date parameter against a Date field using normal date formatting. Normally, dates are entered as mm/dd/yy 01/01/05 or, you can drop the zeros 1/1/05 No " quotes, no # poundsigns. hth Al Camp "jwr" wrote in message ... I am using Access Orders Database. On the Orders by Customer Report (and other reports) when I attempt to preview, a box pops up asking for a date range. When I first input the date range I got a message that read - "Incorrect format." I changed text box properties to short date. Then I got the message -- "Typed incorrectly or too complex to evaluate." I changed the format back to blank as it was originally. I am still getting the message typed incorrectly, etc. and am unable to preview the report. ="For Orders Rec'd Between: " & forms![Report Date Range]![Beginning Order Date] & " and " & forms![Report Date Range]![Ending Order Date] |
#13
|
|||
|
|||
Many thanks for your assistance.
"Al Camp" wrote in message ... jwr, I found the Order Entry Template. I had no data, but I was able to test the Report Date Range form, and the Sales By Customer report. Even though the report came back with no data, the date entry worked fine. I used several legitimate date ranges. I even entered illegitimate dates like 88/88/88, but I got an appropriate "Invalid entry" error... not a "too complicated" error. If you have not changed the Report Date Range form in any way, or the Sales By Customer report, and you really are enetering legitimate dates, then I have no idea where the problem could be. If you have made any changes *at all* to either the form or report, then delete them, create a seperate new OrderEntry MDB, and import the form and report from there into your MDB. That would put you back to a pristine Report Date Range form, and a Sales By Customer report. At this point, that's all I can suggest. Please feel free to create a totally new post with this question. This one is getting a bit "buried." Perhaps someone else may have some new ideas. hth Al Camp "jwr" wrote in message ... My apologies -- I must have stopped reading after your question about the Access version. I changed the query criteria to read as you asked. I saved info and attempted to open the form (I selected the report which brought up the form with parameters). I entered valid dates. I attempted to preview and got error message -- "typed incorrectly or too complicated to evaluate.". I then opened the report in design view, selected properties, chose the SQL query, determined that it was changed to your criteria. I attempted to run the query and got the same message. I did attempt to use control + F6, but nothing happened. Did I misunderstand you? Thanks "Al Camp" wrote in message ... jwr, OK on 2003, I'll try to find it, but... what about my instructions, and other questions? You were supposed to do some query testing for me. What happened? If we're going to solve your problem , you need to read my posts, follow the instructions, and get back to me with what happened... in detail. No new questions until we solve the first one! Al camp "jwr" wrote in message . .. This is an Order Entry Template -- I am using Access 2003, but it was on 2000 also. Another question for you -- I have created a query and then a report from that query. Within the query are numerous tables. When I, for instance, want to see the payments made against an invoice, I get a payment for each line item rather than a total amount paid by date. should I be creating individual queries and then one query to combine all of the individual queries for my report? Thank you so much for your assistance and for your patience with me. I am very short on knowledge of access. Joy "Al Camp" wrote in message ... OK... What version of Access are you running? I found an Orders database in Access97, but I don't see the form or report you describe. Is Orders a sample or template? Let's determine if just the query will run clean. If so, then it's the report that has a problem. Your query criteria... =[forms]![Report Date Range]![Beginning Order Date] And =[forms]![Report Date Range]![Ending Order Date] Just for now, use my criteria... Between Forms![Report Date Range]![Beginning Order Date] and Forms![Report Date Range]![Ending Order Date] Now... Open your form, and enter 2 legitimate dates for the range, and leave the form open. Use Ctrl-F6 to access the other database objects and open the report in Design view. Go into query design grid for the query behind the report, and run it (while your form is still open). Here's the big question... does the query run correctly? Does it return the appropriate records you want? It should NOT prompt for any parameters... it should automatically get them from the open form. hth Al Camp "jwr" wrote in message .. . Yes, the Report Date Range form asks for Beginning and Ending Order Date. The criteria below is against Order Date: =[forms]![Report Date Range]![Beginning Order Date] And =[forms]![Report Date Range]![Ending Order Date] "Al Camp" wrote in message ... OK, we're getting there. I don't have that database so we'll have to wing it. The form that calls the report should be named [Report Date Range], and it should have 2 DateType fields on it called [Beginning Order Date] and another named [Ending Order Date]... where you enter the two dates required for the report Do that for a first step... because that's what the report is looking for. Now... The properties of the report ties into a query with the beginning and ending date as criteria. I need to know what that criteria is... exactly as you see it in the query, and what field it is entered against. (Order Date maybe?) Here's what I would expect to see... Between Forms![Report Date Range]![Beginning Order Date] and Forms![Report Date Range]![Ending Order Date] Let's try that, and see where we are afterwards. Hang in... hth Al Camp "jwr" wrote in message . .. Al -- This was created when I used the Order Database with Access. This is what I see: Report Header: Sales by Customer Beneath Sales by customer is a box with the following information: ="For Orders Rec'd Between: " & forms![Report Date Range]![Beginning Order Date] & " and " & forms![Report Date Range]![Ending Order Date] When I attempt to run the report, I get a box that "pops up" asking for the beginning and ending dates. I enter 1/01/05 or 01/01/05 and get the error message. The properties of that text box a Text box with control source being the information I listed above. The properties of the report ties into a query with the beginning and ending date as criteria. I am not sure what you mean by "Are the parameters the criteria for a legitimate Date/Time field on your report?" Let me know if I did not answer your questions. thanks "Al Camp" wrote in message ... Please provide a bit more info... Is you query a parameter query? If so, what is the parameter statement? (ex. Between [Enter Start Date] And [Enter Stop Date]) Are the parameters the criteria for a legitimate Date/Time field on your report? What is the field name and type? Al Camp "jwr" wrote in message ... Sorry -- I entered 01/01/05 No quotes and no # signs. "Al Camp" wrote in message ... jwr, It would have been helpful had you indicated what you keyed in (exactly) in response to the prompt... I'm assuming your entering a Date parameter against a Date field using normal date formatting. Normally, dates are entered as mm/dd/yy 01/01/05 or, you can drop the zeros 1/1/05 No " quotes, no # poundsigns. hth Al Camp "jwr" wrote in message ... I am using Access Orders Database. On the Orders by Customer Report (and other reports) when I attempt to preview, a box pops up asking for a date range. When I first input the date range I got a message that read - "Incorrect format." I changed text box properties to short date. Then I got the message -- "Typed incorrectly or too complex to evaluate." I changed the format back to blank as it was originally. I am still getting the message typed incorrectly, etc. and am unable to preview the report. ="For Orders Rec'd Between: " & forms![Report Date Range]![Beginning Order Date] & " and " & forms![Report Date Range]![Ending Order Date] |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
More on adding date range to report headers | Laine | Setting Up & Running Reports | 1 | August 4th, 2005 08:24 PM |
help needed | jkendrick75 | Running & Setting Up Queries | 19 | March 17th, 2005 02:37 PM |
Text field containing date to query within date range | Kenz21 | Running & Setting Up Queries | 4 | January 14th, 2005 04:21 PM |
date range issues in reports | Christina Barnett | Setting Up & Running Reports | 9 | September 17th, 2004 05:53 PM |
Autodate sheets for a specified date range | Scott Whetsell, A.S. - WVSP | Worksheet Functions | 3 | September 7th, 2004 06:37 PM |