Recent content by seizure

Anyone? :(

Hi guys, I'm trying to create a crosstab report. So far I've created the actual report with no Record Souce with a page header containing text boxes named "head1", "head2" etc through to "head15". In the detail section I have "col1" to "col15" and in the page footer I have "tot1" to "tot15"...

This is what I needed: ALTER TABLE tblSearchResults ADD COLUMN ID AUTOINCREMENT I had to take the blank column called "ID" out of the first SQL string, but that allowed me to run the code above as a second SQL string, thus giving me a physical ID field. Cheers

Having done a bit more digging..... CREATE INDEX doesn't actually add a physical index, does it. That's OK, but how would you then query the table for the records based on the index number that has just been created? Cheers

Hi, I've given your suggestion a go. Here's my code: strSQL = "SELECT tblLog.Date, tblLog.Comments, tblLog.Client, tblLog.[Number of Accounts], tblLog.[User ID], tblLog.[Value of Accounts], tblAction.[Action Description], tblLog.[File Location], tblLog.[Creditor ID], '' AS ID INTO...

Fantastic! Thanks for that. I'll give it a go. :)

Hi, Was wondering, is it possible to add an index field into a make table query? And if so, how do you do it in SQL? Thanks