Search results

Yes, sorry, file is greater than 2MB, and even in rar file doesn't fit. Let me see what can I do.

Hi there, in the enclosed file you will see the first TAB is the query for the Audits in the FY2019 "AuditFY" Secong TAB Jobs by FY2019 "JobFY" Pivot TAB I've just copy and paste both tables to get a summary by Sales Rep The highlighted are the guys who meet both conditions but I would like to...

That is correct, I need the sales rep name to sort the table, what I am trying to achive is to see the results in the current fiscal year by sales rep, total sales between audits and jobs, but as you can see jobs are not always in the same fiscal year.

Hi, I'm only getting a single record because that person is the only person who meets both conditions. I mean that Sales Rep has an audit value in FY2019 and also has a jobvalue in FY2019.

Thank you very much for your prompt reply. I guess I've followed your instruction, but at the result was only a single record retrieved.

Hi there, I am having this issue, and I can not find the way to produce the report needed. In my data table I have several columns but the most important for me now are: AuditFY Customer Sales Rep JobFY When I get the job I recorded the "AuditFY" but the customer could accept the job...

Hi there, here is the sample, I cannot convert into a db file but you will get the field which contain the base64 chain. Thanks in advance for all your help.

OK, I did that, then I run the macro after that I got the stackoverflow icon, a red dot icon and a blue icon

Hello, Sorry for my late reply. I have been working with this but I am completely stuck. Sorry, I don't know how to proceed with your code. I have my table in access which is connected with my sharepoint list. in that table I have the fields that contain the base64 text. But the point that I...

Thank you very much for your prompt reply. I was reading those two choices and it seems like they are designed for expert people as you guys. And I am in baby steps. but thanks again. I will continue searching!

Retrieve a Base64 text to picture Hello there. I am a Microsoft PowerAPPS user, and I have an app that save the pictures taken with my device camera into a SharePoilt list, the pictures saved are in base64 format, something like this: data:image/jpeg;base64,/9j/4AAQSkZJRgABA.......... I...

I finally got it, and it was thank you to your advice. Many many many thanks!!!!

Hi, sorry probably that is why I am confused. I have a report, in that report I have 100 records, but only 15 of them have a PO Received. at the end of my report I have several fields where I am getting the total of every single column. i.e Sum[Quantity], Count[Orders] But I would like to...

Hi thank for your prompt reply. I forgot to tell you one thing: I would like to sum and count other fields values i.e. Sum if POValue>1 , Sum Quatity Count if POValue>1, Count Quantity is this possible also?

Hello, Hope someone can point me in the right direction. In my report I have several records but only some has a $$ value for the received PO. I would like to 1. Count if the POValue is greater that 1, and 2. sum if the POValue is greater that 1. Sorry is a silly question but I am stuck

Thank you very much for your prompt response, and time. I just changed the code for your proposal, and I will leave as it is so if I select a Fiscal year but no a report I will get a stop all macros warning. not a big deal. Many thanks!!

BTW one last question: In my view report form I have 3 choices 1. Select a Report to open = Item List 2. Select a fiscal year = cbo box 3. Open a report = cmd button I was able to disable the command button if the cbo box is empty, but I woould like to disable the cbo box also. I mean once I...

Downloaded. thank you, looks really good!!

Thank you thank you thank you. sorry a newbie mistake. and thanks again for your advice the other two cbo box working in combination works fine!

SELECT FiscalYear.FiscalYear FROM FiscalYear ORDER BY FiscalYear.FiscalYear DESC;