Entering same values all at once

  • Thread starter Thread starter Clarendon
  • Start date Start date
C

Clarendon

Hi!

If I need to enter the same values for field for a large number of records,
is there a way to do this automatically all at once, instead of typing the
same thing all by hand?

Thanks.
 
Hi

Create a new query and bring the table into the design grid.
Select View
Select SQL

Paste this if you are adding text
UPDATE TableName SET TableName.FieldName = "Insert text here";

Paste this if you are adding a number
UPDATE TableName SET TableName.FieldName = Insert number here;

Select Design view and click run (the large ! at the top of the screen)

You will need to change TableName and FieldName in the above to what they
really are in your application
 
First of all backup your data.

Next, you will need a WHERE clause if you don't want to change EVERY
record in the table. The where would need to identify which records you
want to change.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Hi!

If I need to enter the same values for field for a large number of records,
is there a way to do this automatically all at once, instead of typing the
same thing all by hand?

Thanks.
Click to expand...

Please amplify. Are you *changing* some fields in a large number of existing
records? or are you creating a large number of new (identical??) records in a
table? Are you trying to enter values in every record in a table, or in (a
large number of) selected records? If so, how do you know which records?

An Update or an Append query should work, but (as suggested elsethread) a)
back up your database and b) be sure you know what you're doing before you
jump in!
 
Hi.

I am creating a new table and entering the values for new records as primary
keys. I have two primary keys and want to do:

Node Type
A Freq
A Perc
A Mkp
B Freq
B Perc
B Mkp

So the node column has three identical values and the type column has three
alternating values that repeat for each different node.

I don't understand why i need to use query when I am creating a new table,
and also the previous answers are too brief for me. Could you be more
specific about how to proceed?

Thanks.
 
Hi.

I am creating a new table and entering the values for new records as primary
keys. I have two primary keys and want to do:

Node Type
A Freq
A Perc
A Mkp
B Freq
B Perc
B Mkp

So the node column has three identical values and the type column has three
alternating values that repeat for each different node.

I don't understand why i need to use query when I am creating a new table,
and also the previous answers are too brief for me. Could you be more
specific about how to proceed?
Click to expand...

Well, the first question to ask is... why do you want this table AT ALL? What
will you do with it?

The way you would create such a table - other than typing it in by hand -
would be to use either a MakeTable or an Append query. I'd suggest the latter.
Create your table in design mode, with the two fields. Create two additional
tables: Nodes and Types. Manually enter all the valid Node and Type values
(I'm sure your example with three is just an example and there are many more,
right?)

Then create a Query with the query design window; add the Nodes table and the
Types table, with *no join line at all*. Access will give you every possible
combination of records in the two tables - e.g. if you have 100 nodes and 6
types, you'll get all 600 possible pairings.

Change the query from the default Select query to an Append query using the
Query menu option or the query-type tool on the toolbar. Access will ask what
table you want to append to. Run it and it will copy the 600 records into the
table.
 
Back
Top