Not able to click box in query, help please

[NSmoller]

i initially asked this in another thread, i want to make this a separate topic because i think it requires more attention, since i still cant get it to work

HERE's the query:
SELECT l.MD, l.Patient, l.SSN, l.Drug, l.LASTFILL AS [Last Fill], l.[MD Aware] AS [MD Aware?]
FROM coreg AS L INNER JOIN md ON left(l.md,4)=left(md.md,4)
WHERE Complete=False And [md aware]=False AND md.clinicid=1 AND LASTFILL>#7/1/2005# and Facility='Albany'
ORDER BY l.md, l.lastfill;

in access, i have an accurate list of patients. i cannot however click on the MD AWARE column (yes/no data type) to change the data in the main table, "Coreg"

The inner join suggestion was that of another member, but still no success.

Thanks

 

[lespaul]

do you get an error message? What 'box' appears in the query?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

I'd try to add the primary key of md in the SELECT clause.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886