Search results for query: *

Hello Based on the below SQL statement, I am trying to only show the max order # (4) and the related last name, not all the last names. DEFECTNUM MaxOfORDERNUM LastName 670 1 Dietz 670 2 Sandahl 670 4 Harig I only want in my query to...

Hope I explained this correctly: I have a table we will call “Defects” lined one to many to a table called “Defect Events”. I have taken a defect # highest value (counter field order Num, grouped on “Max”. This retrieves the records correctly, I just want the highest value from a particular...

Is it possible using Access 2000 to package and deploy a simple database where the tables are linked to the server? I can package using Developers edition stand alone databases but don't know if possible where multiple users not having Access 2000 program can read/write data to the server mdb...

Question to all you gurus: Is it possible using Access 2000 to package and deploy a simple database where the tables are linked to the server? I can package using Developers edition stand alone databases but don't know if possible where multiple users not having Access 2000 program can...

I am creating a data access page using Access 2000. There should be, according to documentation, the ability to change the Data Entry property to "True". However, when right clicking on the form, there is no "data entry" property under the Data tab. Another way supposedly to change this is under...

Hello out there- I need to populate a table with a range of numbers, the following code works great except when the numbers have a leading 0: Private Sub cmdRunCode_Click() Dim intStart As Long Dim IntEnd As Long Dim intReqNum As Long Dim rst As Recordset Set rst =...

Field name is serial Number, data type is text. Problem is some have numeric value only, some numeric combined with text. How would I extract only numeric values in a query? Text is in the field in various places, 1st, middle of 9 digits, etc.

I have downloaded the Compact on Open or Close add-in available from the net. Is it possible to have this run by a macro? I am using Access 97, can't find any information on how to do this. I am not very VB literate, can handle simple code...

Question: I have 2 check boxes on a report, one called Technician, another Certification. I am trying to count only the technicians that are certified, such as: =Sum(IIf([Certification]=-1,[Technician])). This works great except the numbers are showing up as negatives. Can anybody help me here?

I have a field as such: D9999*01, next record will be D10000*01. How can I hide the *01 (last 3 digits) either from the D9999*01 or the incremental D10000*01? This will be in a query.

Hello How would I, in a query, count if more than one record exists for a field? (Text field called LastName.) I have tried using DCount>1, nothing seems to work. Thanks

Hello- I have an access table of shipments. I am trying to link the serial # (numeric field) of shipments from that table with an imported table from our legacy system. The problem is the serial # in the legacy table is a text field with not only the serial # but notes, etc. How could I link...

Hello All How would I align text in a label on a report from the bottom up? Thanks! CarrieR