Search results for query: *

Good afternoon, I want to write a query in Microsoft Access 2003. Let's say I have a database called 'test and it has the fields 'Date', 'A', 'B' and 'C'. I want to have a query that has a pop up "question", and the user would answer with one of the columns names (A, B or C). I want my...

Good afternoon, I'm working on an Access database form, and I've added a drop down box to help find records. The table I'm working from has 1000's of records. The two fields I'm using in the drop down are a field with just 4 digits and a names field. I've got the drop down to search for...

I have a form where 1 field may equal a previously entered field on the same form. Is there a way to create a button, that when you click it, it will copy the data from Field 1 and paste it into Field 2? Thank you! Sarah

I have an Access form created that will have a handful of people updating it. I was wondering if it was possible (if so, how?) to add a button to the form that will open up/or send an email (with the form attached) to a set number of recipients when it is pushed? THANKS!

I have two tables: one is for employees to record time spent outside of their main job objectives and the second is for supervisors to record absences. Both tables have the same fields and I want a query that combines the two and lists them. ex. John 1/1/08 2 hrs phone John 1/2/08...

I'm using the query below and the PhoneTime results do not not show up correctly. If I run the query for one day, the results are correct, if I run it for 2 days the result is twice what it should be, if I run it for 3 days the result is 3 times what it should be, etc. Does anyone know how to...

I've got a split database with several users. The backend is on a network drive and the frontend is on the individual PC's. Basically the frontend is just a form and the people working in it add records. Everything has been running well until today. Today when they tried adding new records...

I'm having problems with my query. I want to sum each field for clerk. But I either get each clerk once with a sum I don't recognize, each clerk more than once with separeted sums (but they are correct), or an error saying that two of my fields (CC and Cases Promoted to QC) are not part of an...

I'm having problems with my query. I want to sum each field for clerk. But I either get each clerk once with a sum I don't recognize, each clerk more than once with separeted sums (but they are correct), or an error saying that two of my fields (CC and Cases Promoted to QC) are not part of an...

Can you use an expression, in a SELECT statement in an Access Query that would take (from the following example) the first Select statement and divide it by the second? Thanks! Sarah SELECT (Count([Date/Time])*5) AS QADateTimePR, (SELECT (Count([Date/Time])*5) FROM [QC Information] WHERE...

I'm starting with this SQL query in Access and will add on if I get what I need out of this. This Union All query looks like this when it's run: Name Totals QC'er # TimeAway # I want to be able to use these totals in calculations in a report and to format them there. So, is...