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 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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.