Search results for query: *

Modified if statement to handle problem above, but stuck on the problem when TIME remains the same but Route changes. For example, the third line below creates two entries and I only want one. Any assistance would be appreciated. Thanks. BLOCK TIME ALT_SORT Route 007-92...

What if the Route does not change, but the Block changes? For example, the data below changes from Block 7-92 to 7-93 but the Route remains 7. How could I adjust the "basBlockMinMax" function to handle this? BLOCK TIME ALT_SORT Route 007-92 18:21 65760 27 007-92 18:38 65760 27 007-92...

This worked great! Thanks!

In table design view I set the data type to date/time. But when running the make-table action query it changes the "date/time" data type to "text" data type. When running the make-table action query can I force it keep the "date/time" data type?

The "basBlockMinMax" function works great. Thank you!

I have several blocks of data in the format below: This is the datasheet view of a MS Access table. Block Time Route 004-02 06:29 4 004-02 06:39 4 004-02 06:43 4 004-02 06:49 4 004-02 06:53 4 004-02 07:00 18 004-02 07:07 18 004-02 07:12 18 004-02 07:16 18 004-02 07:19 18 004-02 07:24 18 004-02...

How can I transpose the file below? Currently the file is in this format in Excel: Employer Contact Misc (Sales, Employee #) 3-D IMAGING DEVELOPMENT CONTACT: RODNEY WARNER, OWNER NAICS: 2372 12301 N LAMAR BLVD PHONE: (512)837-6644 SALES: $2.5 Million - $5 Million AUSTIN, TX 78753-1314 FAX...

Thanks! You guys and this website are a great resource!

Users would like to select from a combo box and if their selection is not there they would like to enter the data into the combo box and update the undelying record source for future selections. Is there a simple way to do this? Thanks.

Thanks. I thought I would have to force users to go through a form, but wasn't sure.

How can I tell if a user opens a table in datasheet view and edits a field/column in the table? I would like to write to a log table anytime a user edits a table field. The logFunction below writes to the log table using CurrentUser. For example: If table opened logFunction "testTable has...

When I used the following SQL statement I get the error below: SELECT Count([2002perCaps].ID) AS NumberOfLibraries, Min([2002perCaps].percap) AS LOW, Max([2002perCaps].percap) AS HIGH, Avg([2002perCaps].percap) AS AVERAGE, basPercentile(0.25, [2002perCaps].percap) AS 25th_Percentile FROM...

Michael, Thanks for the feedback. When I call the 'basPercentile' function I get an error. To get the 25th percentile I use the call below: basPercentile(0.25, FieldName) Is there something wrong with my call statement? Also, what if I want to set a reference to the Excel Library and use...

How could I compute the 25th, 50th, and 75th percentiles for the values below in MS Access? 17.2068311195446 46.2558502340094 4.99548328816621 15.6774955699941 9.82629107981221 40.3058419243986 18.5503711558855 69.0640279394645 5.09231685527099 19.3273542600897 11.422159887798 29.8877968877969...

I meant: How can I get all the mailing addresses even though there are null or empty shipping address? Thanks

In the query below, I'm trying to get the mail address and the shipping address. Both addresses are in the ADDRESS table. However some Organizations have mail addresses but not shipping addresses. I would like to get all the mailing addresses even though there is no matching shipping address...

Thanks Skip for all your help!!! I finally got my brain to focus on mult-dimensional arrays and with some modifications to the dateStr functions (i.e., empty strings, comma delimited strings, etc.) the data is looking pretty good now. Thanks again!

Modified code to this point but still struggling. Sub CombineRegHours2() Dim db As DAO.Database Dim rec As DAO.Recordset Dim strSQL As String Dim dateStr As String Dim regHour(7) Dim i As Integer strSQL = "SELECT reg_Sun, reg_Mon, reg_Tue, reg_Wed, &quot...

This is the code I've developed so far and also a list of about the first 20 records in the table. Sub CombineRegHours() Dim db As DAO.Database Dim rec As DAO.Recordset Dim strSQL As String Dim sun, mon, tue, wed, thu, fri, sat As String strSQL = "SELECT reg_Sun...

Thanks!!! This function works The function above worked for data that's formatted correctly. But if I could extract the data directly from the table this would provide a much cleaner solution. What if the data is contained in a table with fields for each day as shown below: Sun Mon...