Search results for query: *

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.

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...

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...

Ok now I know I know this and it's buried deep in my head somewhere but for the life of me I can't think of it. I've got a field in a table where the last name and first name are together (ie... Smith/John) note the slash. I want to put last name and first name in different fields for...

Is it possible to copy a table structure? I have created one table that I would like to copy since it does contain most of the rows that I need (I'll zap the ones I don't).

I've created a new table that I will populate with data from two other tables based upon some pretty basic selection criteria. I've let it (the query) run for over half an hour and when I stop it and check the input table there are no records. My question is this.....does sql update/input into...

Yes, I know this is pretty basic but it's Monday and I must have destroyed that braincell over the weekend. I have a 5 char zipcode in table1 table2 has a 10 char zipcode (5-4) this would work??? table1.zipcode like table2.zipcode

I have a form with project input information that will be used as a tracking and reporting device for our projects. On the form there are fields for requestor name, phone number, extension. I want to autofill the phone number and extenstion fields based upon the requestor name the user selects...