Search results

It is in the report's detail section

And in regards to security, I actually did raise personal objections to storing the SSNs in the DB, but the front ends are all password protected and the backend is on secure server. My boss decided that this was better that the stack of paper in an unlocked drawer method we were employing before.

The SSN is a number data type

Test inputs: First Name , Last Name, SSN, DateofVisit, CashforVisit This , Works, 123456777, 1/1/2010, 101 (should not be counted) This , Works, 123456777, 1/4/2011, 100 (should be counted) Testing, Testing, 123456789, 1/5/2011, 500 (should be counted) Testing, Testing, 123456789, 1/6/2011...

I'm sure that the dates are right, the system has not been implemented yet, I only have a few test inputs. Thank you again for your help

You nailed that one, I changed [DateofVisit] to be a date field rather than text. I fear my inexperience may be showing. However, After changing this and providing new inputs, it is still not working. The code runs but does not provide any values for an output, likely indicating that it cannot...

The code now runs, but does not successfully remove the payments that were made in different years. Any ideas? I really appreciate this help.

Thank you so much! Unfortunately, it is giving me the error "The expression you entered contains a function with the wrong number of arguments". What would be the source of that error?

I am currently programming a report that needs to spit out all of the money paid to a specific client. The Dsum function I used was: =DSum("CashforVisit","Financials","Financials.SSN= " & [SSN]) Which worked excellent. However, I need a way to add another criteria to the DSum function...

I am currently having some trouble designing a table for a specific problem at my work. Here is the capability I am looking for: 1 Patient name, up to 5 tests (number of tests and name of test need to be adjustable variables), and test scores for each test for up to 21 weeks. The form would...

Hello, I am currently experiencing a problem that seems to be identical to yours: the tables have a one to many relationship set up correctly in the backend, but the linked tables in the front end does not display the relationship (no little (+) to drop down related records). Can you please go...