Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. elfudge35

    batch updating

    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
  2. elfudge35

    batch updating

    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)...
  3. elfudge35

    batch updating

    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
  4. elfudge35

    batch updating

    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...
  5. elfudge35

    bound combo box filtering

    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...
  6. elfudge35

    bound combo box filtering

    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
  7. elfudge35

    bound combo box filtering

    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...
  8. elfudge35

    bound combo box filtering

    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...
  9. elfudge35

    bound combo box filtering

    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...
  10. elfudge35

    balance and allocation formulas

    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...
  11. elfudge35

    balance and allocation formulas

    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...
  12. elfudge35

    balance and allocation formulas

    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...
  13. elfudge35

    balance and allocation formulas

    anyone?
  14. elfudge35

    balance and allocation formulas

    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...
  15. elfudge35

    How do I use a query to add data not imported once I change data type

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

    How do I use a query to add data not imported once I change data type

    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...

Part and Inventory Search

Back
Top