Search results for query: *

Say I have a list that looks like the following: boy dog cat hat small it lady run shout and I want to randomize the order in which they appear so that a randomized list might look like the following: lady shout boy it small run dog hat cat Currently, I fill the column to the right of the...

I was wondering if there is a particular function that can randomize a list of values in a column in Excel? I know that this may be accomplished by generating random numbers in a column next to the column with the desired values and then sorting the column, however, I am looking for simple way...

Thanks for your help. I ended up just using this simple code in the form itself and it seems to do the trick: =DateDiff("yyyy",[DOB],Date())+(Date()<DateSerial(Year(Date()),Month([DOB]),Day([DOB])))

Thanks for all your help, I appreciate it.

I am trying locate a function to cleanup dates in an excel spreadsheet so that all of the dates are in the following format: mm/dd/yyyy Currently the formats vary, here are some examples: 1/1/97 01/04/92 3/12/1999 I wanted them to look like the following: 01/01/1997 01/04/1992 03/12/1999

I have a column with a person's date of birth listed. I was wondering if there is some function that I could use which would return the person's current age based on his/her birthdate and the current date, which would update for each day?

That worked perfectly, thanks!

I am trying finish an access database that I started for the lab I work in where I want to store subject and study information. I am almost done with the database, I'm just trying to add little features that my boss wants. Currently I'm stuck on a DCOUNT issue where I am trying to count the...

DCount("Study_Name", "Subject_Study", "Study_Name = 'Stroke'") That ended-up working perfectly. Thank you very much for the help.

from the ACCESS 97 Help File Syntax DCount(expr, domain[, criteria]) The DCount function has the following arguments. Argument Description expr: An expression that identifies the field for which you want to count records. It can be a string expression identifying a field in a table or...

=Sum(Abs([study_name]="Stroke")) I tried that in the footer as well and received #error again.

I tried this first and then changed it to the second and still the same error message, I'm sure I'm entering the expression incorrectly, but I didnt find much help for dcount from Microsoft. =DCount("[subject_study","study_name","study_name = 'Stroke'")...

I want to write a function for a basic textbox in a form to display the amount of time a particular study appears in a table. I know I need the count function and an if statement but for some reason I get an error message when I try the following...