Recent content by net

Thank you SO MUCH pbaldy and arnelgp for the prompt response. I was able to import everything over to a new db. Much appreciated. :-D

Hello, Is it possible to import all of my saved imports from one db to another? I have so many and would like to avoid re-creating them if possible. I am using MS Access 2016. Thank you.

Thank you Plog and June7 for your help with the SQL and aggregate query. For the most part I am able to get what I want. Thanks again. :-)

Hello Plog, Thank you so much for your suggestion. I do not know how to put my fields into a table format in these message fields. I hate the spaces myself. I apologize. Is there anyway to add the formula into the query design view? I am not familiar with the SQL part.

Sorry, WO #s are all "WO333". I have 3 work order numbers and I am looking for a combined total of each piece

Hello, I have a Microsoft Access query that has a column “Piece Price”. I would like to get a total in a separate column of the total for all of the total pieces per work order. See sample below. Sample: WO # Piece Price Total Price WO3333 $200.00...

Hello Query Experts, I have been trying to use the “Max” function to filter down to the last date logged for a particular manager and it is not working. I would like to see the most current WO Processed Date for Carlos Garcia. He has multiple entries with various pieces of equip and they are...

Thank you everyone with your suggestions. :) As arnelgp pointed out, I provided incorrect sample data. I have uploaded an updated db. Using the SQL statements provided by CJ and Mark, the query returns 1 work order (WO24420) with WO_Processed_Date as 5/13/2018. I would like to see all work...

Hello CJ, Thank you for responding. I have uploaded a sample db of my data. I have an autonumber, but no auto date on the table. I have a timestamp setup in my data entry form, but not the table.

Hello, I have an Access Query to pull work orders to identify projects that have existing work orders processed. On one project, I may have multiple work orders. I would only like to pull the latest (last) work order processed. I have a WO_Processed_Date field that I would like to use to...

Thank you arnelgp for your suggestion. I don't need to calculate the 60 days. Just create another field that populates the last WO create date.

Hello, I have an Access query that I use to pull work order data. When a WO is entered for a job (WO Create Date), there is a calculated date generated in a field called “Est Completion Date”. This date calculates from the date entered 60 days out. For example: Date Entered is 3/1/18. Est...

Hello, I need help with extracting a word from one column and placing it into another column, like the “Text to Columns” wizard in Excel 2016. Example: Using a Microsoft query, I would Like to extract the word “Completed” from Column A and place it in Column B WO 4452200 -COMPLETED – WO WO...

I really appreciate the first update you provided. I will take a look at your suggestions. Thank you so much for spending the time helping with my issue.

I did not know there were code tags. I will use them going forward. Thanks for the info. The Error message is Compile Error: Type Mismatch It errors out on the this line and highlights the word "GetWindow" hWndApp = GetWindow(Application.hWndAccessApp, GW_CHILD)