Change the Structure of a Query

[JohnCR]

Hello,

Is it possible to change the structure of a query using VB? In other words, my query has seven fields. Is it possible to add an eighth field with a script?

Thanks in advance,

JohnCR

 

[PHV]

Any chance you could post more specific info ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JohnCR]

Well for instance, in a query I have the following fields...

Task #
Description
Type

and I want to a Date found field to the query using VBScript

I hope that helps.

Thanks,

John

 

[PHV]

Please, read either one faq in my signature.
What do you want to do with what in which context ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JohnCR]

Well, here's what I'm trying to do...

I have a query with the above information (Task, Description, and Type) and then I have another query with 'Date'. I want to be able to get Task, Descr, Type, and Date from the database.

I think I want to do something like this (but haven't tried it yet)

Select [Query - All].[Task #], [Query - All].Description, [Query - All].Type, [Query - Not Available].Date
From [Query - All], [Query - Not Available]

Would that seem about right?

 

[PHV]

How is the Date info related to the Task ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JohnCR]

mm, I'm not certain I understand "related". Each entered task is assigned(?) a task number automatically. In a form I enter the information but there are numerous query's, all tied together with a task #, and each query may contain a piece of the form. For instance, Query - All contains everything but Date and Query - Not Available contains the Task# and Date. So, if data is entered on the form the task number is generated and the description, Type and Date are entered.

Does that help?

Thank for the assistance,

John