Search results

I have a working sql version for the backend. I will automate that. Thanks everyone for your feedback!

Still getting the same error as in post#4 above

But we are renaming tblPaymentSub as T2 why would that work?

Hi. The typos are coming from Notepad

Thanks for the input: I get the following error message: "Invalid use of '.','!', or '()'. in query expression 'T1.tblclients_flddrcclientid=tbldebtaccountnumber.tblclients_flddrcclienti'.

When I convert the working sql to this: UPDATE tblDebtAccountNumber SET fldSOI = "1" WHERE ((tblDebtAccountNumber.[fldRecordStatus])="Negotiations" Or (tblDebtAccountNumber.[fldRecordStatus])="Legal") AND ( ((tblDebtAccountNumber.[fldEnrolledDebt]*0.5) +...

The following SQL works on the backend. I cannot get the syntax right so it executes in Access. Any help to convert would be appreciated - thanks. UPDATE tblDebtAccountNumber SET fldSOI = "1" WHERE ((tblDebtAccountNumber.fldRecordStatus)="Negotiations" Or...

Hello. arnelgp's approach was choking a bit in access and mysql; after a few tweaks it is working fine in mysql but what is still missing is the following: for this line - (SELECT SUM(T2.Payment) + (T2.SettlementFeePayments) FROM tblPaymentsSub AS T2 WHERE...

Hello. I ran the sql and got an error - I'm on Access front end and mysql back end. I have attached the error for your review. I LOVE YOUR APPROACH - VERY SMART. Let's see if we can get it to work!

Currently, I have the following and it appears to be working ... but there is no update due to the AS on the fldSOI. I can run this in reporting and modify other design a bit. I will try arnelgp suggestion after lunch (thanks for that). The code running now that seems to be working on...

Hello! I added the specific criteria to better clarify - hope you can take a look. I'm looking for a good way to approach this problem. Thanks.

OK. here we go ...the Doc Man wanted to see a checklist and now that I have your attention: This appears to be a four table join (all four tables share the foreign key field "tblClients_fldDRCClientID") The purpose of the update query to tblDebtAccountNumber is to do some calculations...

Thanks for the reply - it's number one (pls see my comment)

Yeah, I know. This is convoluted one. Here is the background: I have a table of records and these are all child records. There can be multiple records PER FOREIGN KEY. I need to update fldSOI to true on EACH of these records based on the other criteria in the sql. I believe the statement...

Looking for some feedback on how to structure this so it can be run as a daily update autoexec query: Goal is to update fldSOI to "1" where the calculations result in TRUE Zero is the default for fldSOI UPDATE tblDebtAccountNumber SET fldSOI = "1" where ( SELECT...

UPDATE usermanagement SET usermanagement.tblClients_fldDRCClientID = ( SELECT MAX(fldDRCClientID) AS MaxOffldDRCClientID FROM tblClients ) ORDER BY id DESC limit 1; the query above works but I have an event related issue. T1 triggers to T2 and I can't place this on T2 (as a new trigger)...

It's the primary key named "id" is the max(id). But I run into a problem with max in the where clause and it chokes. Here is what I have it works fine up to the where clause: UPDATE usermanagement SET usermanagement.tblClients_fldDRCClientID = ( SELECT MAX(fldDRCClientID) AS...

I was choosing MaxOffldDRCClientID from the tblClients (since that is the primary key and max is the most recent record created.) I then want to update or set that result into the 'usermanagement' table in the foreign key field. Right now, it is not working with any options attempted. The where...

Hello, I have two tables, T1 and T2 T1 gets records created off the web via sql through php and that table triggers a copy to T2. I then need T2 to send its PK back to T1 as an update to a field there to be used as a fk for future queries. I am looking at setting up a procedure to do this in...

Hello, I have two tables, T1 and T2 T1 gets records created off the web via sql through php and that table triggers a copy to T2. I then need T2 to send its PK back to T1 as an update to a field there to be used as a fk for future queries. I am looking at setting up a procedure to...