Query behaving very strange

Fuerteventura

Board Regular
Joined
Aug 23, 2005
Messages
80
Can anyone explain what is going on here-I've created a query with basic criteria but when I run the query, it is displaying all records, only all of the records are the same - at first I though I'd selected an update query by accident but it is a select query. It doesn't change any of the data - when you look at the table which it is running off all is fine. Very strange!

EDIT - two things: 1 - I've sorted it - 2 - This is on the wrong forum - sorry! What a muppet!!!!!!
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Watch MrExcel Video

Forum statistics

Threads
1,119,265
Messages
5,577,088
Members
412,764
Latest member
Brawler
Top