Adding a comment field to a query.

[cwhite23]

Does anyone out there know how to add a comment field to a query? What I'm trying to do is to link an Access databse to external sales data that is on our server, run a query to show only the past due orders, and have a field either on a form or in the query where someone can enter the projected ship-to date based on production information. I've got the tables linked, and I've created the query without any problem.

Any help would be greatly appreciated.

 

[PaulBricker]

Not without having a field in a table to store the data in. A query only exist while it is open as opposed to a table that has a physical presence. You would probably have to create a table with two fields. The field that is the foreign key for the primary key in your main table, and a Comments field. Then you could add the Comments table to your main query, join the PK/FK and add data to your Comments field.

Paul

 

[smedvid]

There is a field in the QueryDef I think that can hold the description. But, nothing that I know of in the SQL itself.

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[ProgramError]

Add another field to one of your tables using design view - I would assume the orders table would be the most likely bet. Call this field comments and make its datatype - memo.
Once thhis is saved you can use this fieled in the query your designing.



Program Error
Why is it, I still think in terms of spectrum BASIC!