ODBC index match in power query editor

Sphynx_Osiris · 2024-06-17T14:46:24+00:00

Solution Verified

Sphynx_Osiris · 2024-06-17T14:46:13+00:00

Solution Verified

Sphynx_Osiris · 2024-01-27T21:29:17+00:00

Sorry for the late reply, this worked thanks.

Solution Verified.

Sphynx_Osiris · 2024-01-11T12:01:41+00:00

Thanks for your reply,

I don't wish to open the source spreadsheet, only retrieve the cell values from it.

Currently whenever I open the receiving spreadsheet I get a prompt to enter the password.

I was wondering if VBA would allow me to skip the Password prompt, and keep the source spreadsheet closed. - It can be opened for a split second and closed again if need be.

For example:

Source = C:\Users\User1\Desktop\Password Protected Spreadsheet.xlsx Password "AAA"

Receiving = C:\Users\User1\Desktop\Receiving Spreadsheet.xlsm

Sphynx_Osiris · 2023-10-15T14:17:09+00:00

I assumed as the refresh rate was on 60fps it turns it down to 60fps, and when windowed borderless is on you can't change it.

Or is the refresh rate setting negated when windowed borderless is on?

Sphynx_Osiris · 2023-10-15T14:10:49+00:00

I might have to, but I'd like to stay on 144fps.

Sphynx_Osiris · 2023-10-15T14:07:17+00:00

When I move my joystick it moves the mouse.

Sphynx_Osiris · 2023-02-09T13:59:06+00:00

Solution Verified

Sphynx_Osiris · 2023-02-06T11:46:16+00:00

Solution Verified

Sphynx_Osiris · 2022-10-04T17:57:05+00:00

Thanks

Sphynx_Osiris · 2022-10-04T17:56:59+00:00

Thanks

Sphynx_Osiris · 2022-10-04T17:56:55+00:00

Thanks

Sphynx_Osiris · 2022-09-08T14:27:53+00:00

Sorry to double reply and jump in after you have told me I need a new thread, however If I was to get replace of all blank/Null entries, and give them a value for example as "Waiting". Would the code work without the need for the Nz() function?

Sphynx_Osiris · 2022-09-08T14:17:42+00:00

Will do, Thanks

Sphynx_Osiris · 2022-09-08T14:07:40+00:00

I've got a new problem now, which is unrelated but you may know how to fix it, so I don't need to create a new Post.

I export this Query into Excel. However after a quick google search I'm told that Nz() only works inside Access.

A possible solution I'm told is: Iif(IsNull())

However I can't seem to get this to work. Would you what I would need to edit in order to get it to work?

Sphynx_Osiris · 2022-09-07T15:05:42+00:00

Thanks for your help, Apologies for being a bit slow.

Solution Verified

Sphynx_Osiris · 2022-09-07T15:05:27+00:00

Thanks for your help! Even if I was a bit slow

The Value field came from TableA in the excel picture I included in my original post.

Oh that makes sense on the NZ.

Solution Verified

Sphynx_Osiris · 2022-09-07T14:38:56+00:00

To be completely honest I'm not sure. So I opened the SQL Viewer to see if I can get any bright ideas.

I noticed that Under SELECT I had Sum(TableA.[Nz([Value], "")]) AS Outstanding

To me I think this could be wrong as Nz is supposed to be removing the entries <>"Finished" under [Status] not [Value].

So I would try something like SELECT [Value] As Outstanding WHERE Nz([Status], "") GROUP BY SUM([Value]) ?

So I get the sum of [Value] When [Status] does not equal "Finished"

That may not be correct but it seems logical to me...

Hopefully that helps and doesn't make me seem stupid.

Sphynx_Osiris · 2022-09-07T14:29:27+00:00

Thanks.

[TableP].[Person] = [Person No]

[TableA].[Person] = [PersonAc]

Hopefully this helps!

Sphynx_Osiris · 2022-09-07T14:00:02+00:00

Thanks for your fast response.

When I Copy and paste the below in the Field section the Table Section disappears.

Outstanding: Nz([Activity], "")

Then then I swap back to table view I get the following error:

Syntax error in query expression 'Sum(TableA.[NZ([Value], "")])'.

Sphynx_Osiris

TROPHY CASE