Search results

It worked! Thank you so much for all your help.I will try to close this "case". Kind regards, Roxana

I have just tried it, this expresion replaces the empty rows with 0 and the rows that should have a value with Null,so it does not work,unfortunately.

I will try the expression now and see if it works. Thank you very much.:)

Do you mind writing the entire expression considering that at the moment it is : Total_Throughput:Nz([Oil_Throughput_Capacity_(bpd)],0)+Nz([Gas_Throughput_Capacity_(MMcfd)],0)+Nz([LNG_Throughput_Capacity_(Tonnes_per_Annum)],0). Thank you!

I tried ""," ", nothing works,it gives me Error. I gave up on trying,although I find it very strange that access does not give you a way to replace a 0 with a blank in an expression... Thank you so much. The more pressing issue is with forms/subforms ,I have posted a question in the Forms...

It worked! Finally! Total_Throughput: Nz([Oil_Throughput_Capacity_(bpd)],0)+Nz([Gas_Throughput_Capacity_(MMcfd)],0)+Nz([LNG_Throughput_Capacity_(Tonnes_per_Annum)],0) Thank you so much! There will be rows from other append queries that will be attached to Total Throughput,but they will be...

The 3 fields are numeric,yes, but many of the records are blank.So some have values, but most dont. Are the blank ones considered nulls? Do I need Nz function if some of the records have values? How exactly would the syntax look,if you dont mind? The way it looks when it is run is with the...

This query is part of a macro containing 8 queries.The end result of the macro is a table for the analysts of the company. They need in the table a column with the Total.So the Totals should be in this query,shouldnt it? But why do I get blanks in the column?Where do I go wrong?

This is a screenshot.Thank you so much.

I am trying to add a word document with the image but it wont let me:banghead: Hahah. How else can I show you a screenshot? :mad:

I tried that and the resulting column is empty! Maybe I should specify the source table for each of those 3 elements in my expression?

Thank you so much both for helping. The result of the macro goes to the analysts of our company, and they need in the result just the total, not the 3 separate columns. So i will probably hide the 3 and create the fourth column as permanent. I will try it when i go back to work( monday) and...

Dear All, I have another question, even more stupid than the previous. This is a basic query, but my brain does not work :banghead: I have an append query. I want to get a column that is the sum of 3 other columns: Oil_T_C_(bpd) Gas_T_C_(MMcfd) LNG_T_C_(Tonnes_per_Annum) 1000...

Dear all, I was wondering if you can help me. There is a macro that contains 1 Make Table query and 6 Append queries. The result of the macro should normally be obtained from the Welcome Window. I need to add another Append query. I have created the query itself,I have added it to the Macro ...

Hi everyone Can somebody please help me? I am supposed to somehow obtain a table with data that must be "pulled" from 2 excel spreadsheets. I will try to show what the 2 spreadsheets contain(i will mention only the columns i am interested in): Spreadsheet 1 User Status y pass...

Hi,everyone And nice to meet you all. The reason I am joining this site is because my interest in databases and SQL. I have no experience with access, but I dealt with Postgress and MySQL during my studies and I am trying to teach myself Microsoft SQL Server at the moment. But at work Access...