Filter by date on the fly
Hey me again. I've been trying with the tips you gave me for a while now and I think I'm getting closer to the solution.
However, I just can't seem to get it to work.
Is there a way I could attach my database or send it to you by email or something.
That is if...
Thank you for your help I REALLY appreciate people like you who take time to help others. I'm getting closer to the solution now.
However, what do I write in the CDate(??????). How will access know that the date is only the first 8 characters. How will access know that 01062005 is DDMMYYYY...
Helo…please really need your help.
I designed a small desktop database to automatically import some Log files. A sample of a transmit log file (emails sent from our rural email stations) looks like this when imported in access.
Date Time Direction Sender MessageID
03062005 133501...
NO your not off track. You will find this easy. First your tables have to be already defined. You should have a table for your users and a table with your departments (with data already entered) right?. You also need a relationship between the two tables which I assume you already have.
Ok...