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 |
#1
|
|||
|
|||
my Access form will not print preview...something about my SQL
I am trying to preview my form and the message keeps coming up " The
specified field 'PostalCode' could refer to more than one table listed in the FROM clause of your SQL statement." Now PostalCode shows up in my Customer's table and the table that it is linked to it callled table 1. The SQL statement is taking the data from the PostalCode in table1. If I try to change this to the Customer table it doesn't change anything. As far as I can tell everything is correctly spelled. Thanks for you help Shell |
#2
|
|||
|
|||
my Access form will not print preview...something about my SQL
Does your SQL statement specifically spell out which table, as in:
SELECT Table1.PostalCode ... Sprinks "Shell" wrote: I am trying to preview my form and the message keeps coming up " The specified field 'PostalCode' could refer to more than one table listed in the FROM clause of your SQL statement." Now PostalCode shows up in my Customer's table and the table that it is linked to it callled table 1. The SQL statement is taking the data from the PostalCode in table1. If I try to change this to the Customer table it doesn't change anything. As far as I can tell everything is correctly spelled. Thanks for you help Shell |
#3
|
|||
|
|||
my Access form will not print preview...something about my SQL
Yes it does.... that is exactly what it says.... I have a PostalCode in
table1 and in my Customers table.... The SQL statement takes it from Table1 "Sprinks" wrote: Does your SQL statement specifically spell out which table, as in: SELECT Table1.PostalCode ... Sprinks "Shell" wrote: I am trying to preview my form and the message keeps coming up " The specified field 'PostalCode' could refer to more than one table listed in the FROM clause of your SQL statement." Now PostalCode shows up in my Customer's table and the table that it is linked to it callled table 1. The SQL statement is taking the data from the PostalCode in table1. If I try to change this to the Customer table it doesn't change anything. As far as I can tell everything is correctly spelled. Thanks for you help Shell |
#4
|
|||
|
|||
my Access form will not print preview...something about my SQL
Can you provide the SQL view of your form's record source?
-- Duane Hookom MS Access MVP -- "Shell" wrote in message ... Yes it does.... that is exactly what it says.... I have a PostalCode in table1 and in my Customers table.... The SQL statement takes it from Table1 "Sprinks" wrote: Does your SQL statement specifically spell out which table, as in: SELECT Table1.PostalCode ... Sprinks "Shell" wrote: I am trying to preview my form and the message keeps coming up " The specified field 'PostalCode' could refer to more than one table listed in the FROM clause of your SQL statement." Now PostalCode shows up in my Customer's table and the table that it is linked to it callled table 1. The SQL statement is taking the data from the PostalCode in table1. If I try to change this to the Customer table it doesn't change anything. As far as I can tell everything is correctly spelled. Thanks for you help Shell |
#5
|
|||
|
|||
my Access form will not print preview...something about my SQL
Sure can...
SELECT [Table1].[CustomerID], [Table1].[CompanyName], [Table1].[FirstName], [Table1].[LastName], [Table1].[BillingAddress], [Table1].[Table2_ID], [Table2].[City/Town], [Table1].[PostalCode], [Table3].[Province], [Table1].[PhoneNumber], [Table3].[FaxNumber], [Table1].[Notes] FROM Table1 LEFT JOIN (Table2 LEFT JOIN Table3 ON [Table2].[Table3_ID]=[Table3].[ID]) ON [Table1].[Table2_ID]=[Table2].[ID]; hope you can help.... Shell "Duane Hookom" wrote: Can you provide the SQL view of your form's record source? -- Duane Hookom MS Access MVP -- "Shell" wrote in message ... Yes it does.... that is exactly what it says.... I have a PostalCode in table1 and in my Customers table.... The SQL statement takes it from Table1 "Sprinks" wrote: Does your SQL statement specifically spell out which table, as in: SELECT Table1.PostalCode ... Sprinks "Shell" wrote: I am trying to preview my form and the message keeps coming up " The specified field 'PostalCode' could refer to more than one table listed in the FROM clause of your SQL statement." Now PostalCode shows up in my Customer's table and the table that it is linked to it callled table 1. The SQL statement is taking the data from the PostalCode in table1. If I try to change this to the Customer table it doesn't change anything. As far as I can tell everything is correctly spelled. Thanks for you help Shell |
#6
|
|||
|
|||
my Access form will not print preview...something about my SQL
Is your report's record source a saved query or is it the SQL statement? Try
to save it as a query and then try again. One tip that makes my life much easier is that no two fields in an mdb have the same name. -- Duane Hookom MS Access MVP "Shell" wrote in message ... Sure can... SELECT [Table1].[CustomerID], [Table1].[CompanyName], [Table1].[FirstName], [Table1].[LastName], [Table1].[BillingAddress], [Table1].[Table2_ID], [Table2].[City/Town], [Table1].[PostalCode], [Table3].[Province], [Table1].[PhoneNumber], [Table3].[FaxNumber], [Table1].[Notes] FROM Table1 LEFT JOIN (Table2 LEFT JOIN Table3 ON [Table2].[Table3_ID]=[Table3].[ID]) ON [Table1].[Table2_ID]=[Table2].[ID]; hope you can help.... Shell "Duane Hookom" wrote: Can you provide the SQL view of your form's record source? -- Duane Hookom MS Access MVP -- "Shell" wrote in message ... Yes it does.... that is exactly what it says.... I have a PostalCode in table1 and in my Customers table.... The SQL statement takes it from Table1 "Sprinks" wrote: Does your SQL statement specifically spell out which table, as in: SELECT Table1.PostalCode ... Sprinks "Shell" wrote: I am trying to preview my form and the message keeps coming up " The specified field 'PostalCode' could refer to more than one table listed in the FROM clause of your SQL statement." Now PostalCode shows up in my Customer's table and the table that it is linked to it callled table 1. The SQL statement is taking the data from the PostalCode in table1. If I try to change this to the Customer table it doesn't change anything. As far as I can tell everything is correctly spelled. Thanks for you help Shell |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Move feild entries from form to form using global variables | JackCGW | General Discussion | 11 | November 14th, 2005 05:22 AM |
Access Mail Merge to Word.doc files ? | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 18th, 2005 06:31 PM |
2002 vs 2003 | Patrick Stubbin | General Discussion | 2 | May 17th, 2005 07:27 AM |
How do I print the details view | David | Running & Setting Up Queries | 5 | August 28th, 2004 12:17 AM |
Access and SQL | AHopper | General Discussion | 26 | August 3rd, 2004 07:01 PM |