Search results for query: *

I tried the DateDiff but keep getting a data type mismatch. I need to display the number of days on a report. the data resides in a table. InDate is in date/time format ComDate is in date/time format I created a query that will update a field in a new table. the field(daysdiff) is numeric...

I tried that (or so I think). Let me give it another shot. Maybe I've got "fat fingers" today....

I have a table with an INDATE, OUTDATE, NAME fields. I need to calculate the average duration by NAME. Is there a function in ACCESS that will calculate the number of days if given the INDATE, OUTDATE???? Once I have that number, I can come up with the average.

I think I know what you're saying there. I created a macro using the SendObject. I left the object type, object name, output format, to, cc,bcc blank(I will get promted for the to address). in the message text i put something like....new request entered. When i try to run the macro, it...

Not sure what category this would fall under..... I've created a database in Access that uses multiple input forms that track projects our team is working. Users can enter new requests. What I'm wondering.......is there a way to notify me via Outlook that there is a new request (new record...

Not sure what category this would fall under..... I've created a database in Access that uses multiple input forms that track projects our team is working. Users can enter new requests. What I'm wondering.......is there a way to notify me via Outlook that there is a new request (new record...

Not sure what category this would fall under..... I've created a database in Access that uses multiple input forms that track projects our team is working. Users can enter new requests. What I'm wondering.......is there a way to notify me via Outlook that there is a new request (new record...

Sub Macro1() ' ' Macro1 Macro ' Macro recorded 2/1/02 by ISD Range("a1").Select For i = 1 To 30 ActiveCell.Offset(1, 0).Activate If ActiveCell.Offset(0, 0).Value = "" Then ActiveCell.Offset(-1, 9).Value = ActiveCell.Offset(-1, 9).Value + " " + ActiveCell.Offset(0...

Sub Macro1() ' ' Macro1 Macro ' Macro recorded 2/1/02 by ISD Range("a1").Select For i = 1 To 30 ActiveCell.Offset(1, 0).Activate If ActiveCell.Offset(0, 0).Value = "" Then ActiveCell.Offset(-1, 9).Value = ActiveCell.Offset(-1, 9).Value + " " + ActiveCell.Offset(0...

I know that but look at the output.....the series of data represented by B ....the second to last line of data in E is no longer associated with the original series.

can i lop off a portion of the actual spreadsheet and shoot it to you? at least you can then see what I'm working with.

the sort range would be a1 .. e6 sort key would be column a

can I attach a portion of the original spreadsheet to an email? It would be easier if you can see what I'm doing.

The data got messy when it was posted. A B C D E F 1 aa aa aa aa aa 2 BBBB BBBBBB BBBBB BBBBBB BBBB 3 BBBB 4 CCC CCCCC CCCC CCCCC CCC 5 CCC...

It would be sorted by column A. So as you can see the data in E before the sort would be lost after the sort.

I've got data that is roughly structured like this: A B C D E 1 AAAA AAAAA AAAAA AAAAAA AAAA A B C D E 1 aa aa aa aa aa 2 BBBB BBBBBB BBBBB BBBBBB BBBB 3...

I've got data that is roughly structured like this: A B C D E 1 AAAA AAAAA AAAAA AAAAAA AAAA 2 BBBB BBBBBB BBBBB BBBBBB BBBB 3 BBBB 4 CCC CCCCC CCCC CCCCC CCC...

This is something I've been trying to resolve for some time and was wondering if there is a way to accomplish this in Access (since my Excel macro building is rusty) sequence data1 data2 Row1 0001 ad row2 0002 ad row3 0002 ae...

I have a field in an imported table consisting of FIRSTNAME/LASTNAME. I need to separate the first from the last and put those into their respective fields within the same table. Not sure how this is handled in Access. I tried to use CHARINDEX in an update routine but can't seem to get the...

Not what I remember but I'll sure give it a shot. Thanks!