Search results

Thanks for all the efforts and support you always give

Thank you MajP for your solution, it is absolutely great. Just out of curiosity, what if the BE files are protected with a password? any work around?

Have you tried to create two FE files, naming one ED and the other Chuck and link each FE to its corresponding BE.

sorry I missed that one

Try this in a query: Extracted: Mid([PNum],InStr(1,[PNum],"09"),10) Equivalent to this: SELECT TblTest.PNum, Mid([PNum],InStr(1,[PNum],"09"),10) AS Extracted FROM TblTest; it should work for 10 numbers QueTest PNum Extracted CUT (09GN20T-01) 73" LONG 09GN20T-01 (09GN20T-01)CUT 6.50" -...

nachumy, what I see is that you are trying to get the count of Private Contacts.ID when the same ID appears in consecutive rows. If that is so, you need to clarify the following: 1- how are the records in this query sorted? by date? by primary key? is the sorting affects the results you are...

Wow Mike. this reserved word missed me although I learned many years ago to avoid any reserved word. Thanks for the feed. I changed the name and now all codes are working fine, even my original one. Funny though how Access behaves sometimes. Some codes did not work but one worked, and all used...

I want to thank both of you MajP and arnelgp for your efforts and for your help. I learned a lot from both of you today and I made it to the final line. MajP gave me the idea to use the top values and I used arnel's code, with a little tweaking by creating a new query with max dates, narrowing...

FYI.. I replaced in your code all references to the date and DDate with the DayID, the key for each record, and i got similar results, only this time TotValue dated 2/4/2021 .... go figure

and here is the underlying table of the query QueStocksDaily. I went through all the dates in the table to see if there was any deviation after 9/9/2021 but everything looks normal am really sorry for all the trouble

this is really turning my head.. while at your end you are getting the right results, here is a sample when i run the same at my end

DDate is a real date, no doubt there. Am attaching a snapshot of sample data, the real one has exactly the same structure, but much more symbols. Tell me, would the ID number for each record be of better use in your code instead of the date. i noticed that you are getting DMax values for both...

thanks MajP. that took care of this error, but now there is another one that popped out. the line strSql = "Select top 1 TotVal..... is giving again compile error: expected: end of statement ... and highlighting the last parenthesis

The query is a list of the same number of stocks, and their daily value. Those values are entered daily. And the purpose of what I am doing is to get the latest value for each stock (symbol) to be used in another table your code is returning the corresponding value for each symbol, but for the...

The line strShare = "'" & strShare "'" is giving compile error: expected : end of statement

Well, the code of arnelgp went through, but worked partially true. There were no errors, and I got totals from the query matching the Desc, but not from the latest date as intended. The latest date in that query is 4/23/2021, and all results were from 9/9/2020 So it looks like the date part...

Thank you MajP for what will probably work, but I need the wildcard around Symbol and not around Desc (Desc contains Symbol not the other way around)

Thank you pbaldy let me first clear the use of the asterisks which are wildcards. In my example Desc=Microsoft (MSFT) and does not match Symbol=MSFT, but *MSFT* = Microsoft (MSFT) . Thank you for the link. But the examples are so basic and none tackles the issue I am facing.

Hi everyone. I need help in the syntax of the DLookup() and I appreciate your efforts I am trying to get a value from a query to place in a form using the DLookup function. This value must meet two criteria: must be on the last date, and, it is the one for the text field that match the specific...

To tell you the truth i did not read your signature, but if you are insinuating about the thank you thumbs up, i already put one at the beginning of my last post. but may be i should press the one on the bottom, and for that i apologize, because i did not really pay attention to it but here it...