Ol' question of if record is null add previous record

Dukejr84a

New member
Local time
Today, 17:20
Joined
Apr 14, 2022
Messages
2
I receive this from tableau weekly. I have seen some posts describing this issue. I have seen one in SQL and one in VBA. I am new at this, I am reading Access Bible 2019, watching the Youtube videos and searching. I saw a post about an if else statement. Anyway, to explain this in a little more detail. The goal is to click on their name and have this information populated on a form grouping by dates and display the description and totals.
 

Attachments

  • money.png
    money.png
    29.3 KB · Views: 100
How do I create a query using VBA to complete the table to fill in the null values
 
Is that an Excel report grouped by employee? There might be an Excel VBA procedure that you could do to make the data tabular. It's really hard to tell for sure what we are looking at and where this screenshot was taken.
 
Is that an Excel report grouped by employee? There might be an Excel VBA procedure that you could do to make the data tabular. It's really hard to tell for sure what we are looking at and where this screenshot was taken.
That sure looks to me like an Excel worksheet. The little green triangle in the corner of that cell indicates a comment in Excel....
 
How do I create a query using VBA to complete the table to fill in the null values
Actually, I was also going to ask some questions but got distracted with work. You said you get a weekly file. What kind of a file is it?
 
I receive this from tableau weekly.
of course it is excel (read post #1 carefully of what he receives).
after importing it to access table, you can do the same solution here:
 
I would have to ask why the Tableau software cannot do it?
Appears to be just removing duplicates, which you do not want.
Has to be an option not to do so surely?

Seems plenty ot way of removing them?, just do not do so?
 
of course it is excel (read post #1 carefully of what he receives).
Seems he is using Tableau software according to post #1???
I suggest Dukejr84a describes the requirement, perhaps with a sample of desired output, to clarify.
 
I assume the OP is just receiving the Excel report from Tableau from some other entity and he has no control over how the data is output from Tableau otherwise why output it in an undesirable format. He could certainly try to ask and get the required format, but sometimes (many times), you just cannot get them to change the format of the resulting report. That's just a guess though.
 
I agree with Mike that the OP is getting data(seems to be a report) in a format that isn't conducive to his requirement.
He may not have access to the "raw data", but again this is just a guess. Wouldn't be the first time we've seen post processing a report to get initial data for additional processing. More info please, Dukejr84a.
 
Would be worth clarifying if the report is received as a .xlsx or a .csv. If the latter there are perhaps better options to manipulate the method of importing
 

Users who are viewing this thread

Back
Top Bottom