Recent content by Rick84

Fantastic guys thanks! it was the "where function i was missing!"

Hi Im reasonably new to access databases so I still to like to build my queries in the design view rather than pure SQL. My question is: I have a table with the columns; Month_Num | Amount (which is linked to others) 1 | 2000 2 | 3000 3 | 3500 4 | 3600 5 | 2800 6 | 3000 7...