Adding a field to a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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]...
 
Back
Top