Access Query Limit

[millercj]

Is there a limit to how much a query can analyze? If so, is there anyway to expand that? I need a way to query a table of about 170 fields with a condition similar to this

IIf([Forms]![Search]![StrideG]=True,True) Or IIf([Forms]![Search]![StrideG]<>True,True) Or IIf([Forms]![Search]![StrideG]<>True,False)

on nearly all of them and I can't get past about 70ish.

I really need ugent help on this whether it be through an easy solution or work around. I'm just kind of clueless.

 

[boblarson]

I really need ugent help on this whether it be through an easy solution or work around. I'm just kind of clueless.

Welcome to Access World Forums

Sorry to be the bearer of bad news, but it would look like you need to normalize your database first before anything. It is very, very rare to find a database table that needs more than 30-50 fields. So, why in the world would you have 170 fields? Can you post your database structure here so we can take a look and see what we can do to make suggestions to get your design to a good point where you won't have issues with getting the data back out?

 

[Banana]

I'm sorry to say but I do believe you have much more bigger problem. It is not normal for a table to contain 170 fields. A correctly designed structure would usually have several tables with less than 30 fields, more commonly less than 10 fields and associated in one-many or many-many relationship.

I'd strongly encourage you to read up on normalization. Everything else, including your original question will then be easier to solve.

 

[millercj]

Sadly, I don't even know what normalization means or how to do it. The data is imported from a web survey via a single csv file; 90% are yes/no fields. Attached is a PDF of my table.

 

[boblarson]

Sadly, I don't even know what normalization means or how to do it. The data is imported from a web survey via a single csv file; 90% are yes/no fields. Attached is a PDF of my table.

You need to try again, the attachment didn't attach.

 

[millercj]

Ok apparently, i can't post links so go to recorded-live dot com slash table.pdf

 

[Banana]

Ah, I can see why.

Normally, you would have to sanitize the csv file into the normalized format before actually stored so the queries is now easier. If you do a google, you will find several articles explaining normalization and this is what forum is for - to help others.

I seems to be missing the link for your PDF... Maybe try that again? Make sure you click "Upload", maybe?

EDIT: Gee whiz. I feel like a snail today.

 

[boblarson]

I seems to be missing the link for your PDF... Maybe try that again? Make sure you click "Upload", maybe?

Or maybe it is too big, so zip it first.

 

[millercj]

No, it's cause i'm new and I can't post them till i've hit 10 posts.

Go to the URL

www dot recorded-live dot com slash table dot pdf

 

[boblarson]

You can post file attachments regardless of your post level and you can post links that have to do with your problem with less than 10. The 10 post level is to give the admins a reason to be able to knock out signatures and such from those who come to post non help related stuff.

 

[millercj]

See attached MDB