Search results

Worked like a charm. Thank you!

I am trying to use dlookup on a subform to find a score (from a table) based on 3 criteria - age, rank and total. Here is my attempt but it looks up the wrong data from the table: =DLookUp("[SS]","[tblWAIS]","[Raw]='" & [Total] & "'" And "[Age]='" & [Age5] & "'" And "[Rank]='" & [Rank2] & "'")...

I will try that - thank you so much for your help! Will report back as soon as I have a result

I have a list of 120 items and each has an associated value - a point. I have put them in a table 2 ways - first in a table where each record has 2 fields - description and point value second I tried a table where all 120 are listed as separate Y/N fields with a default value of whatever the...

I need to make a form that lists 120 checkboxes and then adds an associated value to get a total. I have a table with Description field (i.e. aspirin) and a Points field (i.e.2) I need to make a subform that shows 120 checkboxes and when the user checks the boxes the associated points are...

I have a database that contains departments, items and prices charged. Some departments have charged different prices for the same item. I need a report to show if a department has charged a different price than other departments for the same item. Many departments charge for the same items...

I have an access 2010 form that has a date field and two textboxes. Trying to only show 1 text box based on the date field. Example: If Date >= 10/1/2010 and Date <= 9/30/2011 then text box 1 is visible and text box 2 not visible if Date >= 10/1/2011 and date <= 9/30/2012 then text box 2...