Recent content by trustsun

I get the error: Specify the table containing the records you want to delete. Here’s the SQL: DELETE tblcarrier.Store#, tblcarrier.Request, tblcarrier.Date, tblPkupNoCmp.ACT FROM tblcarrier INNER JOIN tblPkupNoCmp ON tblcarrier.Store# = tblPkupNoCmp.Store# WHERE tblPkupNoCmp.ACT="NoInfo" Or...

I am not sure how to apply your example? I just want to put it in a SQL. This will also generate a make table query as well. Reiterating: I would like to see the date from last week day: So if I have a query that run for Monday what will be last week date for Monday? Here's what I got so far...

I’m trying to use a date add function to pull last weeks data by day e.g. (Monday, etc.) in its current field. Here’s what I tried so far, =DateAdd("y",-7, [mydatefield]). Reiterating:

OK cheerio there are spaces, this is how the field look: (6:00 PM [AB-CF]), without the ().I need to spilt them into separate fields and converting the time value into military time. thanks,

I'm still getting both values in the first field and a error in the second one.

I need to split this value into two separate fields; 6:00PM [AB-CF], it’s now in one field. The time value needs to be converted into a military value. Any help, please. So, they need to look like this separate by fields. 1. [AB-CF] 2. 6:00PM but this needs to be in military time.

Thanks, it works now. Could you explain what you did by adding the *. This helps me from asking the same question if this issue comes up again, that way I understand.

Yes I meant to say crosstab, here's the SQL: PIVOT Switch([ACTIONS] Like "[ADD-LAD]*","NEW",[ACTIONS] Like "[CHG-LCH]*","CHANGE",[ACTIONS] Like "[PDL]*","DELETE",True,"Other"); On "other" is where the error occurs. Just like you said, there's no records. The only time it will filter or show...

Yes,it is a text box. Thanks for responding. Any ideas or revision to by pass the error?

I am filtering a report by date range. At times there’s no data for a particular field when I type in a range, then I get the error, “Jet database engine does not recognize “field” as valid name or expression”. Is there a way could I by pass this even if I filter outside the field range with out...

Hi gang, one of those infamous date conversion issue. I have a time field like 2:44:15 AM. I need to convert this time field into a date field like 1/2/2006. Here's what I've tried so far, CDate([CHGTIME]). -trust

Can someone help me with this? -trust

Sure! Private Sub Set_Filter_Click() Dim strSQL As String, intCounter As Integer ' Build SQL String. For intCounter = 1 To 4 If Me("Filter" & intCounter) <> "" Then strSQL = strSQL & "[" & Me("Filter" & intCounter).Tag & "] " _ & " = " & Chr(34) & Me("Filter" &...

Hi, I'm getting a Run-time type mismatch 13 on this filter code. strSQL = strSQL & "[" & Me("Filter" & intCounter).Tag & "] " _ & " = " & Chr(34) & Me("Filter" & intCounter) & Chr(34) & "" _ And "" Any advice or revision I should used? -Thanks

The value for Combo7 is a date format exp. mm/dd/yy.