Search results for query: *

Hey, You certainly deserve a star my friend for the time you have spent in responding and helping me understand the code. You must have teaching backgd for sure :-) While i was awaiting your response I tried the [] thingie. I created a simple query, took all relevant fields and took the sql...

Addendum... I tried the code and it says too many fields defined. All i want is to have a dataset which has all regions information, without having to merge it every single time.. Area office records keep changing , meaning status , so i wld like to merge/append the files.. Pat from Region1...

Hi there, Sorry for bothering u. I appreciate the time you are spending in helping me and am grateful for that. When u say SELECT "Ottawa" AS [Location], what exactly do u mean. Do i have to create my select statement with SELECT "Ottawa" AS [Location], or is it just plain SELECT P1.*...

Hi there, Thks for ur prompt response. I reposted it because for some sick reason I thought I had posted it in the crystal reports forum, hence the dbl post. I tried the union code with both tables in the same datbase and it did not work yesterday. I will try it from the different locations as...

Hi there, Can one of you experts pls help me. I have 4 Access 2003 databases used by 4 different area offices. They are identical databases except that each area office has to be kept separate for confidentiality reasons. The databases have several tables but one main TABLE named PAT is the...

Hi there, Can one of you experts pls help me. I have 4 Access 2003 databases used by 4 different area offices. They are identical databases except that each area office has to be kept separate for confidentiality reasons. The databases have several tables but one main TABLE named PAT is the...

Hi there, I am using CR 11. I figured out how to use recordnumber in a report. I am not able to figure out how to reset the recordnumber at change of a group. For ex: If i have 200 records in report, the numbering is from 1 - 200 across all 4 regions. my first region could break at 20 or...

Hi there, Does CR XI have the Mean function. If it is not available, can someone help me on how to do that calc.. the data after calculating the age at referral is this.. can anyone tell me how to get the Mean. I am not a statistics avay person. thks in advance is # of clients: 71 Minimun 12...