Associate
- Joined
- 15 Jun 2009
- Posts
- 2,494
Don't know if this is possible or not but going to ask anyway.
I have a table with all my texts backed up from my phone and I put it into an access database because its the easiest way to add new ones without duplicating (I feel anyway)
The only problem is, It shows up the number rather than a name for who its sent by. Is there anyway for it to lookup the number in another table where I would have the contacts saved, and bring back a name rather than a number? Im sure its possible?
Alsoo...In one column I have the date and time mixed together 'DD/MM/YYYY HH:MM' for example. Is there either a way to split these up, Or when doing a query to only search for the date and disregard the time? So for example search for all records on 1st may but at whatever time? Even though they are in the same column.
Hopefuly this makes sense to someone
I have a table with all my texts backed up from my phone and I put it into an access database because its the easiest way to add new ones without duplicating (I feel anyway)
The only problem is, It shows up the number rather than a name for who its sent by. Is there anyway for it to lookup the number in another table where I would have the contacts saved, and bring back a name rather than a number? Im sure its possible?
Alsoo...In one column I have the date and time mixed together 'DD/MM/YYYY HH:MM' for example. Is there either a way to split these up, Or when doing a query to only search for the date and disregard the time? So for example search for all records on 1st may but at whatever time? Even though they are in the same column.
Hopefuly this makes sense to someone
Last edited:
