Return Table Field

  • Thread starter Thread starter shapper
  • Start date Start date
S

shapper

Hello,

I have an Access Database with 3 fields: ID, Title and Text.

Is it possible, when selecting a few records, to change the field
names?

My query would change the name of field "Text" to "Description".

Thanks,
Miguel
 
Brendan's given the SQL that you need to use. To do this in the graphical
query builder, simply put Description: in front of Text in the field cell
(make sure you include the colon!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split data in field on character return 0
Count text values in a Access Field 0
Select Records 1
#error - Blank 3
extract 3 numbers from a string 0
Query on two tables with matching null fields 4
Numeric Field Overflow Error 5
dynamic calculated field in query 3

Back
Top