Specific field in table to update when query runs

162
May 17, 2017, at 08:52 AM

I run an append query to update tblProjectTracking. Sometimes the status from the source of my query changed from Pending to Approved. When I run my append query, it adds new projects, but doesn't update the status on the old projects. Is there a way for my project status in tblProjectTracking to reflect the new status pulled by the query without me creating a make table, making a copy of the make table, and renaming it to tblProjectTracking?

READ ALSO
Where can I find up to date info on Google Maps API [on hold]

Where can I find up to date info on Google Maps API [on hold]

When I found this page, I was stoked! Looked like good documentation from Google on how to implement PHP+MySQL into a Map using longitude & latitude values from databaseThen I noticed how deprecated and useless the code provided by Google is

142
MySQL - get booking reservations according to dates

MySQL - get booking reservations according to dates

I need to select all the booking reservations according to date_begin and date_end fieldsI have a calendar which only shows 10 days of the selected date calendar

201
MySQL - Get Column Names & SELECT At Same Time?

MySQL - Get Column Names & SELECT At Same Time?

I know of the following two ways to show column names of a table:

263
How do i select the inverse of this query?

How do i select the inverse of this query?

How do I select the inverse of this query, and why are my attempts failing

281