Search results for query: *

It worked great...I just changed the Data Entry property, thank you very much.

I have some forms that I add Students or Classes into their respective tables. Just to make it more user friendly, how do I set it so when I open the form, everything is blanked out and is ready to enter in a new record? Right now I open the form and it displays the first record, then I have...

I have two tables...Classes and Rooms. I have a form where I can add new classes and assign it a room. The rooms never change, so I am using a combo box to assign the classes to a room. But when I add a new class and select a room from my combo box, it adds a new RoomID into my Rooms...

Is there an easier way to create a "Next" macro in Excel than just recording a new macro and clicking on the next worksheet? I would like a button that I can just copy from one worksheet to the next that will go to the next page. Same applies for "Previous" button. Any assistance would be...

Okay, I just figured it out... In design view of your query, under criteria you put: =Yes That will display all the checkbox's that are checked.

I am drawing a blank on how I run a query on if a checkbox is checked. I have a table of people, and in that table is a column that specifies if they are a "Leader", if it's checked, they are a leader. I want to run a query on all the "Leaders" in the table...how do i do this? thanks for any...

Do I change it in the Properties > Data > Control Source?? Because when I change it there, I get an error...

I am making an Access report...in this report I have a section that lists a person's First Name, Last Name, Address, City, State, Zip. Is there a way I can apply a trim function to those bound controls, so I don't have to worry about there being a lot of space between someone's first and last...

Is there a way that I can change the font/color scheme of my entire webpage? I want all of my pages to have the same font and color scheme...is there an easy "catch all" way of doing this??

Nope, I am using Access. And right now, all I'm doing is writing the SQL statement to see if I can do this, I've got a good idea on how I want to display it in Cold Fusion.

In my database I have a table called Employee. Within my Employee table I have a column called EmpNo...along with EmpName, EmpPhone, etc. ALSO in this table I have a column called SupEmpNo (Supervisor Employee Number). In that column I have the employee numbers of their supervisors. What I...

Okay, this is kind of weird... I have a table that keeps track of all of the employees for my company, we'll call it Employees. Within this table is a column for the supervisor for each employee. Since the supervisors themselves are employees, they are also in in the Employees table. So Joe...

Here is my SQL statement: SELECT OrderTbl.OrdNo, OrdDate, OrdName, (ProdPrice * Qty) AS TotalAmount FROM OrderTbl, Customer, OrdLine, Product WHERE OrderTbl.OrdNo = OrdLine.OrdNo AND Product.ProdNo = OrdLine.ProdNo AND Customer.CustNo = OrderTbl.CustNo AND OrdDate = #1/23/2004# I need it to...

Okay...I have a list of customer orders with their totals. They are grouped by the items that were bought, so if you bought a car, that is one record, and if you also bought a truck, that is another record with the same order number. How do i group those two records to display the total amount...

Thank you, that works perfect.

Okay...that worked, thanks a lot! But I was trying this for the fun of it, what if i needed to add in that the AvgBal needed to be less than 100? I tried this: SELECT CustCity, AVG(CustBal) AS AvgBal, left(CustZip, 5) AS ZipCode FROM Customer WHERE CustState = 'WA' AND AvgBal < 100 GROUP BY...

Here is my SQL right now: SELECT CustCity, AVG(CustBal) AS AvgBal, left(CustZip, 5) AS ZipCode FROM Customer WHERE CustState = 'WA' GROUP BY CustCity It works fine when i take out the ZipCode part in my SELECT statement...how can i get it to work with the ZipCode part?

I need to run a query that will take the average balances of customers by city. So for example, I would need the average balance for all customers from Chicago. So I would display one row for Chicago with the average balance of all customers from Chicago. I try using the DISTINCT function...

The DISTINCT clause just ordered the repeated questions together. And when I changed it to just <cfoutput>, it only displayed the first question, and not the others.

The output I am getting is correct. But it displays it three times, instead of one. I am display a question, and the answer to that question. I want it to run through that and display each question and answer once, but it displays it three times. Any ideas?? Here is my code: <cfquery...