How to add a populated text field at Make Table run?

AtLarge

Registered User.
Local time
Yesterday, 23:29
Joined
Oct 15, 2008
Messages
70
Hi, I can add to my make table query UDate: Date() that will add a populated field to the output table that has today's date in it.

I can also add something similar like this for example V_Num: [V_Number] and when ran, will prompt with a dialogue box to add some data, it will then create the table with that new field name and populated with the text from the dialogue box.

Great. But how can I automate this to skip the dialogue box and just add it to the expression?
 
How is it supposed to know what you want to add? If it's some sort of fixed text:

V_Num: 123
or
V_Num: "abc"
 
Yes, that's it! I knew I had seen it before. Monday mornings. Thanks PBaldy!
 
Happy to help!
 

Users who are viewing this thread

Back
Top Bottom