PC Review


Reply
Thread Tools Rate Thread

create Table and fill field same value

 
 
=?Utf-8?B?SGFtb3VkIEFscmFzaGlk?=
Guest
Posts: n/a
 
      15th Oct 2006
I want to create table and put put "A" in a field for all records.
Please help me
Have a nice day
 
Reply With Quote
 
 
 
 
David F Cox
Guest
Posts: n/a
 
      15th Oct 2006
Define a field as Text, set its length to 1, or as long as the text it will
contain, and set its default value to "A"


"Hamoud Alrashid" <(E-Mail Removed)> wrote in
message news:0274D5F0-7A8C-4FC9-B045-(E-Mail Removed)...
>I want to create table and put put "A" in a field for all records.
> Please help me
> Have a nice day
>



 
Reply With Quote
 
=?Utf-8?B?V2F5bmUtSS1N?=
Guest
Posts: n/a
 
      15th Oct 2006
Hi Hamoud

Create your new table and have a field fortmated as Text. Set the default
value to "A"


--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Hamoud Alrashid" wrote:

> I want to create table and put put "A" in a field for all records.
> Please help me
> Have a nice day

 
Reply With Quote
 
Van T. Dinh
Guest
Posts: n/a
 
      16th Oct 2006
... but if all the Field values is "A", why would you need to store it?

(unless you just want a ***default*** value and you / the users will change
the values after)

--
HTH
Van T. Dinh
MVP (Access)



"Hamoud Alrashid" <(E-Mail Removed)> wrote in
message news:0274D5F0-7A8C-4FC9-B045-(E-Mail Removed)...
>I want to create table and put put "A" in a field for all records.
> Please help me
> Have a nice day



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically fill field from data in another field (same table) sd_eds Microsoft Access 0 21st May 2008 01:53 PM
How do I create a button to automatically fill the From field? =?Utf-8?B?UGVycnkgSGFja3NoYXc=?= Microsoft Outlook Discussion 3 10th Feb 2005 07:04 PM
Re: How to create a fill in field on a Word document? Graham Mayor Microsoft Word Document Management 3 2nd Jul 2004 03:04 PM
Create table with field names based on the value of a field in another table. simon_minder@hotmail.com Microsoft Access Database Table Design 5 24th May 2004 02:32 PM
auto fill field in a table by filling one field in list box Jeffrey Reed Microsoft Access Queries 1 21st Oct 2003 09:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:30 PM.