run query's and then reset table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

a column in my database is "tick to update" this works ok and so does "mysql
view"
facility in Queries.

I want to reset my "tick to update" column in my Table without having to go
back to and doing it manually.

Any advise will be appreciated
 
a column in my database is "tick to update" this works ok and so does "mysql
view"
facility in Queries.

I want to reset my "tick to update" column in my Table without having to go
back to and doing it manually.

Any advise will be appreciated
Click to expand...

I suppose "tick to update" is a check box field?

Run an Update query:

Update MyTable Set MyTable.[Tick To Update] = 0;
 
fredg said:
a column in my database is "tick to update" this works ok and so does "mysql
view"
facility in Queries.

I want to reset my "tick to update" column in my Table without having to go
back to and doing it manually.

Any advise will be appreciated
Click to expand...

I suppose "tick to update" is a check box field?

Run an Update query:

Update MyTable Set MyTable.[Tick To Update] = 0;
Click to expand...

Dear Fredg,

I supply my Program for your Inspection.

UPDATE Table1 SET Table1.[Current Value] = Table1.[Current
Value]*(1+([PercentAdjustment]/100)) WHERE (((Table1.[Tick to Update])=True));

UPDATE MYTABLE SET MY TABLE.[TICK TO UPDATE]=0;

Is this a good and correct statement

If it is, please respond, as I am anxious to obtain the correct formula

Kindest Regards

Brian
Click to expand...

Regarding:
UPDATE Table1 SET Table1.[Current Value] = Table1.[Current
Value]*(1+([PercentAdjustment]/100)) WHERE (((Table1.[Tick to
Update])=True));

This above Update query changes the value in Table1.[Current Value]
field where the [Tick To Update] field is checked.

That must be run by itself.

Then, after the above query is run, in a second (different) query,
use:
UPDATE TABLE1 SET TABLE1.[TICK TO UPDATE]=0;

When receiving replies to your questions, always remember the replier
does not know the actual names of your tables and fields, therefore
generic names are used. You must substitute your actual table and
field names when using the code supplied.
 
fredg said:
fredg said:
On Mon, 23 May 2005 00:14:02 -0700, wraggedass wrote:

a column in my database is "tick to update" this works ok and so does "mysql
view"
facility in Queries.

I want to reset my "tick to update" column in my Table without having to go
back to and doing it manually.

Any advise will be appreciated

I suppose "tick to update" is a check box field?

Run an Update query:

Update MyTable Set MyTable.[Tick To Update] = 0;
Click to expand...

Dear Fredg,

I supply my Program for your Inspection.

UPDATE Table1 SET Table1.[Current Value] = Table1.[Current
Value]*(1+([PercentAdjustment]/100)) WHERE (((Table1.[Tick to Update])=True));

UPDATE MYTABLE SET MY TABLE.[TICK TO UPDATE]=0;

Is this a good and correct statement

If it is, please respond, as I am anxious to obtain the correct formula

Kindest Regards

Brian
Click to expand...

Regarding:
UPDATE Table1 SET Table1.[Current Value] = Table1.[Current
Value]*(1+([PercentAdjustment]/100)) WHERE (((Table1.[Tick to
Update])=True));

This above Update query changes the value in Table1.[Current Value]
field where the [Tick To Update] field is checked.

That must be run by itself.

Then, after the above query is run, in a second (different) query,
use:
UPDATE TABLE1 SET TABLE1.[TICK TO UPDATE]=0;

When receiving replies to your questions, always remember the replier
does not know the actual names of your tables and fields, therefore
generic names are used. You must substitute your actual table and
field names when using the code supplied.
Click to expand...


Dear Fred,

Sincere Thanks for the information indeed it was very good of you to assist

Do I owe you anything for your help

Kindest Regards

Brian
 
On Thu, 26 May 2005 08:15:27 -0700, wraggedass wrote:

** snipped**
Dear Fred,

Sincere Thanks for the information indeed it was very good of you to assist

Do I owe you anything for your help

Kindest Regards

Brian
Click to expand...

All answers in these Access newsgroups are for free.
Your above mentioned 'Thanks' is more than enough.
 
Back
Top