Search results

read/write. Thanks for your time by the way.....

I tried that will no success. I made a query based on the table, limited the top values to "3". The problem I'm having is that it limited all the records to 3. I need to limit the amount of records of the same foreign key to 3. Any ideas?

I should have explained more. The subForm is based on child table: Parent table: tStaffMembers Child table: tRatingChain I want to limit the child table to three record per staff member.

Is it possible to limit a subform to 3 records?

I have a Form 01 that has staff names and the primary key StaffID. From this form, I want to open Form 02 to add a new record linked by the StaffID. How do I automatically populate the PK (StaffID) in Form 01 as the FK (StaffID) in Form 02?

Thank you CJ & pbaldy! I'm going to check these out....looks like exactly what I'm looking for.

I have a db tracking vacation times for staff. One of the fields tracks a members vacation start and end dates. I need a way to pull a report to see who is on vacation based on Date() (today). Is this possible? For example: A record for John Doe has him start vacation 08/19/2014 and end...

Okay, so got some help from another member. The trick was to use the Nz function in the subreport instead of the query. Worked great! Thanks all!

I see. So, you used the Nz function in the subreport field instead of the query. Thank you so, so much!!! I've learned a bunch from you over the past day or so!

Thanks UG! I'll check this out now...

Hi Bob. Thanks so much. I tried this as well. I get a "wrong number of arguments...." error pertaining to the change in the "Count(Nz...." sytax.

Thank you JHB! I've tried this: SELECT tdsIndivData.dsReportID, Nz(Count(tdsIndivData.StaffID),0) AS CountOfStaffID FROM tdsReportData INNER JOIN tdsIndivData ON tdsReportData.dsReportID = tdsIndivData.dsReportID WHERE (((tdsIndivData.Availability)="75% Availability")) GROUP BY...

Field B is a combo with the options of : 100% Availability, 75% Availability, 50% Availability, 25% Availability, OR Not Available If I choose "Present" in Field A, I want the "Not Available" value to disappear as an option. Any ideas?

I tried that on the Load event. Not success. Here's more details: I need the following to display a zero if a null value is returned: SELECT tdsIndivData.dsReportID, Count(tdsIndivData.StaffID) AS CountOfStaffID FROM tdsReportData INNER JOIN tdsIndivData ON tdsReportData.dsReportID =...

I need the following to display a zero if a null value is returned: SELECT tdsIndivData.dsReportID, Count(tdsIndivData.StaffID) AS CountOfStaffID FROM tdsReportData INNER JOIN tdsIndivData ON tdsReportData.dsReportID = tdsIndivData.dsReportID WHERE (((tdsIndivData.Availability)="75%...

Got another question: Is it possible to limit the value options in "Field B" using a similar code method? Specifically: Field B is a combo with the options of : 100% Availability, 75% Availability, 50% Availability, 25% Availability, OR Not Available If I choose "Present" in Field A, I want...

Worked perfectly and I learned something- thanks GinaWhipp!!

I have a form used to track attendance of employees: I want to update a value in Field B to a default value if a specific criteria is selected in Field A. How? I cannot seem to find a answer... Specifically: If the combo box value "Not Present" is selected from Field A, I want to value in...

Okay. Also, I just realized how dumb I am. If I based the combo box on a query of the two tables in an INNER JOIN, I won't get any of the "bad" records I've been so worried about! Thanks again for your help! GREATLY appreciate it!!

Okay, I see now. Do you have any other ideas on how to automate the delete of the record? Basically, the reports will be available to view in a report object selected by a combo box or menu. I don't want to have records available that have no data!