• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

Appending field to an open recordset.

Here is what I need:

  I need to retrieve a set of records with 5 fields in the recordset.
  I need to append an extra field to this retrieved recordset.
  MS says this is not possible, at least not using APPEND.
  Any other ideas (other than the obvious idea of copying all data to a new recordset, field by field...)

I would really prefer some sort of an example, if possible.
0
taplin
Asked:
taplin
  • 4
  • 3
1 Solution
 
TimCotteeCommented:
create a dummy field in your sql select statement:

SELECT Field1,Field2,Field3,Field4,Field5,"Empty Field" as Field6 FROM File Where Something

0
 
taplinAuthor Commented:
Very nice!  Absolutely perfect... thanks... I'm increasing the points to 150, just because the answer is so sweet.  If you only get the original 100, let me know, I'll send you the other 50.
0
 
taplinAuthor Commented:
I'll bet you only got 100 points...
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
TimCotteeCommented:
To be honest I don't know, as I haven't had the notification of your acceptance yet, though I have received the additional comment notification. But glad you like the answer anyway.
0
 
TimCotteeCommented:
Now I have had the notification it tells me 400 points, the answer may have been sweet but you didn't have to give me that many !
0
 
taplinAuthor Commented:
Actually, I didn't... when I answer questions, I get more points than deserved too...
0
 
TimCotteeCommented:
I am not going to complain anyway.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now