I can't enter data into a field on query after I run it

[Noel]

I have a query that is ran to see how much time an appointment took. It is
run monthly. There are some "Time In" and "Time Out" times missing. Usually I
can enter those after running the query but now it won't let me. Can you tell
if there may be something coded that it is not allowing me to add data?

Thanks

 

[John W. Vinson]

I have a query that is ran to see how much time an appointment took. It is
run monthly. There are some "Time In" and "Time Out" times missing. Usually I
can enter those after running the query but now it won't let me. Can you tell
if there may be something coded that it is not allowing me to add data?

Thanks

Not without seeing the query, no! Please open it in SQL view and post the SQL
text here.

 

[Tom Wickerath]

Hi Noel,

Check out this page on Access MVP Allen Browne's web site:

Why is my query read-only?
http://www.allenbrowne.com/ser-61.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________