Search results for query: *

I have a multiple parameter query that allows me to enter multiple UnitId's and displays the corresponding info I request in the query. My question is this - I want the unitid's to display in the query and eventual report as I enter them into the parameter query. The unitid field is a primary...

Thank you PH - worked like a charm.

I have a form titled frmApheresisTrima based on a table titled tblTrimaSpectra. Within the Form is a subform titled frmApheresisTrimaSubform. This information is tied into a calendar control – in other words I can click on a date and it will display donors in the subform for that day. What I...

I want to include the Patients or Donors - you can't be both. If you are a Donor and Other, then I need to exclude them from the query. So, I want to list Patients or Donors minus Donors who also have Other checked. Sorry If I am making this complicated...thanks for the help.

These are all True/False fields. HLA A/B - Needs to be true (criteria) Patient - Needs to be true (criteria) Charged - Needs to be false. (looking for those not charged yet). Donor - this would be on the Or criteria row and needs to be true. There is a field called Other - which is a true...

This seems easy to do but I am drawing a big mental block! This query is based on a single table. There are certain conditions that must be true - such as a certain blood types, not charged for testing, patient, donor or other. I will display the persons name who meets these criteria. The...

Thanks for the input. Trying to play around with your suggestion. The fields are just Yes No values. My dilema is to sum patient or donor in one query but to make sure to not inlcude donors who have the other field marked.

I am trying to constuct a query that will count multiple fields that fall within a date range. You would think this would be easy but I seem to have forgotten query basics. I have a date received field (will set to be prompted), I want to count blood types for those who are a patient or donor...

Thank you...trying to modify your code but I'm not getting the RunNumber to incriment. I'll keep playing around.

I have three fields on a form titled Sequence Number, Run Number and Unit Number. There will be many run numbers for each sequence number - I am using the following formula to automatically increment the run number (=DMax("RunNumber","tblsequencetesting")+1). Approximately...

I have fields on my form titled Box# and Slot#. Each Box contains 81 slots for test tubes (Slot#). The below code shows how I am able to limit the entries to 81 – this works fine. Basically it assigns slot #’s between 1 and 81 depending on the last entry. What I want to do is copy the...

Thanks Bill - it definitely makes the db visible, but the report just prints and doesn't let me view it first.

Have a form that is used to access reports that are located in several databases. Below is the code for one control on the form - it is set to print. I want to have it go to print preview instead. Well according to my research all I need to do is change acViewNormal to acViewPreview which I...

Aqif, Thank you for the assistance - I am having some issues getting it to work though. I am receiving this error message: "Syntax error in date in query expression Box# =32" The 32 is the box# I typed in. I will try to provide a little more info that may help. I want to be...

Aqif, Thank you for the assistance - I am having some issues getting it to work though. I am receiving this error message: "Syntax error in date in query expression Box# =32" The 32 is the box# I typed in. I will try to provide a little more info that may help. I want to be...

I have a field titled Box# which is unique. This Box# contains 81 slots for test tubes. There is a field titled Slot# also. I want to be able to enter in the Box# and have it automatically put in what the next available slot# is (1-81)for that box. In essence I want it to be able to remember...

Not sure I follow you on how to handle the first and last name. Thanks for the input.

I have a drop-down box where users can select a name - this name contains both first and last which is derived from a query. After the selection I want this name to be split into two fields, First and Last and placed in their appropriate table. Thanks for your assistance. More info - I did a...

I've been messing with this for days with little luck - hopefully some of you have some suggestions. I have StartTime and EndTime fields in a table that are used to calculate when Volunteers start and finish. In a query I am trying to calculate the hours worked and then be able to sum up this...

The calendar is not linked to Access at all - it is seperate and is manipulated on a monthly basis. Basically, I want to take an access report and insert it as Page 2 with the calendar (created in Word)as Page 1. This report will change on a monthly basis so I was hoping that by opening the...