Search results for query: *

Good afternoon, I was able to create the database using this design. My question now is, can you create a form to use to input the data into the tables..if so, how? Thank you! Sarah

Thank you for all your suggestions! I'll see what I can do now.

There is one record for each month. There are about 50 fields that correspond to the 50 questions on the form, the answers are a percentage. So my table looks like this: Date 1.1 1.2 1.3 2.1 2.2 2.3 2.4 etc 1/1/10 90.0 99.1 92.5 96.7 88.4 80.0 100.0 etc 2/1/10 90.0 99.1 92.5 96.7...

I have a table that has a field for each question on a survey. I want to create a report based on the criteria entered by the user showing a chart with the trend for the question they entered. I only want the date and one question field to appear on the report. I don't want to create a 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...

The query has the following fields: ID field, 4 digit, name. I've put sort on the 4 digit field. The people using it won't know what the id field is. I get an excel list and import it into this database, and the key/id field is auto assigned at that time. It works until you try to pull...

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

Where would I add this? (Sorry, this is my first time trying to add this kind of thing.) Private Sub CopyControl_Click() Me.txtTextboxB=Me.txtTextboxA End Sub And how would it read if I want to copy from "Client#" on Form1 to "Cust#" on Form1? Thank you!

Thanks, i'll give that a shot! There's a 50/50 chance the info in the second control will have different data.

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

Every part of the query, except the PhoneTime works correctly. It's really weird.

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

FABULOUS!!!! Ok, this may be a silly question, but would I add the next Select for my query? Say I wanted to grab the field Total from a Table called Cases.

I tried the cross tab query, but it doesn't come over into the reports like that. I need to be able to manipulate the numbers and move them around the page. I tried the new query, but it's returning with an error, "Missing ), ], or Item in query expression '[QC'er]=[First Last] AND [Today's...