[Help] Update Query to have check box ticked

W

Wiredex

New member
Local time
Today, 02:58
Joined
Aug 24, 2010
Messages
9
Access 2007

I need help creating a query to update the Priority field in the Transaction table such that those visitors whose length of stay is 15 days or more will have the priority check box ticked.

And i need to run this query to update the data in the Transaction table.



 
First up create a select query that selects all clients, and their related transactions, who's stay is greater than 15 days, ensure that the priority field is also being selected in the query.

Once you are confident that you have this working correctly, open the query in design view and change it to an update query, now in the Update To row below the Priority field put -1
 
Is there another method? because im not sure if im doing it right.
I made another table by copying the amended data which shows 15 days or more from Length of Stay query and made a new Priority field with checkbox. Next i made a update query and everything in my new table gets ticked.

But how do i make another query to update this new table to my original table? Therefore it's kinda complicated
 
Can you post a copy of your DB, and I take a look at it. Save it back to '03.
 
Wiredex said:
Is there another method? because im not sure if im doing it right.
I made another table by copying the amended data which shows 15 days or more from Length of Stay query and made a new Priority field with checkbox. Next i made a update query and everything in my new table gets ticked.

But how do i make another query to update this new table to my original table? Therefore it's kinda complicated
Click to expand...

When you made you select query to select all the records that showed values of greater than 15 days, did that work correctly? ie. was it selecting only the records greater than 15 days?
 
You must log in or register to reply here.

Similar threads

southwestgooner
Help!!! Update Query to update fields in table???
Replies
2
Views
295
Pat Hartman
P
A
How to Add feature to query Append ?
2
Replies
39
Views
667
Pat Hartman
P
M
Querying for idle projects. Yes/No field to autopopulate a text field with a set string, "no new update".
Replies
13
Views
627
Pat Hartman
P
S
Solved Access 2010 How to use Append query in VBA to update a table to match number of records in another table?
Replies
16
Views
419
cheekybuddha
cheekybuddha
P
Update query
Replies
12
Views
686
Gasman
Gasman

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom