Recent content by Brachy

Build a query using all of the fields in your table. You can select the fields that you want to sort (ascending, descending) in the query design screen.

It is possible. But it might take a bit of work depending on what your client has already. 1) Create an employee table with the following fields: UserName, Password, AccessLvl 2) Create a custom log-in form that is linked to the employee table. 3) You can now check what access level the...

Try http://gregmaxey.mvps.org/Word_Frequency.htm

This is kind of a dirty way but try... =COUNTIF(A1:A30,(">1/31/2009"))+COUNTIF(A1:A30,("<2/8/2009"))-COUNT(A1:A30) Where A1:A30 is the range containing your data. The formula gets the number of dates that satisfies the lower criteria and adds it to the number of dates that satisfies the...

I work in a cancer hospital, so I get to see a lot of nasty stuff. Let me tell you, there's nothing nastier than pancreatic cancer. Jobs had it removed 5 years ago. Well the 5 year survival rate for this type of cancer is somewhere in the neighbourhood of 5%. In other words, 95% of people...

This may seem like a stupid suggestion. Why not use a CMS? It seems that 90% of what you are intending to build can already be found in a CMS such as Joomla.

Check your config.php. You should see something there about gfx_chk. Brachy

Create a new query that includes all the fields that you need for the report. Enter the following on the Criteria line of the Production Date field (in query design view) >=[Enter Start Date] And <=[Enter End Date] This parameter query will prompt the user with the text in the square...