Quick access/vba question

[Al Neri]

Ok, I programmed back in the 80s in basic, so keep in mind, I have that kind of mentality... that being said...

I need to export to excel under column A the contents of one column in an access query, column b i want blank and column c, for every time there is outputin column A to put Text1.text in column c.

for example

the query is as such

5
4
6
3
8


i want to output to excel

5| |Text1.text
4| |Text1.text
6| |Text1.text
3| |Text1.text
8| |Text1.text

I tried to come up with some sort of for next loop (just to retrieve the data) but I couldn't get the syntax right... i tried:

Queries![Query 1]!ListCount but that wasn't correct.

Thanks so much!

Don R.

 

[KLin]

Are there some rows in the first column that are null? If there's a number, do you want column C to always say Text1.text? You need to elaborate a little more on what you're trying to do.

 

[theknight571]

If that's all you want to do... couldn't you just run your query that pulls the column A data, export it to excel, and then just paste the text1.text into the spreadsheet?

You could even, I think, have the query include the blank cell and the text1.text. (I'd have to test to be sure though)

You could setup a Macro to perform the tasks if automation is what you're looking for.

 

[KLin]

Originally posted by: theknight571
If that's all you want to do... couldn't you just run your query that pulls the column A data, export it to excel, and then just paste the text1.text into the spreadsheet?

You could even, I think, have the query include the blank cell and the text1.text. (I'd have to test to be sure though)

You could setup a Macro to perform the tasks if automation is what you're looking for.

You could do that in a query field.

ColumnC: iif(IsNull(ColumnA), "", "text1.text")