Search results

If i understan correctly, then I think you may want to look at the query you are using already. Try useing GROUP BY on the field and see if that get the results returned the way you want.

If you are using Access and Excel, then I suppose you are using Word for the label generator. You can work this in 3 ways. 1 Create a query in access that concatenates the 2 desired fields. Then use the form creator with the label type you have and create them straight from access. 2. Import...

Being from Chicago, I could say the worst thing that could happen would be Daley running for Prez. He may have been voted best in the country, but how many of those voters were dead years ago? How many 400 million dollar shiny beans do we need in this country? And pray that his wife doesn’t find...

You could use a query to generate the data into a custom field with the setting of "1/" & Month(Now()) & "/" & Year(Now()). This would always display 1/curMonth/CurYear

What about the documenter function in access? Could that do what you are looking for? Tools - Analyze - Documenter

So far I have dealt with the minor things like installing track lighting in the loft and added a few phone lines run with cat5. I am looking into putting hardwood on all of the first floor, its the time it would take that has me putting it off.

I would find it hard to believe that an exchange migration would have such an adverse effect on Access. Have there been any updates on the machines encountering problems that has not occurred on yours? Do you have the exact same version of Access as they do? I ran into an almost identical...

You can use the build function in the query builder to get what you are looking for. For first names it goes like... FName: Left([tblStudent]![stuName],(InStr([tblStudent]![stuName]," ")-1)) Here you find the space in the name field (InStr([tblStudent]![stuName]," ") and then use it as the...

A little more info would help, but what you need to do is use a count on the table booking with the criterial of the selected venue. Then you would subtract the venue capacity from that to determine availability. Create a query and add a field AvailSeat: and use the build function to create the...

What you are reffering to is the developers version of Access. You can sort of "compile" your database into an installation with the Access Run Time environment, which is not Access, but will allow the database to function pretty much as you would expect. THIS WILL NOT CREATE AN APPLICATION...

You have 1-1 relationships? If so then the data from those tables should be in one table. You would not break down tables that contain unique data about 1 record so there should not be any 1-1 relationships as there should also be no many-to-many. Double check your table structure to see what...

Heres an idea. First , you need to create a union query to seperate out just the 123, 234, & 345 class enrollment. <!-- This is the UNION query --> SELECT tblEnrollment.EnrollmentID, tblCourse.CourseName FROM tblCourse INNER JOIN tblEnrollment ON tblCourse.CourseID = tblEnrollment.Course WHERE...

It really depends on the table layout. If all of the data is in a single table you have to normalize to get it working properly. You should have a student talble and a course table, then to connect a student to a course you should have a junciton table. The junction table would contain the keys...

IMHO, there is no conspiracy. Here in the states the politicians respond to those that voice thier opinions loudly, AND TURN OUT TO VOTE. Unfortunatly, there is less than 50% of the LEGAL population registered to vote, and only 1/2 of them usually do. Those that vote regularly are usually...

Looks to me as if you set the FilmID in the copy table as the primary, cant do that. You should have 3 fields in the table copy 1 A PKey, 2 The Foriegn key, 3 the actual field to contain the # of copies (number format). Link it to the Film table via the tblFilm pkey and the Forign key in the...

Sorry to have been out of the loop, I have been swamped lately. As for books, I have founs nothign to surpass New perspectives. They take you form left click right click (explaining a mouse) all the way to full DB develppment...

When you look at these three tables, you should think of them as separate databases. I agree that if you are looking to develop something that is going to incorporate massive film data (artists, producers) you should have separate tables for each. Otherwise, combine all of that info into one...

You could also search these forums for Cascading Combo Boxes, youll get about a thousand hits.

First off, you have some major naming convention problems. You should not have spaces, reserved words, or any character but letters and numbers (best practice). The tblLoanDetails will work as a junction and history table between the other two tables. Make sure that the CustomerID and FilmID in...

Is the database in development or is it something that already exists that you have to work with? There are options at going at this but a few more parameters would help in getting an idea of how to go about it. At both mileage and fuel purchase in the same table? Is there any sort of primary...