Search results

Nope, doesn't work.

I have a table listing a number of cell phone products and their carrier along with their status' in the production process. I want the query to return the most recent status for each product for each carrier. However, out of the 20+ products that I'd like the most recent status for for each...

I've got the fields ID, product, carrier, m gate status, and m gate status #. The first four have group by selected under them and m gate status # has Max selected.

I pasted the picture of the screen into paint so its a bmp.

It's telling me upload file failed.

it's not pasting in the reply...can i email it to you?

I tried this and when I look at the query in datasheet view it's still showing all 5 records instead of selecting the max.

I'm trying to link a table to a query called M Gate Status. Each product has a certain status that matches it and I'd like my query to show the most recent status for each product. I've created an M Gate Status # column on the MGS table and want to select the maximum number, but I can't figure...

Hello All, I'm new to visual basic and am wondering if there's anyway I can write a code that will scan to see if any name in a cell is equal to another name in a cell, and if so, take the highest number (located in another column) corresponding to that name. Any help would be much appreciated...

I'm trying to export my access database to excel without overwriting what was already on the file. My query is called Combined Data Query and I'd like it pasted on the first worksheet of an Excel file called Stoplightchart.xls Can anyone write the code for me or point me in the right...

I need to create a document that searches for a criteria in autofilter, copy & pastes that into another sheet, uses autofilter to search for another criteria, copy & pastes that, etc 128 times. Any ideas for how to do this using a loop? This is for work & I need help ASAP!!!

How do.. How do I do that??

I'm extremely new to Visual Basics and instead of learning how to use it, am trying to record an extremely long macro. It told me my procedure is too large and I'm only 1/4 of the way done with my macro. I have no idea how to begin using visual basic and need any help I can get to either shorten...