Inconsistent results with a simle query

[slickdog]

Hi
I am running MSaccess 2007


I am using a query from a from button to list, in the query, just the current form data. I wan to use this further in a report which I was able to do. To troubleshoot I disabled the button from picking the report and just selecting the query.


In the query I am using [Forms]![Call Log]![Call Data ID] for the criteria under Field 'Call Data ID' and Table 'Call Log', no sort and show =Yes.
where 'Call Data ID' is the primary key in 'Call log'


I only have 15 records in 'Call log' at the moment.




when I run the query With Call Data ID parameter between 1 and 8 the query runs OK however when I use a higher number i.e. for records 9 through to 15 teh query returns nothing.


I do not understand this at all. the primary key 'Call Data ID' is from an auto number for each new record so the data type seems ok.
Just like to say this is my first real look at Database set up.

I want eventuall show a simple report fro a record as I log it in then email that report to a client as this is a call recording database fro a Answering service.
I was able to have it all work ok opening the report then using the email button in the main access program. but found that after record 8 no data was picked up.

[ItsMe]

Have you tried adding criteria to a simple SELECT query? If you add your ID column to a select query and then type the following in the Criteria row, your query should retrieve specific records.

Between 1 And 9

[slickdog]

Sorry but that's no what I want, I think I must have written my question badly.

It is returning info 1 through to 8. If I am record 1 or 2 up to 8 it shows the data, but at 9 or after the query returns nothing it should return a single record in the query no matter what record I'm at.

[ItsMe]

You can test your query by changing the criteria. I suggest you do this before incorporating other factors like forms. In one test of a simple query object you can use Between 1 And 9. In another test of your query object you can use Between 10 And 20. Afterwards, you can add other factors like including a form object in your query's criteria.

[slickdog]

Sorry but that's no what I want, I think I must have written my question badly.

It is returning info 1 through to 8. If I am record 1 or 2 up to 8 it shows the data, but at 9 or after the query returns nothing it should return a single record in the query no matter what record I'm at.

I have it fixed now.
I believe there were two things wrong.

1. I used Employee ID twice once for the person who takes calls (Operator) and once for the person who Send the call data on to the Client. we had not logged the sending of the data on on two occasions. .
2. Then as I was in the data I checked For occasions where the operator and the sender were different and the first was at record No 9 of which I could not see passed when running the query.

I then added another Employees table into the query - "Employees_1" un-linked "Sent by" and Employee ID from "Employees" in the Query and linked "Sent By" to Employee ID in "Employees_1". it all now works.