Recent content by rjhe22

will try that thanks

i have 2 tables.. what i want to do is run a query that shows whats in 1 table but not the other how can this be done. i have tried a few different things and cant get it

sorry didnt explain my self well. top 1 wont work as i have 500 records with 20 different accountname want the 20 names

i have a query and i want it to pull back just one of the account name instead of having 6 of the same account names showin up but it does not seem to work for me here is my query SELECT DISTINCT [Fs_0003_Access_Stats].AccountName, [Fs_0003_Access_Stats].ID, [Fs_0003_Access_Stats].AccessPath...

cause they have paid for 2007 and want to use it so they wont go back

they dont want to go back to 2003 they want to use 2007 so i can t do that. any ideas on why it happened or did anyone come accross this

i cant the company moved them over and want 2007

HI all i have an application done in access 2003. we are now using access 2007. there seems to be a few problem with the app since we starting using 2007. anyone any ideas how the problems can be fixed