| Re: Data entered thru form not picked up in query |
|
 |
|
 |
|
 |
|
 |
Group: microsoft.public.access.forms · Group Profile
Author: mrsapjmrsapj Date: Jul 23, 2008 22:43
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" wrote:
> Post the SQL statement of your query.
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "mrsapj" discussions.microsoft.com> wrote in message
> news:C46ED713-CFAE-44CC-B43C-6AA872840770@microsoft.com...>>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.
>>
>
>
>
| 
