query question need help with

D

davidhull

Hi guys, i have a quick one here, if i have set up a query to exclude
surnames with
"Z-" but have found that some fields have had "Z -" in them will these
records have been included in my query, this is a query that has been used
for a while now

also i have now changed all the surnames to "Z-" with no space, i assume
that access has a history where if these "Z -" were not included i could pull
them even if they have nowbeen changed to have no space. sorry for the long
waffle.
 
A

Andy Hull

Hi David

Whether the "Z -" records were included in past runs of your query depends
what criteria you used - which you haven't stated.

If you used...

WHERE Surname Like "Z*"

then yes, they would have been included but if you used...

WHERE Surname Like "Z-*"

then they wouldn't.

Of course, you may have used a different criteria entirely. If so, post
back with it if you need to.

I'm not sure what you are after in your 2nd question. Now the records are
changed, there is no way to see which ones used to be "Z -" unless you
changed them using a feature programmed into your database which records the
history so you'd need to ask the developer - but access doesn't do this by
default.

Regards

Andy Hull
 
D

davidhull

Thanks Andy for your response, i have queried the data with Not Like "Z-*"
and also
Not Like "Z-*" Or Like "Z -*" and both the results are the same so what
you said about the database is also correct it doesnt retain the history
unfortunately :<

Cheers
 
A

Andy Hull

Hi again David

One last possible chance is if you have backups of the database.

If you have one from before you updated all "Z -" records to "Z-" then you
could use this to identify them in the current db.

If you haven't got a history of backups but you're working on a company
network, maybe there is a reguar network backup that someone can retrieve an
older version of the db from?

Andy Hull
 
Top