Is there a way to do this: I have a form called "List of Proposals Written" that is listed by th Proposal number. Is there a way to display on another excel spreadsheet, the mos current Proposal number? I know Access you use something like Dmax(ProposalID)+1 What should I do in Excel:confused: Any help would be greatly appreciated! Michae -- Message posted from http://www.ExcelForum.com "daniels012 >" < wrote > I have a form called "List of Proposals Written" that is listed by the > Propos...
Here is my problem. i have a series of 3 digit numbers that need to be cinverted to a series of 4 digit numbers using this following 722 needs to read as 5622 and in the next collum SV-7822 in the collum's to the right. what type of formula is this and how can i do it? The above is an example, i have a whole range of 3 digit numbers that need the exact. rules applied to all numbers. which is why i need a formula to do it. Help someone please!!!! I'm not completely clear on what your looking for but if 722 was in A1 in B1: = A1 + 4900 in B2: = ="SV-" & A1 + 7100...
If {\displaystyle (a_{n})} is a sequence of complex numbers rather than a sequence of real numbers, this last formula can still be used to define convergence, with the provision that {\displaystyle |\cdot |} denotes the complex modulus, i.e. {\displaystyle |z|={\sqrt {z^{*}z}}} . If {\displaystyle (a_{n})} is a sequence of points in a metric space, then the formula can be used to define convergence, if the expression {\displaystyle |a_{n}-L|} is replaced by the expression {\displaystyle {\text{dist}}(a_{n},L)} , which denotes the distance between {\displaystyle a_{n}} and {\displaystyle L} .
Scott, I had posted on Microsoft and you sent me to your blog to have the numbering system (similar to APEX example) explained. I am not a programmer and I don’t understand where these codes and expressions are even suppose to go in access. When I do try to implement the little I do know I continue to get errors. I am not sure if I am putting the information in the wrong place or if I am way off. Do you know of any youtube videos that could walk me through it step by step? Or if you have the time could you help walk me through the steps.