I am trying to set up a datbase program for a mortagage broker whose whats to
be able to search his lenders by Program Highlights? Such as who will lend a
FICO SCORE OF, to Self Employed, and CCS member? How refined can a querey
search get
Well... how refined do you want? How are you planning to store the
data?
There is a limit of 65,536 bytes in a (compiled) query expression. If
you have fields in your table for this information, you can use AND
logic, OR logic, lists of values, ranges of values, pretty much
anything that you can phrase as a logical expression. The limit for
the size of a table is 2 billion bytes (less a little overhead) so you
shouldn't have much trouble there.
Bear in mind: those of us who volunteer here know databases; we aren't
generally knowledgable about the mortgage brokering industry. I for
one have no clue what a FICO score might be, or what CCS means, nor
what you mean by "program highlights". But if these are kinds of
information which can be stored as text strings, as numbers, or as
yes/no values then yes - Access can search them.
John W. Vinson[MVP]
