Search results for query: *

wow, now I do feel like an idiot, thanks, I didn't even think of referring to my duplicate records query to get the data for the update query, sorry, brain fart

ok, I have a list of the ids and their duplicates end_id dup_id 100001 100023 100002 100024 100003 100025 100004 100026 in the endorsement type table, I need to replace the duplicate foreign key with the original, (ie: 100023 needs to be changed to 100001 and so on, thousands of times)...

um, the point is there are thousands of records that I need to update with different values, if I have to do 3000 update queries I'll shoot myself

I have an endorsement type table linked to a master endorsement table with a foreign key endorsement table end_id end_information endorsement type end_type_id end_id end_type when users entered information to the form, the form was not properly linked and thus they did not see there were...

I would think changing my SQL statement to this would work, but it can't find the field in my Form for some reason SELECT dbo_Endorsement.Endorsement_ID, dbo_Endorsement.Policy_ID, dbo_Endorsement.Endorsement FROM dbo_InsuredTransaction LEFT JOIN dbo_Endorsement ON...

Left join doesn't work, I still get every single Endorsement#, not just the End#'s for the current policy, but I'll look into adding a second combo box, was hoping I didn't have to

I have this as the SQL Statement for the Combo box and it accomplishes all that I need except for limiting the combo box choices to the available Endorsements for the current policy SELECT dbo_Endorsement.Endorsement_ID, dbo_Endorsement.Policy_ID, dbo_Endorsement.Endorsement FROM...

I'm not sure what you mean or if that answers what I need This is a sample of what tblTransaction could look like TrID TrDet EnID PoID En# 1 NY 1 1 000 2 NJ 2 1 001 3 VA 3 2 000 4 NY 3 2 000 5 MI 3 2 000...

I have a three table structure with this setup tblPolicy PolicyID Policy# tblEndorsement EndorsementID Endorsement# PolicyID tblTransaction TransactionID TransactionDetails EndorsementID PolicyID Some of the EndorsementIDs in tblTransaction refer to the first Endorsement# in their policy and...

sorry about the typo, should be 7000 ending balance and the definitions for the OutstandingCharges, PrincipleBalance are in my previous post Outstanding Charges is the amount of the proceeds that can be allocated to the previous Total Outstanding Charges balance in the second to last column...

Parent Item Def Bal 1 10000 2 20000 3 15000 4 12000 Child Item Date SaleProc AdPro IntExp LegExp 1 1/20 3000 0 0 0 1 2/15 0 100 20 50 2 1/15 0 0 12 0 2 3/4 15000 0 18 0 3 1/31 0 200 0 0 3 2/17 11000...

the parent table has one line for each item (loan) and the default balance of the loan the child table has numerous dates for each item in which transactions affect the balance, 4 columns of essential data and 5 columns of data based on those essential Sale Proceeds Additional Proceeds...

anyone?

I have a database that has the following components item number, beginning balance, proceeds (sale and additional), proceed allocation (between principal and outstanding charges), charges (interest and legal expenses), total outstanding charges, ending balance there are many items that refer...

is that a really dumb question so nobody wants to answer? copy and paste won't work, it says File sharing lock count exceeded

I am importing a ton of data from Excel into Access. It is working quite seamlessly, until I have encountered 9 digit and foreign postal codes. Then it wants to change the type to number instead of text and will only import the 5 digit codes. Is there a way to use a query to automatically update...