Search results

SELECT [Dec 2005].Nick AS [Dec 2005_Nick], [Jan 2006].Nick AS [Jan 2006_Nick] FROM [Dec 2005] INNER JOIN [Jan 2006] ON [Dec 2005].[Nick] = [Jan 2006].[Nick]; columns with names are called nick for now, cause access didn't allow me to use word 'name' 1 nick column from each table is...

there is only one relation between tables, it's related by name field/column... I use wizard, not sure about sql...

Hi, I have to tables. In both are names, some duplicate, some ginuine. When I run query choosing just a name column from each table, it doesn't return all names. It just give me duplicate ones. How to have all names included in the query list? Cheers

cheers, Bob

Hi, I'm fairly new to Access. I have few questions. How to set up database so it searches through my table, finds the name and inputs it into letter in a space I want? Where does this letter suppose to be located in the file? Thank you IOI