Search results

Thanks pbaldy, I am the only user and I need access to the query as I need to copy and paste it into Excel (and no, I don't want to export it into Excel, pasting is quick and works fine). This may not be standard practice but I would really like to know how to do it. Thanks very much...

Hi, I have a dashboard form that is open when I open the database. Usually I can slide a vertical bar at the left of the screen to view my Access Objects, such as Tables, Queries, etc. It says "Navigation Pane" there. Every now and then I lose the ability to open this. The vertical...

I know that, how do I do it?

Hi, I have a report with a row for each “ISO” field, a text field that shows an isometric number. I have inserted a Command Button, that appears on each row, and want to be able to open a query and filter it with the filter to match the ISO number of the row that I selected the Command...

Hi arnelgp, it then shows me all the dates, not just the Max, which is what I need Thanks very much

Hi, I have a query that is Grouped By a field called KPI. I have a Date field in the query, SortDates, that I have named LatestDates by setting it up like LatestDates: SortDates I have then placed MAX in the Total row to show the latest date for each KPI. This works well but I want to set...

Thanks, But I need the latest date for each KPI? I really need to use the Query design window, code is out of my league.

Hi, I have a Query that is Grouped By KPI and then has MAX applied for Delivery Date. This shows the latest delivery date for each KPI, which is what I want. The problem is also want to show other information associated with the latest date for each KPI. For example, the Equipment Number...

Thanks very much, both very helpful

Hi, If I have a report Grouped by a particular field (called KPI) and then Sorted by Date (delivery date) can I show only the latest delivery date for each KPI? How would I do this? Thanks very much Dave

Hi, I have a Text field, called KPI, of the format ABC1, ADC4, ABC15, etc. I have set up a field in the query to extra the "number" part, but when I try to sort, it sorts with all items starting with 1 first, so 15 comes before 2, etc. The formula I use to extract the numbers is...

Hi, I have a Command Button on a Form that opens a query. When the button is selected an “Enter Parameter Value” dialog box appears and the user types in a value and presses OK. This works but it always displays the “Enter Parameter Value” dialogue box twice. I have to enter the value I...

Thanks, I already use CDate() function and Format() function to get the data how I want it later. And I'm not trying to turn letters to numbers. I'm just trying to understand why three tables except the "Deleted" text in the Delivery Date field (along with "Dates" in Text format) and...

Hi, I get four spreadsheet reports from another department that shows forecast delivery dates. They have a date column that I need to use but insist on having text mixed in with the dates (they type “Delivered” for any item that has arrived). I have a table based on each of the spreadsheets...

Hi Markk, These strings are actually the Predecessors to Activities in Primavera P6 and this is how they are exported from P6. I don't want them separated. I just want to be able to compare the Predecessors to Activities between different versions of the same schedule. I do this by having a...

Hi, If I have a field of comma delimeted strings (like below) of data type Text, can I set up another field in a query to sort them alphabetically? CN-MSTGN-GN-GN-010, CN-MSTGN-PI-PI-620, CN-MSTGN-GN-PI-640, CN-MSTGN-GN-GN-020 Note, that there are often duplicates in the string. This is...

Thanks very much, sneuberg

SQL for the Union Query: SELECT tblMechanicalLAV_Stockcodes.PACKAGE_NUMBER, tblMechanicalLAV_Stockcodes.GROUP_NUMBER, tblMechanicalLAV_Stockcodes.ROS_DATE, tblMechanicalLAV_Stockcodes.Status, tblMechanicalLAV_Stockcodes.TAG_StCode, tblMechanicalLAV_Stockcodes.DESCRIPTION...

Thanks very much, guys, I will check this out

Hi, I have created a Union query from four Select queries. When I total the records from all four select queries I get 68,187 but the Union query only returns 61,091. Is there something obvious that I can check to try to figure out what happened to the other 7,000 records? Thanks very much Dave