Search results

Please find attached a picture of the relationships I've established for my civic league database. My problem is that there can be more than two people (with different last names) living at the same address. I would like to be able to create mailing labels for one address while addressing all...

Hello all Just a quick question: Why does this work perfectly: RunTimePoints.Value = DLookup("PTPoints", "Point Table", "PTRun = [RunTime]") yet, this doesn't: rst.Fields("RunTimePoints").Value = DLookup("PTPoints", "Point Table", "PTRun = " & rst.Fields("RunTime").Value) I'm...

I feel like this could be a single quote/double quote problem or maybe I'm asking too much out of a single query, but here goes. I have a table (called Cadet Data File) that has several fields, 4 of which are: CurlUpPoints, RunTimePoints, PushUpPoints. All numeric (integer). Then there's Sex...

Hello :) I'm working on a database for a Homeowner's Association. I'm creating "Complaint" forms. There are 15 different types of complaint items. I'd like to set these up as yes/no checkboxes. They are as follows: Peeling paint Loose/Missing Roof Shingles Sheds/Fence in disrepair Vacant...

This forum has been so helpful to me in the past that I thought I'd offer this tidbit of code that I discovered by myself while I was creating a report in Access 2000 in case anyone else has been stumped by this problem. I'm creating a report that lists grade scores of students in descending...

I have created one table of cadets with typical things such as Last Name, First Name, etc. One of my fields is named Platoon with a data type as Text for data input as 1,2,3...etc. Since there will be no "computation" on this field, I felt it would be better to define it as Text rather than an...

Hi - I have a simple database with one date field named [Date] formatted for Short Date. I'm keeping information about Anniversaries, Birthdays, holidays, etc. Anniversaries/Birthdays have dates that "are in the past". I want to develop a query that will retrieve those records that fall...