Search results
-
K
Filter on Report
Do you mean for just one Report? I would just have a seperate Query for the reports you want to filter and a template Query for all of your other Reports that you do NOT want the filter. -
K
Group By first 3 digits of 6
Using the Sort By: MAX elimanites those records and i lose the information that is stored there. I worked around it just by removing the Patient Name and using a group by Account ID. -
K
Group By first 3 digits of 6
Another Query question, but a little different. We recently recieved a data dump from an outside vendor and there are two fields that are always related to each other: Account_ID AND Patient Name It seems that Account_ID is always filled in, however, there are times when there is no... -
K
Group By first 3 digits of 6
Thanks for all of your help! I got it working just fine now thanks again ^_^. -
K
Group By first 3 digits of 6
Hey all, I am trying to put together a query that takes a field that has 6 digits and Group By the first 3 digits. This information is then displayed in a Form. Ex. Dept ID: 500104 Balance: 20 Dept ID: 500108 Balance: 30 Dept ID: 500204 Balance: 50 Dept ID: 515221 Balance: 20 Group... -
K
Security issue, no logon
Okay, I am using Access 2000 for starters and I used the User-level security (AND REGETING IT!) but taking the steps to try and remove it, i lost my permissions to change the security features at all and being fully locked out of all my secured databases. I gave the user group permission to...