Search results

Hi all, this is an old thread I need to revisit. Slighty revised. For matching accounts and securities: I need to calculate the difference in a stock price from one day to another, and create a cumulative return over time. I get that this is more of an excel-style function, but I know it is...

Hi All, A simple question I'm stuck on. Every Answer I can fin has 200 lines of code. I dont need or want code, just the correct syntax for the following. IN each row in a table, I want to find the Max value across the following three columns [Col1], [Col2], [Col3] Something like...

All, hopefully easy one. Cant find the answer without writing lines of code. This has to be easy. I want to stop my form from auto resizing the column widths when I make a change to the header text (or for any other reason). Thanks

All, Syntax problem somewhere. Any help is appreciated. In a button on the "Parent" form Macro I have the following, meant to open the "Child" Form to same record selected. I have this working with using one criteria t find the Child record, but combining the 3 fields is giving me trouble. The...

All, Someone that knows what they are doing can probably help in about 15 seconds. Attached is my DB with a delete query. Why is it not running? You will see the table relationships. I want 2 fields in the table [..._Tab] used to select the records in table [...Eeco] to delete. Any help is...

All, I have a form that references a considerable amount of data, so this is a question on response time and best practice. One of the fields in the Form requires a join to another table to enhance what is shown. Question is - do I do this join in the Form Data Record Source, or only within the...

All Thanks for any help with this. If I can get this first part I can apply it to a lot of other functions I need to build. In the attached DB there is a form [Recon_HoldErrorsEeco_Menu] with a subform [Recon_PositionErrors_SF]. There is a "Holdings Errors" menu on the left side with values...

All - thanks for any help. I can't find this answer. I the attached DB - There is a form [Holdings_List] with 4 multiple combo boxes used to filter the table. I cannot figure out how to get them to all work "together". What I want is... 1) The form opens with no records showing 2) When the...

Hey All, Easy one for you. I have one long formula that applies to about 15 different queries. I'd rather give it a Name and then reference the name in each query instead of using the entire formula 15 different times. The formula in each query always references the same field names, so it is...

All, Hope this finds you well. I have a DB linked to Outlook contacts, but not all of the Contact fields are being pulled in. Anyone know how to change the Outlook fields being pushed/pulled? There is a decent Contacts DB template, but the interaction with Outlook is not linked, so the data...

OK so just learning here... getting past a few early hurdles will really help. Easy one for you pros! In Table [QueryTest] there are 20 rows of data. I want to add each of the 20 values in field [MarketValueImpact] together to get one cumulative value, using a loop. The code breaks at the...

OK - so there is no Multiply option in a report for a series of values (same concept as Sum). I have a range of unitized values that need to be multiplied together. Well known issue but I can't find a straight answer out there. Any ideas?

All - i hope you are well. Can anyone send a few good links for a newbie like me to convert my access db to MySQL? I assume the queries should be moved too so access is just the front end. Thoughts and links welcome.

All, I'm trying to make Access work like XL, creating data on new rows based on prior rows. Sort of like an accounting system Best to give an example. See the attached spreadsheet I will have Columns A - E in the Table Column F values are what I need to create. See the formulas. A few...

GM all. Hoping you are all safe these days. Question on the best practice for plugging a value in a Union All query I need to Union All the following two tables: Table 1 Has an Account's Market Value for each day TABLE 1 FIELDS AccountNumber Date MarketValue Table 2 has an Accounts Activity...

All, Here are 2 best practice question for sequencing queries. Question 1) Is it best to create queries off queries so they run in sequence (Flow #1 below) or "Parallel" queries from the same source and then merge them later? The logic in Union Query 1 & 2 is similar but not the same, and not...

Hi all. Hope you are all doing well. Easy one... In the Union query below (below the XX's) I need to Group by: AsOf, AcctKey, SecKey, PositionRef and Sum By: Quantity_Impact, MarketVal_Impact, Cash_Impact, Thanks XXXXXXXXXXXXX SELECT AsOf, AcctKey, SecKey, Quantity_Impact...

All, I'm trying to replicate accounting logic in Access. Here is the goal: Take an opening Position - Say 20 Shares of IBM on 1/1/2019 and calculate the market value for each business day of the rest of the month. The math for each day is ( Prior Day-end Shares + The Share impact (+/-) of...

All, Anyone ever see a query Sum not work? Seems when there is only one record to Group by the related field being Sum(ed) is coming up 0 instead of the value in that one record. Same if Max or Min is selected. When there is more than one record bring grouped the related Sum is correct...

:banghead:UGH! This is so easy and I'm getting syntax errors. I want to group the Activ_ID and Max the ActivEECO_UpdateDate fields. SELECT Activ_ID, Activ_DatePosted as ActivEECO_UpdateDate FROM Activity_Translated; UNION ALL Select Activ_ID, ActivEECO_UpdateDate FROM...