Paste data

  • Thread starter Thread starter Denver
  • Start date Start date
D

Denver

in query and in table is there anyway i can paste a data on each cell on a
field,
like in excel we can just highlight the cell where we wish to paste the data
and click Crtl+V and data is pasted on that highlighted cells..
can i also to this in access 2003?how if it is possible?

thanks

denver
 
On Thu, 18 Sep 2008 00:05:00 -0700, Denver

No.

You could write an update query.

-Tom.
Microsoft Access MVP
 
how like if i want to paste a data in Physical Progress Field...
how am going to start my SQL?
SELECT [tbl1].[Physical Progress]
FROM tbl1
WHERE ((([tbl1].[Physical Progress]) = "95%"))
UPDATE ((([tbl1].[Physical Progerss]) = "100%))

is this correct i tried but not working?

:ho
 
If you want a valid SQL Update statement

UPDATE tbl1
SET [Physical Progress] = .95
WHERE [Physical Progress] = 1

If Physical progress is a text field then

UPDATE tbl1
SET [Physical Progress] = "95%"
WHERE [Physical Progress] = "100%"


'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

how like if i want to paste a data in Physical Progress Field...
how am going to start my SQL?
SELECT [tbl1].[Physical Progress]
FROM tbl1
WHERE ((([tbl1].[Physical Progress]) = "95%"))
UPDATE ((([tbl1].[Physical Progerss]) = "100%))

is this correct i tried but not working?

:ho
On Thu, 18 Sep 2008 00:05:00 -0700, Denver

No.

You could write an update query.

-Tom.
Microsoft Access MVP
Click to expand...
Click to expand...
 
i have this SQl in my query how can i make my UPDATE SQL?
sorry i very new to this stuff...if you can help thanks a lot...

SELECT DCN01.[Drawing Ref], DCN01.[Site ID], DCN01.[Site Name],
DCN01.Prefix, DCN01.Size, DCN01.size_value, DCN01.[Physical Prog], DCN01.[Qty
of Sheets], DCN01.Eqv_A_Size, DCN01.[Earned ASize], DCN01.[Sheet No],
DCN01.Index, DCN01.[Drwg Typ], DCN01.[Drawing Title], DCN01.Description,
DCN01.Rev, DCN01.CWP, DCN01.[CWP Title], DCN01.Discipline,
DCN01.DateModified, DCN01.TimeModified, DCN01.Location, [Control
Number].[Drawing Control No], DCN01.Link, DCN01.[Rd Line], DCN01.AsBuilt,
DCN01.TR, DCN01.Date, DCN01.SubCon, DCN01.SubContractor
FROM DCN01 INNER JOIN [Control Number] ON DCN01.[Site Name] = [Control
Number].[Site Name];

for example Drwg Typ field all that = to ILD
on SubContractor field i want to = all ILD to MMG Subcontractor
how can i build my UPDATE clause here...

thanks anyway John...


denver
John Spencer said:
If you want a valid SQL Update statement

UPDATE tbl1
SET [Physical Progress] = .95
WHERE [Physical Progress] = 1

If Physical progress is a text field then

UPDATE tbl1
SET [Physical Progress] = "95%"
WHERE [Physical Progress] = "100%"


'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

how like if i want to paste a data in Physical Progress Field...
how am going to start my SQL?
SELECT [tbl1].[Physical Progress]
FROM tbl1
WHERE ((([tbl1].[Physical Progress]) = "95%"))
UPDATE ((([tbl1].[Physical Progerss]) = "100%))

is this correct i tried but not working?

:ho
On Thu, 18 Sep 2008 00:05:00 -0700, Denver

No.

You could write an update query.

-Tom.
Microsoft Access MVP


in query and in table is there anyway i can paste a data on each cell on a
field,
like in excel we can just highlight the cell where we wish to paste the data
and click Crtl+V and data is pasted on that highlighted cells..
can i also to this in access 2003?how if it is possible?

thanks

denver
Click to expand...
Click to expand...
Click to expand...
 
Open your query in design view
SELECT Query: Update from the menu

In the update to "cells" under the fields you want to update enter
[TableName].[FieldName]
where the table name and field name are the name of the source table and
field that you are using to update the destination field.

The source table must be included in the query. So assuming that you
wanted to update [DCN01].[Drwg Type] with a field in the table [Control
Number], you would enter somethng like the following.
[Control Number].[Drawing Type]


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

i have this SQl in my query how can i make my UPDATE SQL?
sorry i very new to this stuff...if you can help thanks a lot...

SELECT DCN01.[Drawing Ref], DCN01.[Site ID], DCN01.[Site Name],
DCN01.Prefix, DCN01.Size, DCN01.size_value, DCN01.[Physical Prog], DCN01.[Qty
of Sheets], DCN01.Eqv_A_Size, DCN01.[Earned ASize], DCN01.[Sheet No],
DCN01.Index, DCN01.[Drwg Typ], DCN01.[Drawing Title], DCN01.Description,
DCN01.Rev, DCN01.CWP, DCN01.[CWP Title], DCN01.Discipline,
DCN01.DateModified, DCN01.TimeModified, DCN01.Location, [Control
Number].[Drawing Control No], DCN01.Link, DCN01.[Rd Line], DCN01.AsBuilt,
DCN01.TR, DCN01.Date, DCN01.SubCon, DCN01.SubContractor
FROM DCN01 INNER JOIN [Control Number] ON DCN01.[Site Name] = [Control
Number].[Site Name];

for example Drwg Typ field all that = to ILD
on SubContractor field i want to = all ILD to MMG Subcontractor
how can i build my UPDATE clause here...

thanks anyway John...


denver
John Spencer said:
If you want a valid SQL Update statement

UPDATE tbl1
SET [Physical Progress] = .95
WHERE [Physical Progress] = 1

If Physical progress is a text field then

UPDATE tbl1
SET [Physical Progress] = "95%"
WHERE [Physical Progress] = "100%"


'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

how like if i want to paste a data in Physical Progress Field...
how am going to start my SQL?
SELECT [tbl1].[Physical Progress]
FROM tbl1
WHERE ((([tbl1].[Physical Progress]) = "95%"))
UPDATE ((([tbl1].[Physical Progerss]) = "100%))

is this correct i tried but not working?

:ho

On Thu, 18 Sep 2008 00:05:00 -0700, Denver

No.

You could write an update query.

-Tom.
Microsoft Access MVP


in query and in table is there anyway i can paste a data on each cell on a
field,
like in excel we can just highlight the cell where we wish to paste the data
and click Crtl+V and data is pasted on that highlighted cells..
can i also to this in access 2003?how if it is possible?

thanks

denver
Click to expand...
Click to expand...
Click to expand...
 
Back
Top