Open recordset

[BSando]

Hi,
I want to call data from a table so I can manipulate the data. I am sure I need to use the openrecordset command.

I can manipulate data how I want it, but can't work out how to call the field in the table.

For example I have a table called "assetreport" and a field in the tabe is called "order #"

Any help would be appreciated

Some people make things happen, some watch while things happen, and some wonder 'What happened?'

 

[Remou]

This would be better in forum700. You are using Access, are you not, BSando?

Dim rs As DAO.Recordset
Set rs=CurrentDB.OpenRecordset("assetreport")

Debug.Print rs![order #]

It is best to avoid "special" characters and spaces in field names, it will save you a lot of grief.

 

[genomon]

Or maybe

Set rs=CurrentDB.OpenRecordset("SELECT * FROM assetreport ORDER BY [order #]")

Listen to Remou and rename the field OrderNum. The # character may be interpreted as a compiler directive, among other things you don't need. Also have a look at Reserved Words in Access VBA help.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."