Memo Fields

[Guest]

Hi every body,

I have a wee problem that I hope some kind soul can help me with. For some
reason I have 2 versions of the same DB on 2 different networks, but I don't
know which is the most upto date, the DB contains one table (Iknow bad design
but hey I'm picking this up) what I would like to do is run a querry of some
sort on the most likely fields that have been changed, however these are memo
types, is this possible? I tried a unmatched but that didn't work, and if it
is how would I do it?

MTIA,
Souchie40

 

[Arvin Meyer [MVP]]

There is no way to know which is the latest by just the data. If there has
been design changes, you can change the view to Details and check the last
modified date. That won't help with data. You can check the amount of data
in a field by checking its length in a query:

Select Len([My Memo Field]) As Expr1, * From MyTable;

 

[Guest]

Well Ithought that was the case but if you don't ask you don't get, never
mind I'll have to line by line the 2 DB's

Souchie40

There is no way to know which is the latest by just the data. If there has
been design changes, you can change the view to Details and check the last
modified date. That won't help with data. You can check the amount of data
in a field by checking its length in a query:

Select Len([My Memo Field]) As Expr1, * From MyTable;
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hi every body,

I have a wee problem that I hope some kind soul can help me with. For
some
reason I have 2 versions of the same DB on 2 different networks, but I
don't
know which is the most upto date, the DB contains one table (Iknow bad
design
but hey I'm picking this up) what I would like to do is run a querry of
some
sort on the most likely fields that have been changed, however these are
memo
types, is this possible? I tried a unmatched but that didn't work, and if
it
is how would I do it?

MTIA,
Souchie40