Recent content by JJeremy

Hello All, I have tbl_1 with less date and I have tbl_2 with all dates. I want to grab tbl_1 dates = tbl_2 and also grab > tbl_1 dates on tbl_2 on a query. How do I that? Please help. Thanks. JJeremy Analyst Lakewood, CA

Hello All, Table1 have ad dates and Table 2 have all dates. I want to exclude the dates from Table1 from Table2. How do I do that? Thanks and please help. JJeremy Analyst Lakewood, CA

Hi Everyone, I have two link tables on a query and I want to remove a part number with big "A" and keep the small "a" part. Please help and thanks in advance. JJeremy Analyst Lakewood, CA

Thanks guys and I'll try both options. JJeremy Analyst Lakewood, CA

0001 How do I retain the zeros when bringing this number to a different cell? JJeremy Analyst/Report Writer Lakewood, CA USA "Got Data?" "Imagine life without changes.

Thanks Peter and I'll try this out. JJeremy Analyst/Report Writer Lakewood, CA USA "Got Data?" "Imagine life without changes.

Lupins46, I have a query and I want to insert extra column to count e.g.(1,2,...)each rows on the query from the first record to the last. Please let me know if you need more info. JJeremy Analyst/Report Writer Lakewood, CA USA "Got Data?" "Imagine life without changes.

Please help. JJeremy Analyst/Report Writer Lakewood, CA USA "Got Data?

You can create this in the query side by putting 2 tables and linking them together.

You can use Not Like 0 or <> 0 in the criteria query.