Search results

Thanks, thats almost there. That basically displays the result of the last time the query run. Idealy I would like it to update automatically, do you know if thats possible?

Hi Does anyone know if it's possible to show the results of a query on a form? I have 4 people entering various "outcomes" into a table. There are a possible 8 different outcomes and the one i'm interested in is the "completed" outcome. I would like to be able to show on the form used to enter...

perfect, thank you!!!

Hi I have a table in sql holding telephone data. the starttime column and endtime column are both in "10/05/2006 12:55:56" format. I want to run a parameter query that lets me search by agent name and then by date. The agent name is no problem but when running parameter query by date it brings...

Hi I have a simple select query that pulls data from a table in a sql db. the query shows all records for "agent1". if agent1 has made numerous entrys it shows all of them how can i get it to just show the total of all entries? i've tried selecting the sum option in query design but it says...

Hi I want to be able to run a query within access that lets me chose "agent" and a specific date or a range of dates. I have a table with "starttime", "endtime", "agent", "phonenumb" and a datediff calculation that calculates the diff between "starttime" and "endtime" the "starttime" and...

Hi I have a table with "starttime", "endtime", "agent", "phonenumb" and a datediff calculation that calculates the diff between "starttime" and "endtime" the "starttime" and "endtime" columns are in "10/05/2006 12:57:55" format, i.e. the column holds both the date and time The data is stored...

Hi I have a table with "starttime", "endtime", "agent", "phonenumb" and a datediff calculation that calculates the diff between "starttime" and "endtime" the "starttime" and "endtime" columns are in "10/05/2006 12:57:55" format, i.e. the column holds both the date and time The data is stored...

Hi Does anyone know a basic and quick way to write to a table in a database using a web page instead of a form? the webpage is stored locally as is the database Thanks Ben

idealy i would like to store the total duration in another column and have just automatically calculate when the data is added, do you know if this is possible?

Hi I've got a table that stores information from my telephone system. there are a couple of columns that contain times of when a call started and when it finished. the format is 17:11:30 for both the start and end times. i have added another column and in here i want to have the call duration...

thats works perfectly, thank you!!

Hi I have a database which uses the auto dial function. when someone hits the dial button the date and time of that "click" is logged in a table and basically shows when the record was called. does anyone know of a way to log the username (i.e. windows login) of the person who is logged into...

i've tried that but it still lets me move on to the next field!

Hi I have a form where data is entered and outcomes are entered. Any ideas how i can make the outcome field mandatory before someone moves on to the next record? Thanks Ben

Hi I have a set of data in a table that is full of dupes, anyone know a simple De-Dupe Query? Ideally by phone number Thanks Ben

Hi I have a DB where I take orders throughout the day and the time is stored in hh:mm:ss format. Anyone know of a query that I can run that will show me how many oders between certain time? I.e. between 18:00:00 and 18:59:59 Thank you if you can help me!! Ben

Hi I have a DB where I take orders throughout the day and the time is stored in hh:mm:ss format. Anyone know of a query that I can run that will show me how many oders between certain time? I.e. between 18:00:00 and 18:59:59 Thank you if you can help me!! Ben

Hi John Thanks v.much - You've just saved my a$$ Cheers Ben

check out this attachment, this should be clearer. there are 3 records in there. double click the url in the first record and it open fine but in the second and third it contains an error