Don-
Yes, a Memo field is "virtually unlimited" for short documents. (Up to 1 gig in
the latest versions, but you can display only the first 65,535 characters in a
text box.)
You don't say which version of Access you're using, but if it's 2007 or later,
you can embed Word documents in an Attachment data type.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
------------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Don
Sent: Monday, May 14, 2012 7:16 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] searching for zip codes and unlimited data entru in a
field
First, I am new to this group, but I am also relatively new to MS Access. I am
trying to build a database that I can use to search and create reports with. The
information stored will be on individuals and areas that they cover in a work
related environment by using zip codes. I know that a lot of fields are limited
to 255 characters. As some individuals cover massive multiple areas, and
sometimes even entire states, I need a field in the database that is virtually
unlimited. Am I correct in assuming that a memo field will work for this, and if
so, in what manner would be best to enter the data, i.e., MS Word or MS Excel?
Thanks for any help.
Don Reider
Tidak ada komentar:
Posting Komentar