Search results

Hi Experts. I have a query question..can't seem to figure this out....:banghead: I have two tables A and B.. In Table A, I would like to trim out rows not in between Min and Max numbers in Table B. The resulting Table should be Table C. Could anyone tell me what the SQL or how to design the...

Hi Folks I have two tables. Archive1 and Archive2 with exactly the same field setup. I want to delete from Archive1 where the record exists in Archive2. I've seen a lot of question of this sort on the web and here but I can't quite figure it out. Surely the query must be simple. Cheers...

Hi all, I want to query below table as such. SELECT DISTINCT ID FROM Table ORDER by ID Table ID Field1 1 a 1 f 2 gh 2 fd 5 df This would give me ID 1 2 5 I also want to add on to the above query two more records 7 & 8 so i want the final table to look like ID 1 2 5 7...

Hi all, VBA newbie here i want to write a vba code to loop through a column in my table and check for a condition, and where it does not equal that condition i want it to display the whole row in a message box and ask to amend the field to meet that condition. If i say Yes i want the amendment...

Newbie here. New to Access. Looks like my job is going to be very data and access intensive. Hope to learn and share much from everyone here. Cheers A:D