Recent content by mssbass

I'm pretty new to access - I have a report that links to my query and the layout is simple: Service #Pkgs % to Total My query gives me the service type and number of packages that are associated with each service - NOW, how do I add on the column that shows for each service, what's the...

Oh yeah - how do I give the restraint as follows: >0 "It must be greater than 0

Excellent - Thank you sooooooooooo much(:

The expecteddeliverdate and actualdeliverdate are in the following format: 2005-10-06 23:59:00.000 However, these are text values - it won't subtract since they aren't a date value using the datediff function...

Is there a way for a query to recognize a text field as a date? My query: DateDiff("s","ExpectedDeliverDate","ActualDeliverDate") error: data type mismatch

I am having issues with the Weekday and DateDiff function. Right now, my date fields are formatted as text. I can ignore actual delivery date at this time. All that counts in order to figure out expected time in transit is ShipDate and ExpectedDeliverDate You say this will return a 7 for...

My data is as follows: ShipDate: 2005-04-01 00:00:00.000 OrigZipCode 054 DestZipCode 054 ExpectedDeliverDate 2005-04-04 23:59:59.000 ActualDeliverDate 2005-04-05 12:15:00.000 I need some major help. I need to figure out what type of product is being shipped based on ship date and...

Private Sub deleteimport() Dim strDelete As String strDelete = "DELETE Service FROM [UPS COM]WHERE ([Service] Is Null Or [Service] Like 'Tot';)" DoCmd.RunSQL strDelete End Sub I cannot get this module to run - It says "syntax error in expression". If the Service column is null...

I am currently asking the user for the file path location using the following code: Private Sub OpenOrders_Click() Dim strWhere As String strWhere = InputBox("Enter path and file name") DoCmd.TransferSpreadsheet acImport, 8, "UPS COM Test", strWhere, True, "UPS COM Data!" End Sub Is there...

No, this didn't help -

I am trying to import an Excel worksheet; however, if the tab has a space in the word, it won't pull in. If I adjust the tab word, it will pull in: Private Sub OpenOrders_Click() DoCmd.TransferSpreadsheet acImport, 8, "UPS COM Test", "D:\Amy\ontime.xls", True, "UPS COM Data!" End Sub...

I am pretty new to VBA, in fact, I don't know it at all. I am creating a front-end database for the people I report to. I want them to be able to import a spreadsheet we receive annually with volume data. I want a form with a button (when clicked) allows the user to choose where the Excel...

So, can you redo to assume txtAvgHXS is in minutes?

Thanks - works great(:

I need the difference in time to show # of days, hours and minutes left over between the 2 dates??