Search results for query: *

How do I display the field name as a value in my query?

i was given a very big txt file, that when i put into access is a complete mess. Though there are about 300000 records, i have identified in one of the field 163 unique values. I assume these are field names. I was wondering how i can make a table otu of these 163 unique values, so that i...

In my group header I have a Sum field where it sums all of the Money data in the details isection. How do I sort by this field. I want the report to display from highest value to lowest value, however in sorting and grouping box, it only allows me to choose from fields in in the query the...

I am collecting data in a field from an option box. How do I count the totals of any certain value. I am trying to use the query below, but it is giving me odd results. SELECT [Wd] & " - " & [PR] AS Precinct, Count(ContactTimes.ContactData) AS CountOfContactData FROM [DF Voter File] INNER...

i am designing a database which is meant for scheduling people to a certain location. I Wwant to be able to limit the number os records able to relate. For example. Table 1 - People (25 records) Table 2 - Location (3) Each of the location records allows for a different number of people...

I put a Find record button on my form, and I want to always look up on a certain field, no matter if i have selected another field. Can this be done?

i Have a field that has numbers in (though they stored as text) I want to be able to pull just even or odd numbers? Can I do this?

what is the best way to design a many-to-many relationship. the scenario is : I have employees and i want to register their concerns. Such as: Name Concern Sally Wages But I at one point will want to create a report of everyone and there concerns but also a report of every with a...

I just got a new job, and I inherited some MS Word Documents that were saved. When I click on Send an an email after I open it up there are tons of email addresses stored in these documents. I have been asked to try to get these out so I can import them into a database. So I select all, and...

I have written a query that does a simple division funtion, however the results always round down. I would like it to show the value in its entirity. The SQL is: SELECT Registration.[Room Type] AS Label, Count(Registration.[Room Type]) AS [Count], [Count]\[RoomValue] AS Dividend FROM...

I have built a registration database, and on one of the forms there are two checks bocks labeled Canceled Before Deadline and Canceled After Deadline. So if these check boxes are checked I do not want these records appearing on reports. However the queries I am writing for the reports do not...

How do I count only YES values in a report? When i perform the count operation it is counting both check and unchecked. Thanks for any help.

How do I add a summary section to my report that counts based on value of a field. I have a field in the report that has has 3 fixed values: Double, Triple, Quadruple. What I want to do is have a summary that will count each one of these values types, but I want to expand the mathematical...

Roommate Report. I am trying to make a report that lists, people and roommates. However, because both people are stored in the table, I am getting doubles. Name Roommate _________ _________ Josh F Barb A. Barb A. Josh F. SELECT Registration.[First Name]+" "+Registration.[Last Name] AS...

I have a sub form on my main form. the main form registers a person, and the sub form registers that persons guest. It dumps both people into a Registration table, however the long integer field in this table that records the guest (identified by RecNumber) is not recording what I like. The...

So I have a main form where i register someone. In this form there is a subform where I can register someone as a guest. ALL of the data is stored in a table called Registration. In the Registration table there is a Long Integer Field call Roommate that looks up a person guest by their...

OK, I have a form with a dop down box on it that allows me to pick other people in a registration table to list them as a roommate. The events looks like this: If Nz(Me.Roommate, 0) > 0 Then strSQL = "UPDATE Registration SET RoomMate = " _ & Me.RecNumber & " WHERE RecNumber = " &...

I have a check box field on a report, and I only want it to be visible IF the value of the field equals YES. How can I accomplish this.

Here is my dilemma. I have a database that we use to register people for a conference. In the table Registration there is a Long Integer field for Roommate, which stores the Value of the RecNumber value of a another record. This was so I could assign roommates based on people who were already...

I have a table for Registrants to an event. In the table I have field for the registrant’s roommate, and the row source is: SELECT Registration.RecNumber, [First name] & " " & [last Name] AS [Full name] FROM Registration; So let’s say there is a record Jim Smith, and I want to make Jim’s...