finding the first empy cell in a column

[missprogrammer]

can you help me to get started on finding the first empy cell in a column

 

[Craig0201]

SELECT TOP 1 * FROM table WHERE column IS NULL.

Craig

 

[missprogrammer]

sorry, should of been more detailed. I am pasting my results of several recordsets into excel using vba. My thing is I wont know how may records exist in each recordset. So I can I find the last used cell or fist empty cell.

 

[KyleS]

You could count the recordsets before you paste them. Then set your next starting point at RecordCount (of the first rescordset) + 2 (Excel starts at one, and if you're putting headers in, then you'll need to account for 2 spaces to make sure that you don't overlap).

Obviously adjusting for your next recordsets e.g. Starting point 3 = RecordCount1 + RecordCount2 + 1 et cetera

Dim RecCnt as Integer, rst as RecordSet
Set rst = CurrentdB.OpenRecordset ("[TableName]&quot
RecCnt = rst.RecordCount

Hope this helps

Kyle

 

[missprogrammer]

AccessIsFun;call me stupid, but I dont understand.

 

[KyleS]

Not a problem, I didn't explain it well.

(just to make sure I'm on thr right track)
You plan to exprt multiple recordsets to one Excel worksheet, and need to know upon which row to paste your next recordset, right?

"My thing is I wont know how may records exist in each recordset. "

If you use the recordcount function [RecordSetName].Recordcount, this will give you the number of records in a recordset.

What does you code look like for this function? So I know which direction to go with my directions.

Kyle