Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Access issue


  • Please log in to reply

#1
Shorty1967

Shorty1967

    New Member

  • Member
  • Pip
  • 1 posts

What would cause Access to change the name of a field in a query to include the table?  I created a query (qryAssessingKit_B) that takes the data from another query (qryAssessingKit_A). When I look at it in datasheet view the field names become:

 

qryAssessingKit_A.name of field

 

Instead of just name of field.

 

I have never experienced this in other databases I have created and am wondering if it is a setting somewhere that I cannot seem to find.  My brain is telling me I have something going that Access doesn't like, but I've done queries like this before and didn't have this particular issue.

 

Any help would be greatly appreciated!


  • 0

Advertisements


#2
SleepyDude

SleepyDude

    Trusted Helper

  • Malware Removal
  • 4,381 posts

Hi,

 

I don't work with access for a very long time but if I remember correctly that could happen if you have the same name of field in more than one table/query in that case access adds the source name to ID the correct field.


  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP