Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-11-2019, 06:45 PM   #16
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,249
Thanks: 15
Thanked 1,592 Times in 1,512 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Update Query Via FORM Input. Please advice

Quote:
currently i have the update query which is working. but i need that query should look up on form for input and then run.
If you are copying data from one table to another, don't. It is poor design strategy to duplicate data. When the source data changes, what prompts the copies to be updated? -- that's why we don't do it. Always do the calculations in a query at the point in time where you need them.


__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Query Question/Advice MattioMatt Queries 4 06-04-2018 06:49 AM
Need advice on an Update Query (Data cleansing) jonathanchye General 4 11-04-2011 08:19 AM
Use form input in an Update Query mark627 Queries 2 10-20-2011 05:10 AM
[SOLVED] update query with criteria from form user input kernelsan Queries 2 04-23-2005 08:49 AM
need db advice, input, ideas lipin General 2 10-09-2002 09:33 AM




All times are GMT -8. The time now is 08:03 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World