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
|
|||
|
|||
BottomComment was the new field I added to CompanyInfo:
I cant find it in Report/Prop/control source /data/rptInvoice, but I do find it under tables futher down as Tables/tblCompanyInfo/BottomComment Thanks Bob "Duane Hookom" wrote in message ... You recently stated "Looks like I have to add it to my record source ".. you are correct. I have twice suggested that you add the table containing the field to your report's record source. If you are having trouble finding the record source, view the report properties and find the Data tab. -- Duane Hookom MS Access MVP "Bob" wrote in message ... In Properties of Text box I can add things from rptInvoice/Report but my tbBottomComment is not there I do find in down in tables/tblCompanyInfo but it will not copy from there..Thanks Bob "Bob" wrote in message ... Ok I added a new field called BottomComment to my CompanyInfo and it works when I type some thing in to it, because when I F11 I can see what I typed into the form. But On my report I can not find BottomComment? Looks like I have to add it to my record source , where would I start Thanks for your help "Duane Hookom" wrote in message ... Did you add the table to your report's record source? -- Duane Hookom MS Access MVP "Bob" wrote in message ... I have this code but I am getting that error: =tblCompanyInfo!BottomComment Thanks Bob "Bob" wrote in message ... Getting "Enter Parameter Value" error.....Thanks Bob "Duane Hookom" wrote in message ... Create a one record table and add your text into a field. Add this table to your report's record source and add the field with the text to the grid so you can display it in the report. -- Duane Hookom MS Access MVP "Bob" wrote in message ... Sorry, yes a text box but I want to save the info so each time it is printed on my invoice , unless I change the text box message at a later date..Thanks Bob "Duane Hookom" wrote in message ... What do you mean by "window"? Do you mean a text box? Is the information going to be stored in your table or just printed on a report? If you don't want to save what gets typed in, just create a text box with a control source like: =[Enter some text here] -- Duane Hookom MS Access MVP "Bob" wrote in message ... -- After searching Google.groups.com and finding no answer, Bob Vance asked: I want to have a window on my form so as what ever I type into it will appear on my Invoice. I already have 6 other windows that do the same thing to that Invoice. Thanks in advance.........Bob Vance |
#12
|
|||
|
|||
You have to add tblCompanyInfo table to the query/record source of your
report. Right click in the background of the top pane of the query designer and choose to add a table. -- Duane Hookom MS Access MVP "Bob" wrote in message ... BottomComment was the new field I added to CompanyInfo: I cant find it in Report/Prop/control source /data/rptInvoice, but I do find it under tables futher down as Tables/tblCompanyInfo/BottomComment Thanks Bob "Duane Hookom" wrote in message ... You recently stated "Looks like I have to add it to my record source ".. you are correct. I have twice suggested that you add the table containing the field to your report's record source. If you are having trouble finding the record source, view the report properties and find the Data tab. -- Duane Hookom MS Access MVP "Bob" wrote in message ... In Properties of Text box I can add things from rptInvoice/Report but my tbBottomComment is not there I do find in down in tables/tblCompanyInfo but it will not copy from there..Thanks Bob "Bob" wrote in message ... Ok I added a new field called BottomComment to my CompanyInfo and it works when I type some thing in to it, because when I F11 I can see what I typed into the form. But On my report I can not find BottomComment? Looks like I have to add it to my record source , where would I start Thanks for your help "Duane Hookom" wrote in message ... Did you add the table to your report's record source? -- Duane Hookom MS Access MVP "Bob" wrote in message ... I have this code but I am getting that error: =tblCompanyInfo!BottomComment Thanks Bob "Bob" wrote in message ... Getting "Enter Parameter Value" error.....Thanks Bob "Duane Hookom" wrote in message ... Create a one record table and add your text into a field. Add this table to your report's record source and add the field with the text to the grid so you can display it in the report. -- Duane Hookom MS Access MVP "Bob" wrote in message ... Sorry, yes a text box but I want to save the info so each time it is printed on my invoice , unless I change the text box message at a later date..Thanks Bob "Duane Hookom" wrote in message ... What do you mean by "window"? Do you mean a text box? Is the information going to be stored in your table or just printed on a report? If you don't want to save what gets typed in, just create a text box with a control source like: =[Enter some text here] -- Duane Hookom MS Access MVP "Bob" wrote in message ... -- After searching Google.groups.com and finding no answer, Bob Vance asked: I want to have a window on my form so as what ever I type into it will appear on my Invoice. I already have 6 other windows that do the same thing to that Invoice. Thanks in advance.........Bob Vance |
#13
|
|||
|
|||
Thanks , where do I find query designer exactly...Bob
"Duane Hookom" wrote in message ... You have to add tblCompanyInfo table to the query/record source of your report. Right click in the background of the top pane of the query designer and choose to add a table. -- Duane Hookom MS Access MVP "Bob" wrote in message ... BottomComment was the new field I added to CompanyInfo: I cant find it in Report/Prop/control source /data/rptInvoice, but I do find it under tables futher down as Tables/tblCompanyInfo/BottomComment Thanks Bob "Duane Hookom" wrote in message ... You recently stated "Looks like I have to add it to my record source ".. you are correct. I have twice suggested that you add the table containing the field to your report's record source. If you are having trouble finding the record source, view the report properties and find the Data tab. -- Duane Hookom MS Access MVP "Bob" wrote in message ... In Properties of Text box I can add things from rptInvoice/Report but my tbBottomComment is not there I do find in down in tables/tblCompanyInfo but it will not copy from there..Thanks Bob "Bob" wrote in message ... Ok I added a new field called BottomComment to my CompanyInfo and it works when I type some thing in to it, because when I F11 I can see what I typed into the form. But On my report I can not find BottomComment? Looks like I have to add it to my record source , where would I start Thanks for your help "Duane Hookom" wrote in message ... Did you add the table to your report's record source? -- Duane Hookom MS Access MVP "Bob" wrote in message ... I have this code but I am getting that error: =tblCompanyInfo!BottomComment Thanks Bob "Bob" wrote in message ... Getting "Enter Parameter Value" error.....Thanks Bob "Duane Hookom" wrote in message ... Create a one record table and add your text into a field. Add this table to your report's record source and add the field with the text to the grid so you can display it in the report. -- Duane Hookom MS Access MVP "Bob" wrote in message ... Sorry, yes a text box but I want to save the info so each time it is printed on my invoice , unless I change the text box message at a later date..Thanks Bob "Duane Hookom" wrote in message ... What do you mean by "window"? Do you mean a text box? Is the information going to be stored in your table or just printed on a report? If you don't want to save what gets typed in, just create a text box with a control source like: =[Enter some text here] -- Duane Hookom MS Access MVP "Bob" wrote in message ... -- After searching Google.groups.com and finding no answer, Bob Vance asked: I want to have a window on my form so as what ever I type into it will appear on my Invoice. I already have 6 other windows that do the same thing to that Invoice. Thanks in advance.........Bob Vance |
#14
|
|||
|
|||
"Record Source" is a property of every report. Click the builder button
[...] to the right of this property to go to the designer. -- Duane Hookom MS Access MVP "Bob" wrote in message ... Thanks , where do I find query designer exactly...Bob "Duane Hookom" wrote in message ... You have to add tblCompanyInfo table to the query/record source of your report. Right click in the background of the top pane of the query designer and choose to add a table. -- Duane Hookom MS Access MVP "Bob" wrote in message ... BottomComment was the new field I added to CompanyInfo: I cant find it in Report/Prop/control source /data/rptInvoice, but I do find it under tables futher down as Tables/tblCompanyInfo/BottomComment Thanks Bob "Duane Hookom" wrote in message ... You recently stated "Looks like I have to add it to my record source ".. you are correct. I have twice suggested that you add the table containing the field to your report's record source. If you are having trouble finding the record source, view the report properties and find the Data tab. -- Duane Hookom MS Access MVP "Bob" wrote in message ... In Properties of Text box I can add things from rptInvoice/Report but my tbBottomComment is not there I do find in down in tables/tblCompanyInfo but it will not copy from there..Thanks Bob "Bob" wrote in message ... Ok I added a new field called BottomComment to my CompanyInfo and it works when I type some thing in to it, because when I F11 I can see what I typed into the form. But On my report I can not find BottomComment? Looks like I have to add it to my record source , where would I start Thanks for your help "Duane Hookom" wrote in message ... Did you add the table to your report's record source? -- Duane Hookom MS Access MVP "Bob" wrote in message ... I have this code but I am getting that error: =tblCompanyInfo!BottomComment Thanks Bob "Bob" wrote in message ... Getting "Enter Parameter Value" error.....Thanks Bob "Duane Hookom" wrote in message ... Create a one record table and add your text into a field. Add this table to your report's record source and add the field with the text to the grid so you can display it in the report. -- Duane Hookom MS Access MVP "Bob" wrote in message ... Sorry, yes a text box but I want to save the info so each time it is printed on my invoice , unless I change the text box message at a later date..Thanks Bob "Duane Hookom" wrote in message ... What do you mean by "window"? Do you mean a text box? Is the information going to be stored in your table or just printed on a report? If you don't want to save what gets typed in, just create a text box with a control source like: =[Enter some text here] -- Duane Hookom MS Access MVP "Bob" wrote in message ... -- After searching Google.groups.com and finding no answer, Bob Vance asked: I want to have a window on my form so as what ever I type into it will appear on my Invoice. I already have 6 other windows that do the same thing to that Invoice. Thanks in advance.........Bob Vance |
#15
|
|||
|
|||
I have been doing that but my Field that I have in the table is not showing
in Rpt on in a table further down, when I select it that's when I get the parameter Value error..Thanks Bob "Duane Hookom" wrote in message ... "Record Source" is a property of every report. Click the builder button [...] to the right of this property to go to the designer. -- Duane Hookom MS Access MVP "Bob" wrote in message ... Thanks , where do I find query designer exactly...Bob "Duane Hookom" wrote in message ... You have to add tblCompanyInfo table to the query/record source of your report. Right click in the background of the top pane of the query designer and choose to add a table. -- Duane Hookom MS Access MVP "Bob" wrote in message ... BottomComment was the new field I added to CompanyInfo: I cant find it in Report/Prop/control source /data/rptInvoice, but I do find it under tables futher down as Tables/tblCompanyInfo/BottomComment Thanks Bob "Duane Hookom" wrote in message ... You recently stated "Looks like I have to add it to my record source ".. you are correct. I have twice suggested that you add the table containing the field to your report's record source. If you are having trouble finding the record source, view the report properties and find the Data tab. -- Duane Hookom MS Access MVP "Bob" wrote in message ... In Properties of Text box I can add things from rptInvoice/Report but my tbBottomComment is not there I do find in down in tables/tblCompanyInfo but it will not copy from there..Thanks Bob "Bob" wrote in message ... Ok I added a new field called BottomComment to my CompanyInfo and it works when I type some thing in to it, because when I F11 I can see what I typed into the form. But On my report I can not find BottomComment? Looks like I have to add it to my record source , where would I start Thanks for your help "Duane Hookom" wrote in message ... Did you add the table to your report's record source? -- Duane Hookom MS Access MVP "Bob" wrote in message ... I have this code but I am getting that error: =tblCompanyInfo!BottomComment Thanks Bob "Bob" wrote in message ... Getting "Enter Parameter Value" error.....Thanks Bob "Duane Hookom" wrote in message ... Create a one record table and add your text into a field. Add this table to your report's record source and add the field with the text to the grid so you can display it in the report. -- Duane Hookom MS Access MVP "Bob" wrote in message ... Sorry, yes a text box but I want to save the info so each time it is printed on my invoice , unless I change the text box message at a later date..Thanks Bob "Duane Hookom" wrote in message ... What do you mean by "window"? Do you mean a text box? Is the information going to be stored in your table or just printed on a report? If you don't want to save what gets typed in, just create a text box with a control source like: =[Enter some text here] -- Duane Hookom MS Access MVP "Bob" wrote in message ... -- After searching Google.groups.com and finding no answer, Bob Vance asked: I want to have a window on my form so as what ever I type into it will appear on my Invoice. I already have 6 other windows that do the same thing to that Invoice. Thanks in advance.........Bob Vance |
#16
|
|||
|
|||
Did you add the field to your grid? What is the SQL view of your query and
which field are you looking for? -- Duane Hookom MS Access MVP "Bob" wrote in message ... I have been doing that but my Field that I have in the table is not showing in Rpt on in a table further down, when I select it that's when I get the parameter Value error..Thanks Bob "Duane Hookom" wrote in message ... "Record Source" is a property of every report. Click the builder button [...] to the right of this property to go to the designer. -- Duane Hookom MS Access MVP "Bob" wrote in message ... Thanks , where do I find query designer exactly...Bob "Duane Hookom" wrote in message ... You have to add tblCompanyInfo table to the query/record source of your report. Right click in the background of the top pane of the query designer and choose to add a table. -- Duane Hookom MS Access MVP "Bob" wrote in message ... BottomComment was the new field I added to CompanyInfo: I cant find it in Report/Prop/control source /data/rptInvoice, but I do find it under tables futher down as Tables/tblCompanyInfo/BottomComment Thanks Bob "Duane Hookom" wrote in message ... You recently stated "Looks like I have to add it to my record source ".. you are correct. I have twice suggested that you add the table containing the field to your report's record source. If you are having trouble finding the record source, view the report properties and find the Data tab. -- Duane Hookom MS Access MVP "Bob" wrote in message ... In Properties of Text box I can add things from rptInvoice/Report but my tbBottomComment is not there I do find in down in tables/tblCompanyInfo but it will not copy from there..Thanks Bob "Bob" wrote in message ... Ok I added a new field called BottomComment to my CompanyInfo and it works when I type some thing in to it, because when I F11 I can see what I typed into the form. But On my report I can not find BottomComment? Looks like I have to add it to my record source , where would I start Thanks for your help "Duane Hookom" wrote in message ... Did you add the table to your report's record source? -- Duane Hookom MS Access MVP "Bob" wrote in message ... I have this code but I am getting that error: =tblCompanyInfo!BottomComment Thanks Bob "Bob" wrote in message ... Getting "Enter Parameter Value" error.....Thanks Bob "Duane Hookom" wrote in message ... Create a one record table and add your text into a field. Add this table to your report's record source and add the field with the text to the grid so you can display it in the report. -- Duane Hookom MS Access MVP "Bob" wrote in message ... Sorry, yes a text box but I want to save the info so each time it is printed on my invoice , unless I change the text box message at a later date..Thanks Bob "Duane Hookom" wrote in message ... What do you mean by "window"? Do you mean a text box? Is the information going to be stored in your table or just printed on a report? If you don't want to save what gets typed in, just create a text box with a control source like: =[Enter some text here] -- Duane Hookom MS Access MVP "Bob" wrote in message ... -- After searching Google.groups.com and finding no answer, Bob Vance asked: I want to have a window on my form so as what ever I type into it will appear on my Invoice. I already have 6 other windows that do the same thing to that Invoice. Thanks in advance.........Bob Vance |
#17
|
|||
|
|||
This is what my coder said about it:
You did everything correct. Just need to add this new field in the select sql statement that brings data for the report. It is written in the Open event of Repot(Invoice) Thanks Bob....What did I actually do wrong? "Duane Hookom" wrote in message ... Did you add the field to your grid? What is the SQL view of your query and which field are you looking for? -- Duane Hookom MS Access MVP "Bob" wrote in message ... I have been doing that but my Field that I have in the table is not showing in Rpt on in a table further down, when I select it that's when I get the parameter Value error..Thanks Bob "Duane Hookom" wrote in message ... "Record Source" is a property of every report. Click the builder button [...] to the right of this property to go to the designer. -- Duane Hookom MS Access MVP "Bob" wrote in message ... Thanks , where do I find query designer exactly...Bob "Duane Hookom" wrote in message ... You have to add tblCompanyInfo table to the query/record source of your report. Right click in the background of the top pane of the query designer and choose to add a table. -- Duane Hookom MS Access MVP "Bob" wrote in message ... BottomComment was the new field I added to CompanyInfo: I cant find it in Report/Prop/control source /data/rptInvoice, but I do find it under tables futher down as Tables/tblCompanyInfo/BottomComment Thanks Bob "Duane Hookom" wrote in message ... You recently stated "Looks like I have to add it to my record source ".. you are correct. I have twice suggested that you add the table containing the field to your report's record source. If you are having trouble finding the record source, view the report properties and find the Data tab. -- Duane Hookom MS Access MVP "Bob" wrote in message ... In Properties of Text box I can add things from rptInvoice/Report but my tbBottomComment is not there I do find in down in tables/tblCompanyInfo but it will not copy from there..Thanks Bob "Bob" wrote in message ... Ok I added a new field called BottomComment to my CompanyInfo and it works when I type some thing in to it, because when I F11 I can see what I typed into the form. But On my report I can not find BottomComment? Looks like I have to add it to my record source , where would I start Thanks for your help "Duane Hookom" wrote in message ... Did you add the table to your report's record source? -- Duane Hookom MS Access MVP "Bob" wrote in message ... I have this code but I am getting that error: =tblCompanyInfo!BottomComment Thanks Bob "Bob" wrote in message ... Getting "Enter Parameter Value" error.....Thanks Bob "Duane Hookom" wrote in message ... Create a one record table and add your text into a field. Add this table to your report's record source and add the field with the text to the grid so you can display it in the report. -- Duane Hookom MS Access MVP "Bob" wrote in message ... Sorry, yes a text box but I want to save the info so each time it is printed on my invoice , unless I change the text box message at a later date..Thanks Bob "Duane Hookom" wrote in message ... What do you mean by "window"? Do you mean a text box? Is the information going to be stored in your table or just printed on a report? If you don't want to save what gets typed in, just create a text box with a control source like: =[Enter some text here] -- Duane Hookom MS Access MVP "Bob" wrote in message ... -- After searching Google.groups.com and finding no answer, Bob Vance asked: I want to have a window on my form so as what ever I type into it will appear on my Invoice. I already have 6 other windows that do the same thing to that Invoice. Thanks in advance.........Bob Vance |
#18
|
|||
|
|||
Who/what is your "coder"?
I repeat, "What is the SQL view of your query and which field are you looking for?" -- Duane Hookom MS Access MVP "Bob" wrote in message ... This is what my coder said about it: You did everything correct. Just need to add this new field in the select sql statement that brings data for the report. It is written in the Open event of Repot(Invoice) Thanks Bob....What did I actually do wrong? "Duane Hookom" wrote in message ... Did you add the field to your grid? What is the SQL view of your query and which field are you looking for? -- Duane Hookom MS Access MVP "Bob" wrote in message ... I have been doing that but my Field that I have in the table is not showing in Rpt on in a table further down, when I select it that's when I get the parameter Value error..Thanks Bob "Duane Hookom" wrote in message ... "Record Source" is a property of every report. Click the builder button [...] to the right of this property to go to the designer. -- Duane Hookom MS Access MVP "Bob" wrote in message ... Thanks , where do I find query designer exactly...Bob "Duane Hookom" wrote in message ... You have to add tblCompanyInfo table to the query/record source of your report. Right click in the background of the top pane of the query designer and choose to add a table. -- Duane Hookom MS Access MVP "Bob" wrote in message ... BottomComment was the new field I added to CompanyInfo: I cant find it in Report/Prop/control source /data/rptInvoice, but I do find it under tables futher down as Tables/tblCompanyInfo/BottomComment Thanks Bob "Duane Hookom" wrote in message ... You recently stated "Looks like I have to add it to my record source ".. you are correct. I have twice suggested that you add the table containing the field to your report's record source. If you are having trouble finding the record source, view the report properties and find the Data tab. -- Duane Hookom MS Access MVP "Bob" wrote in message ... In Properties of Text box I can add things from rptInvoice/Report but my tbBottomComment is not there I do find in down in tables/tblCompanyInfo but it will not copy from there..Thanks Bob "Bob" wrote in message ... Ok I added a new field called BottomComment to my CompanyInfo and it works when I type some thing in to it, because when I F11 I can see what I typed into the form. But On my report I can not find BottomComment? Looks like I have to add it to my record source , where would I start Thanks for your help "Duane Hookom" wrote in message ... Did you add the table to your report's record source? -- Duane Hookom MS Access MVP "Bob" wrote in message ... I have this code but I am getting that error: =tblCompanyInfo!BottomComment Thanks Bob "Bob" wrote in message ... Getting "Enter Parameter Value" error.....Thanks Bob "Duane Hookom" wrote in message ... Create a one record table and add your text into a field. Add this table to your report's record source and add the field with the text to the grid so you can display it in the report. -- Duane Hookom MS Access MVP "Bob" wrote in message ... Sorry, yes a text box but I want to save the info so each time it is printed on my invoice , unless I change the text box message at a later date..Thanks Bob "Duane Hookom" wrote in message ... What do you mean by "window"? Do you mean a text box? Is the information going to be stored in your table or just printed on a report? If you don't want to save what gets typed in, just create a text box with a control source like: =[Enter some text here] -- Duane Hookom MS Access MVP "Bob" wrote in message ... -- After searching Google.groups.com and finding no answer, Bob Vance asked: I want to have a window on my form so as what ever I type into it will appear on my Invoice. I already have 6 other windows that do the same thing to that Invoice. Thanks in advance.........Bob Vance |
#19
|
|||
|
|||
I had a coder from RAC developed a Statement/Invoice programme and I was
trying to enhance it, so I emailed him my attempt and he told me what I did wrong, but it went over my head, thought you may be able to tell me what I did wrong in lay language..Thanks Bob "Duane Hookom" wrote in message ... Who/what is your "coder"? I repeat, "What is the SQL view of your query and which field are you looking for?" -- Duane Hookom MS Access MVP "Bob" wrote in message ... This is what my coder said about it: You did everything correct. Just need to add this new field in the select sql statement that brings data for the report. It is written in the Open event of Repot(Invoice) Thanks Bob....What did I actually do wrong? "Duane Hookom" wrote in message ... Did you add the field to your grid? What is the SQL view of your query and which field are you looking for? -- Duane Hookom MS Access MVP "Bob" wrote in message ... I have been doing that but my Field that I have in the table is not showing in Rpt on in a table further down, when I select it that's when I get the parameter Value error..Thanks Bob "Duane Hookom" wrote in message ... "Record Source" is a property of every report. Click the builder button [...] to the right of this property to go to the designer. -- Duane Hookom MS Access MVP "Bob" wrote in message ... Thanks , where do I find query designer exactly...Bob "Duane Hookom" wrote in message ... You have to add tblCompanyInfo table to the query/record source of your report. Right click in the background of the top pane of the query designer and choose to add a table. -- Duane Hookom MS Access MVP "Bob" wrote in message ... BottomComment was the new field I added to CompanyInfo: I cant find it in Report/Prop/control source /data/rptInvoice, but I do find it under tables futher down as Tables/tblCompanyInfo/BottomComment Thanks Bob "Duane Hookom" wrote in message ... You recently stated "Looks like I have to add it to my record source ".. you are correct. I have twice suggested that you add the table containing the field to your report's record source. If you are having trouble finding the record source, view the report properties and find the Data tab. -- Duane Hookom MS Access MVP "Bob" wrote in message ... In Properties of Text box I can add things from rptInvoice/Report but my tbBottomComment is not there I do find in down in tables/tblCompanyInfo but it will not copy from there..Thanks Bob "Bob" wrote in message ... Ok I added a new field called BottomComment to my CompanyInfo and it works when I type some thing in to it, because when I F11 I can see what I typed into the form. But On my report I can not find BottomComment? Looks like I have to add it to my record source , where would I start Thanks for your help "Duane Hookom" wrote in message ... Did you add the table to your report's record source? -- Duane Hookom MS Access MVP "Bob" wrote in message ... I have this code but I am getting that error: =tblCompanyInfo!BottomComment Thanks Bob "Bob" wrote in message ... Getting "Enter Parameter Value" error.....Thanks Bob "Duane Hookom" wrote in message ... Create a one record table and add your text into a field. Add this table to your report's record source and add the field with the text to the grid so you can display it in the report. -- Duane Hookom MS Access MVP "Bob" wrote in message ... Sorry, yes a text box but I want to save the info so each time it is printed on my invoice , unless I change the text box message at a later date..Thanks Bob "Duane Hookom" wrote in message ... What do you mean by "window"? Do you mean a text box? Is the information going to be stored in your table or just printed on a report? If you don't want to save what gets typed in, just create a text box with a control source like: =[Enter some text here] -- Duane Hookom MS Access MVP "Bob" wrote in message ... -- After searching Google.groups.com and finding no answer, Bob Vance asked: I want to have a window on my form so as what ever I type into it will appear on my Invoice. I already have 6 other windows that do the same thing to that Invoice. Thanks in advance.........Bob Vance |
#20
|
|||
|
|||
On Thu, 22 Sep 2005 09:32:22 +1200, "Bob" wrote:
I had a coder from RAC developed a Statement/Invoice programme and I was trying to enhance it, so I emailed him my attempt and he told me what I did wrong, but it went over my head, thought you may be able to tell me what I did wrong in lay language..Thanks Bob "Duane Hookom" wrote in message ... Who/what is your "coder"? I repeat, "What is the SQL view of your query and which field are you looking for?" He probably can. But Bob, you need to help. Duane is a brilliant guy, but he's not telepathic and he cannot tell what you did wrong with your query - because *he cannot see your query*. Please open the query in design view. On the Menu, select "View" and choose the "SQL" option. You will see a screen full of SQL code. Copy and paste that code to a message here. It is the query, and Duane or I or most of the other volunteers here can read it easily, and from it hopefully determine the answer to your question. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Paste into a field in Find and Replace | Nottinghambay | General Discussion | 1 | November 2nd, 2004 05:15 PM |
How to find the gap? | Günter Brandstätter | General Discussion | 6 | September 3rd, 2004 12:02 PM |
Specify Find options | Dave The Brain | General Discussion | 3 | July 29th, 2004 04:55 PM |
decipher log of scanpst.exe | km | General Discussion | 0 | July 18th, 2004 09:00 AM |
Find Wont Find Value | Joe Gieder | Worksheet Functions | 1 | November 10th, 2003 09:17 PM |