Basic Question

[za20001]

Hi -- Beginner user of Access 2000.



I have two tables, (A) and (B).

Column (1) of table (A) holds a series of unique text values (names).
Column (2) of table (B) holds a series of unique text values (names).
Column (4) of table (B) holds numbers (salaries) associated with the names in column (2).

I want to output a table thus:
Column (1) of table (A) | Column (4) of table (B), Column (1) of table (A) = Column (2) of table (B), NULL otherwise

Table (A) has additional information I want to include with each record, so running a query of table (B) alone won't work.

My code is below. Thanks.

SELECT 2008counts.user_name, 2008fees.fees
INTO 2008complete
FROM 2008counts
LEFT OUTER JOIN 2008fees
ON 2008counts.user_name = 2008fees.user_name
;

I receive this error:
"Syntax error (missing operator) in query expression '2008counts.user_name'."
After clicking, 'OK', the cursor positions at 'counts' in the SELECT line.

Using Access2000.

[ssanfu]

It seems to me that somewhere (or is it somewhen) I read that table names should never begin with a number....

Anyway, try this:

SELECT [2008counts].user_name, [2008fees].fees
INTO 2008complete
FROM 2008counts
LEFT OUTER JOIN 2008fees
ON [2008counts].user_name = [2008fees].user_name;

I looks to me that some Excel spreadsheets were imported into Access - this indicates that the Access structure is not normalized.... could cause more problems......

[za20001]

That worked. Thanks. Good to know -- won't make tables again that start with numbers.