Recent content by danabides

thanks pat and trumpet. my life just became so much more pleasant.

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...

keithg, that was so quick and helpful i may just click that scale twice

in report design view put the expression in the footer

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...

after toying around with your first post, i finally figured it out. thanks, pat!

thanks pat, but i must be missing something key here. i queryed for the criteria i wanted, in this case 'member status'=A. and then i joined that query to a larger table, which does not contain the column 'member status'. so, when i run the query all records retrieved are deemed 'member...

sounds like you might want to run a crosstab query. your row heading should be 'training level' and your value would be machine operators. group by 'count'. that will tell you how many operators are at each training level.

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...