Recent content by bpd

I am doing a report where I have my page formatted into two columns. I have the same basic info in each column (name, qualification %). They are basically split up into section 1 and section 2, that is why I have the two columns. Right now my report just lists them in order (down the left...

I have a table with 4 pieces of info that I need to display on a form: Watchstation Name Qualstatus Watchsection (1 or 2) I would like to have my report formatted so that there is a split-screen (vertically) (like you can do in WORD). In the left column I want to list everyone in section 1...

Nevermind. I got it with the Me.requery function. Works great now. Brian :D

This should be fairly simple, but it is driving me nuts trying to get it to work right. I feel like I'm chasing my tail. Anyway, I have a query with three fields: "PersonnelID", "QualificationID", and "QualificationStatus". This is a query off of my large table for tracking qualifications...

Thanks a lot John. :D

I have a query where the first column is an integer type number 0-100 representing a percentage. I have learned how to create a second field that converts this integer into letter representation (see below): QualPercent:IIf([PercentComplete]=100,"Q","NQ") This works fine. However, this is...

I have a query that has three columns: [watchstation] [crewmemberID] [%complete] I have a form that has the same three columns. The first two are combo-boxes and the query is set up to be filtered twice based upon the selection of the first two combo-boxes. So I always get a query result of...

(sorry, I'll try it again with underlines for the spaces - that don't show up) ________Qual1 Qual2 Qual3 Qual4... Name1 ___X ____X_________ X Name2_________ X____ X Name3_______________ X___ X Name4 ___X ____X (had to use lines since spaces don't work)

I have a database where I track personnel and qualifications for the Navy. I can generate reports per individual, group, etc..., but I would like to make one version of the report where I can list the personnel down the y-axis and the different quals down the x-axis. Then, in the box where...

Wayne, Thanks a bunch. I just used the following in the "conditional formatting" cell of the report: [duedate] < Date() And [%complete] < 100 and it worked perfectly. Didn't have to use IIF statement. I was able to generate a report of ONLY the overdue records by using two parameters to...

I posted the following the other day in the Reports section, but I think it is a more general question. I had intended it for use as conditional formatting for a report; however, I guess I could also use it as a parameter in a query and have the report draw that data. Help. :eek...

Thanks. I'll try it out tomorrow at work. I assume "myreport" is the name of the report that generates data on everyone, so I should substitute the name of my report there.

follow-on question: The above report gives me the status of everyone and their qualifications and I can look through it and see the overdue ones based upon the background color (at least I hope it will in the future). So how do I generate the same report and only show the "overdue" records...

I have one table that tracks personnel information (lastname, firstname, department, etc...). A second table that lists all of the various types of qualifications throughout the organization (qualnumber, qualtitle). A third table combines the data to store each qualification record...

I am generating a report that tracks progress in certain qualifications (with the following fields showing): lastname duedate %complete I can already use conditional formatting to show the background of the "%complete" cell as green if %complete=100 (finished). What I would like to do...