Search results

im trying to perform an append query, but for some reason cannot due to 'key violations'. the primary keys in both tables are exactly the same. im trying to append a row from one table to the other without creating additional records. i can do the append, creating additional records when i...

I generally use Cognos for my queries, so the overly user friendlyness of access is confusing me and im not proficient enough in sql to just go in and edit the code... How do i generate a query that groups data in unique ways in the result, but does not change the data in the originating table...

Hi all, Simple problem, but my access and sql skills are very limited. I have two tables. One containing a group of frequent customers with a column called 'member status'. Another table containing a group of non-customers. The addresses in both tables have been matched using group1...