do queries have same number of fields limitation


M

msmcnewsxp

do queries have the same limitation as tables of 255 fields.

how can one-to-one tables to join to form one record source if too many
fields?

need quick answer.

thanks,
mcnews
 
Ad

Advertisements

J

John Vinson

do queries have the same limitation as tables of 255 fields.
Yes.

how can one-to-one tables to join to form one record source if too many
fields?
You can't.
need quick answer.
It's not the one you're hoping for, I'm sure, but that's the answer. A
Recordset can have 255 fields, no more, and there is no way around
this limitation.

Could you describe the BUSINESS PROBLEM that you are trying to solve?
I have never yet seen a valid Entity with 255 discrete, nonrepeating,
atomic attributes!
 
M

msmcnewsxp

Could you describe the BUSINESS PROBLEM that you are trying to solve?
I have never yet seen a valid Entity with 255 discrete, nonrepeating,
atomic attributes!
this is a field survey for a disease/outbreak study.
the data always ends up being used in a program called SAS which likes data
in a flat file format.
the interface mirrors a hard copy questionaire.
using a normalized database only complicates and slows down the analysis
process.
all of these surveys are last minute cobbled together.
we're lucky to get people to use even this good in these situations.
so sorry to go against the grain here but trial and error has proven this
out.
 
Ad

Advertisements

M

msmcnewsxp

i'm not there to assemble the data.
analysts want to be able to run queries on the data in the field usually 3rd
world countries and other remote locations.
very few epidemiologists are savvy query builders.

this is an old problem.
even getting these people to use access is a large step forward.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top