Adding a field to a query

  • Thread starter Tracy Forced to Use Access
  • Start date
T

Tracy Forced to Use Access

I have one table that is broken down in 6 different queries. I need to
created a field that will populate back to the table, if possible, to let me
know which query it was on. Is this possible?
 
W

Wayne-in-Manchester

Sorry but am a bit confused by this one. Do you want to change some data in
a query and the results that are save will not only show the data you have
entered but also concencate the name of the query

Enter into [NameOfField] 1234
Result = 1234 - query number 1 - NameOfField

I may have misunderstood what you're looking for can you give an example
 
D

Duane Hookom

If I understand correctly, you want to create a calculated column in a query
that identifies the query. If so, you can create a column with an expression
like:
SourceQuery: "qselMyQuery"

--
Duane Hookom
MS Access MVP

"Tracy "Forced to Use Access"" <Tracy "Forced to Use
Access"@discussions.microsoft.com> wrote in message
news:[email protected]...
 
Top