Search results for query: *

I have what should be a simple query that has been killing me. I'm trying to convert a string time to group by the hour. I'm able to get the hours 12-23 fine, but the single digit numbers are still coming back as two digit numbers (e.g. 3 shows as 37). Can someone give me some gudience as to...

If got the following cell: =VLOOKUP(A2&K1,errors,3, FALSE) I'm trying to read to colums (A2 = store number and K1 = Error Code). The worksheet errors has the store number broke down by multiple codes listed vertically and I'm trying to bring them into another worksheet horizontally. I think...

Hi, I'm having a problem producing a table in a timely fashion and it's an essiential table for a report I am building. I'm pulling records from an ODBC connection and the table I'm pulling from is nearly a million records. I have a very basic code trying to pull the applicable data I need...

Hello..It's been a while since I've worked in Access and I'm just getting back into it. I'm having a problem getting information to update back into my table from a form. I can get the first record to work fine but subsequent records seem to get the data but will not update into the table. Any...

I'm stumped and not sure why this is happening. I have a time field from an AS400 table which comes in the format of 80000 for 8:00 a.m. and 130000 for 1:00 p.m.. I'm trying to do a simple conversion to make these numbers appears as a time. I have a function that should handle the conversion and...

I'm running a query in which I'm pulling data of an AS400 system. The table I'm pulling from has probably about 5 million records in it dateing back to early September. I've been running an append query that took about 4 to 5 minutes to update everyday but has now gotten to the point where it's...

I have a function written in which I want a table to open and the code to halt until the table is closed. It's a rather long program but just to give an idea of where I am at here is some sample code: Function Check() Dim db As Database Dim rst As Recordset Set db = CurrentDb() Set rst =...

I'm trying to return a value that is part of my original number. It's returning the first value just like I want but every value after that is returning the first value again. I'm guessing that I don't have the record moving to the second record which I thought would happen with my movenext...

Hi everyone. I'm not very good at this and was hoping someone could give me some guidance. I am trying to join a field WMSDATA.TFITM.IMITM to the PAITM field in the code pasted. I can get this to work in Query form just fine but I can't get the module to recogzie this. This is how it stands...

Hi everyone, I'm trying to create an amortization schedule and am having some problems. Here is that data I am working with: Payment Frequency 12 Reduction in Total Period Date Principal Interest Payment 1 The Payment frequency is in cell E8 and I want the period to...

I have a query where I am trying to count errors from two different fields. The Error Type field should count everything, but the order number field should only count unique order numbers. Right now the fields are coming out the same. Can anyone offer me any advice? Thanks in advance. My...