Do you know how to do it with macro?

I have limited knowledge about SQL. Could you guys more specific or give me like a sample to apply?

Yes and thank you so much. That helps a lot...

For example I have 2 table

Table 1 data

id sequence_no deposit number

80210 236 ...

For example I have 2 table

Table 1 data

id sequence_no deposit number

80210 236 ...

Thanks it works.

Do you know how to create a procedure for the query? I do it on Excel or SQL

Thanks guys

This is what I'm working on in the query:

SELECT

p21_view_inventory_value_report.[item_id]

,SUM (CASE WHEN [p21_inventory_usage_all_view].year_and_period BETWEEN LEFT(CONVERT(CHAR(8), DATEADD(MM,...

The data result should look like this

Last 3 month usage (column) Status( column)

0 ...

Thanks for the response. I don't think that made the issue. I tried to copy yours and it is still not working at all. It keeps saying the problem was...