Noob question on queries (1 Viewer)

SJS66

Registered User.
Local time
Today, 08:07
Joined
Aug 8, 2017
Messages
26
Bit of a noob question here. I've noticed when I create a query and view it in Datasheet view, I can't add any records to it. There's no row starting with the * to enter a new record. Why? What am I doing wrong?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:07
Joined
May 7, 2009
Messages
19,246
Maybe the query is not updatable
 

SJS66

Registered User.
Local time
Today, 08:07
Joined
Aug 8, 2017
Messages
26
Thanks. How do you check if it is & if not, can you make it updatable?
 

SJS66

Registered User.
Local time
Today, 08:07
Joined
Aug 8, 2017
Messages
26
Have a look at this link to Allen Browne's website:
Why is my query read only?
Cheers. Can't seem to find the problem.....delete and back to studies for this little black duck. Umm.....am I allowed to say that these days? Eh...who cares...and just to clarify...I'm neither, but I still love Daffy Duck.:p
 

Users who are viewing this thread

Top Bottom