Share via

Pulling wrong data over in Access query

Anonymous
2015-07-10T19:57:23+00:00

I hate to ask a foolish question but I'm very green with Access and need some help.  I created a query in Access.  I was in the Design View.  I thought I was copying and pasting a column over to a new location on the layout, but instead now the data from the field I was copying (area code) keepings showing up in the other field (which should be the web address).  I've tried recreating the query, and even looked at other queries I had previously made and the data is just not pulling from the right field any longer.  Can someone help me get back on track with this?  Sorry to ask such a foolish question, which I hope makes some sense, but could use some help.  Thanks in advance for your assistance.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-07-10T20:57:35+00:00

    Hope you have a backup of the database, or at least of the data that went into it.. :-{(

    A Query is just a VIEW of the data in your table. When you copy and paste data in a Query, it is actually updating - overwriting and permanently destroying - the data in the table.

    Query datasheets are not particularly good for data presentation (this experience is just one reason, they are MUCH too vulnerable to data-destroying mistakes!). You should instead create a Report or a Form based on the query, and do your layout work there instead of in the query.

    Was this answer helpful?

    0 comments