Data entered thru form not picked up in query

[mrsapj]

I am working on a database started by someone else. It consisted of a table
with data already in it. All the data was entered directly to the table. I
have since created a form for data entry,a form for a query, and a report.
The process seems to be working except, I have noticed the query is not
picking up any new data that has since been entered thru the form. The data
entry form
seems to be working and it is populating the table, but my query is not
bringing back any record past 234, which is where I began entering data thru
the form. Any suggestions on what to look for to fix the problem.

 

[Jeff Boyce]

Post the SQL statement of your query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[mrsapj]

SELECT DISTINCTROW Literature.ID, Literature.Year, Literature.Title,
Literature.[Fish Species], Literature.Keyword, Literature.Keywords,
Literature.[Author Last Name], Literature.[Author Citation]
FROM Literature
GROUP BY Literature.ID, Literature.Year, Literature.Title, Literature.[Fish
Species], Literature.Keyword, Literature.Keywords, Literature.[Author Last
Name], Literature.[Author Citation]
HAVING (((Literature.[Fish Species]) Like "*" &
[Forms]![ReferenceSearch]![Fish_Species_qry] & "*") AND ((Literature.Keyword)
Like "*" & [Forms]![ReferenceSearch]![keyword_qry] & "*") AND
((Literature.Keywords) Like "*" & [Forms]![ReferenceSearch]![2ndkeyword_qry]
& "*") AND ((Literature.[Author Last Name]) Like "*" &
[Forms]![ReferenceSearch]![PrimAuthur_qry] & "*") AND ((Literature.[Author
Citation]) Like "*" & [Forms]![ReferenceSearch]![2ndauthor_qry] & "*"))
ORDER BY Literature.[Fish Species];

 

[Jeff Boyce]

Nothing jumped out in the SQL statement.

Have you tried starting from scratch and building a new query?

Regards

Jeff Boyce
Microsoft Office/Access MVP

SELECT DISTINCTROW Literature.ID, Literature.Year, Literature.Title,
Literature.[Fish Species], Literature.Keyword, Literature.Keywords,
Literature.[Author Last Name], Literature.[Author Citation]
FROM Literature
GROUP BY Literature.ID, Literature.Year, Literature.Title,
Literature.[Fish
Species], Literature.Keyword, Literature.Keywords, Literature.[Author Last
Name], Literature.[Author Citation]
HAVING (((Literature.[Fish Species]) Like "*" &
[Forms]![ReferenceSearch]![Fish_Species_qry] & "*") AND
((Literature.Keyword)
Like "*" & [Forms]![ReferenceSearch]![keyword_qry] & "*") AND
((Literature.Keywords) Like "*" &
[Forms]![ReferenceSearch]![2ndkeyword_qry]
& "*") AND ((Literature.[Author Last Name]) Like "*" &
[Forms]![ReferenceSearch]![PrimAuthur_qry] & "*") AND ((Literature.[Author
Citation]) Like "*" & [Forms]![ReferenceSearch]![2ndauthor_qry] & "*"))
ORDER BY Literature.[Fish Species];

Post the SQL statement of your query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[mrsapj]

Yes..I have started writing a new query...will see how it goes

Nothing jumped out in the SQL statement.

Have you tried starting from scratch and building a new query?

Regards

Jeff Boyce
Microsoft Office/Access MVP

SELECT DISTINCTROW Literature.ID, Literature.Year, Literature.Title,
Literature.[Fish Species], Literature.Keyword, Literature.Keywords,
Literature.[Author Last Name], Literature.[Author Citation]
FROM Literature
GROUP BY Literature.ID, Literature.Year, Literature.Title,
Literature.[Fish
Species], Literature.Keyword, Literature.Keywords, Literature.[Author Last
Name], Literature.[Author Citation]
HAVING (((Literature.[Fish Species]) Like "*" &
[Forms]![ReferenceSearch]![Fish_Species_qry] & "*") AND
((Literature.Keyword)
Like "*" & [Forms]![ReferenceSearch]![keyword_qry] & "*") AND
((Literature.Keywords) Like "*" &
[Forms]![ReferenceSearch]![2ndkeyword_qry]
& "*") AND ((Literature.[Author Last Name]) Like "*" &
[Forms]![ReferenceSearch]![PrimAuthur_qry] & "*") AND ((Literature.[Author
Citation]) Like "*" & [Forms]![ReferenceSearch]![2ndauthor_qry] & "*"))
ORDER BY Literature.[Fish Species];

Post the SQL statement of your query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am working on a database started by someone else. It consisted of a
table
with data already in it. All the data was entered directly to the
table.
I
have since created a form for data entry,a form for a query, and a
report.
The process seems to be working except, I have noticed the query is not
picking up any new data that has since been entered thru the form. The
data
entry form
seems to be working and it is populating the table, but my query is not
bringing back any record past 234, which is where I began entering data
thru
the form. Any suggestions on what to look for to fix the problem.