Search results

*bump* Could anyone translate the last poster's SQL into something I can put into the Expression Builder? I would greatly appreciate it.

Alright, thats sounds good, but Client and Order Date are in the same table, whereas Case Manager is in a separate table. Could you post the correct parsing/syntax for that? I apologize for my lack of SQL knowledge.

Ok, I have a query that returns a case manager, their clients, and a date attributed to each client. Ex: Case Manager Client Order Date James Bond Pussy Galore 01/05/2005 Oliver Cromwell Janet Roundhead...

I love you :) Thanks man, worked like a charm.

I am attempting to calculate a due date via an expression that calculates 90 days from a specific field. However, if that specific field is empty, I want it to calculate off another date. I believe I have written the expression properly, but it doesn not function correctly. Here is my...

I am creating a switchboard to access a few data entry forms and to preview reports before printing. It seems that whenever I add a button to preview a certain form(the 4th button on the form, all others work fine), Access goes crazy. I get several errors, including: "You have entered an...

Thanks for the reply Len, but I would really like this VBA script to be record specific. The data entry will be continuous and will not really have the option of returning to records to change this info, as it would be inputted as the record was inputted.

Ok, when I check the box "true" I want the date field to appear ONLY on that record. The other records should remain invisible unless I check the box "true" on those specific records.

Gotcha. I'm not using a continuous form. Have to navigate at the bottom from record to record. When I mark the checkbox "true" it should open up a field in which I enter a date. It does this. Unfortunately, on the next record, the date box is also there, although the checkbox is "false". If I...

I did a search for visible and found this thread, it worked at first but I have discovered a problem, at least for me. I want this field to be visible/not visible based on a criterion from individual records. When the "Child Removed" checkbox is true I want it to appear on that record only and...

I checked the sample DB section, but could not find what I am looking for: a anonymous customer satisfaction database. Just a shell I can build upon. Does anyone here have anything similar I might be able to use?

BTW, for the N/As I was thinking to make each "true" response to each N/A a -1 and then adding this total to 11(the total number of Qs) and then dividing the "Yes" responses by this number. Plausible? Excuse my ignorance, I've made several DBs to track and search text info, but this is my first...

Thanks for the imput, examples would be great. I was hoping to be able to search the DB by question number and a number of other factor including race, gender, etc. Perhaps I do not need a percentage output from each record, rather an aggregate total for them all that is searchable by the...

Hey guys I'm developing a DB to input satisfaction surveys and compute satisfaction levels expressed as a percentage. I am setting up the DB with 1 record=1 satisfaction survey. The record would contain the fields:Survey Quarter and questions 1,2,3, etc. The responses to the questions are in...