Update Query does not allways work

[newtoAccess]

This update query works at home. When I take to to a another access 2007 machine it does not work.
Any reason why?


UPDATE [Name-Address] SET [Name-Address].L_Init = Left([Name-Address]![L_Name],1), [Name-Address].F_Init = Left([Name-Address]![F_Name],1), [Name-Address].Init_Last_Name = [Name-Address]![F_Init] & " " & [Name-Address]![L_Name], [Name-Address].FName_Init = [Name-Address]![F_Name] & " " & [Name-Address]![L_Init], [Name-Address].[Full Name] = [Name-Address]![F_Name] & " " & [Name-Address]![L_Name];

[weekend00]

can you provide more detail about "it does not work"?
what do you have, what do you expect, what happen, or any error messages

[SteveF]

This update query works at home. When I take to to a another access 2007 machine it does not work.
Any reason why?


UPDATE [Name-Address] SET [Name-Address].L_Init = Left([Name-Address]![L_Name],1), [Name-Address].F_Init = Left([Name-Address]![F_Name],1), [Name-Address].Init_Last_Name = [Name-Address]![F_Init] & " " & [Name-Address]![L_Name], [Name-Address].FName_Init = [Name-Address]![F_Name] & " " & [Name-Address]![L_Init], [Name-Address].[Full Name] = [Name-Address]![F_Name] & " " & [Name-Address]![L_Name];

PMFJI, but why would you want to do this in the first place? Forgive me if this seems rude, but this is just taking up needless space in your table for something that only needs to be done on an as-needed basis. If you want these extra fields for a form or report, just build a select query with these as calculated fields.

This is one of the things that queries are for!

Steve

[newtoAccess]

Ok, I will build a query, and run the query every time I need the info.