Query Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a size limit on the number of fields in a query in Access? I'm
trying to execute a very simple query but there are about 70 fields in the
table it is pulling information from.

The only select is a "Like [Forms]![Add_Checklist]![ChecklistID] and
Checklist_ID is an int. I am getting prompted for the value when I try to
open the query in datasheet view. Is this a size issue? I've triple checked
everything else and it's all fine.
 
SELECT *
FROM Checklist
WHERE (((Checklist.Checklist_ID) Like
[Forms]![Add_Checklist]![Checklist_ID]));

......
 
Is there a size limit on the number of fields in a query in Access? I'm
trying to execute a very simple query but there are about 70 fields in the
table it is pulling information from.

The only select is a "Like [Forms]![Add_Checklist]![ChecklistID] and
Checklist_ID is an int. I am getting prompted for the value when I try to
open the query in datasheet view. Is this a size issue? I've triple checked
everything else and it's all fine.
Click to expand...

The LIKE operator is used for searching Text fields with wildcards. If
you're searching for an INT then the = operator will be better (and
will give exactly the same results).

You're limited to 2000 bytes *actually occupied* in a Table. I don't
think that's the issue here; I suspect that you're running the query
when the form is not open. If that's the case you'll be prompted for
the parameter. Typically one would use a command button on the
Add_Checklist form to open the Query or (better) open a separate Form
or Report based on the query; that way the form will certainly be
open.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top