A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Appending column with different data type



 
 
Thread Tools Display Modes
  #1  
Old November 27th, 2006, 04:11 PM posted to microsoft.public.access.queries
JoeA2006
external usenet poster
 
Posts: 114
Default Appending column with different data type

I need to append rows from a query to a table and then export this data to
Excel.
I would like to be able to sum the columns with a macro in Excel. The
problem is I have columns in the query which contain numeric values that need
to be appended to columns that are text in the table(I assume it is because
they are null ). When I change the table design for these columns to
currency, Access will not append the records. I created columns with no data
Column1'') so I could have a column to append records to, because the table
has columns not in the query and the vice versa.
Is there a way to accomplish this?
  #2  
Old November 27th, 2006, 04:32 PM posted to microsoft.public.access.queries
kingston via AccessMonster.com
external usenet poster
 
Posts: 620
Default Appending column with different data type

Revert back to your original table design so that the export works. In Excel,
add a column that multiplies the original field by 1; this will convert the
data to a number. Modify your macro to work on the new calculated column.
You can hide the additional column so the change is transparent to the user.

JoeA2006 wrote:
I need to append rows from a query to a table and then export this data to
Excel.
I would like to be able to sum the columns with a macro in Excel. The
problem is I have columns in the query which contain numeric values that need
to be appended to columns that are text in the table(I assume it is because
they are null ). When I change the table design for these columns to
currency, Access will not append the records. I created columns with no data
Column1'') so I could have a column to append records to, because the table
has columns not in the query and the vice versa.
Is there a way to accomplish this?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200611/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.