Senin, 14 Mei 2012

[MS_AccessPros] Re: searching for zip codes and unlimited data entru in a field

 

Don, welcome to the group.

You stated: "As some individuals cover massive multiple areas, and sometimes even entire states, I need a field in the database that is virtually unlimited."

It really sounds like you are attempting to store multiple values in a single field. This is typically a bad idea. You might want to provide some basics about what you would like to do prior to developing much more.

Duane Hookom
MS Access MVP

--- In MS_Access_Professionals@yahoogroups.com, "Don" <donreider@...> wrote:
>
> 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
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar