| Thread | Last Post | Replies |
|
| Form Questions | 13 May 2008 15:50 GMT | 1 |
I have a problem that I hope can be fixed by one of two solutions. On a Form, I have a "Keywords" field for labeling items being entered into a database. Some items have over 10 keywords. Is there a way to create a ComboBox that will show a list of possible keywords where many of ...
|
| Query to Update Multiple Records Based on Current Record | 13 May 2008 15:37 GMT | 1 |
I am trying to figure out how to allow a user to update many other records based on data that was just entered on the current record. Here is the scenario... We're tracking charges entered against patient accounts. Each patient has a
|
| Criteria | 13 May 2008 15:26 GMT | 3 |
i want to be able to pull up info from a certian company. Haw do i code it to search for this company. My previous criteria wsa [Company Name] which meant that you had to spell the name exactly as it is written is ther a way so that i am able to enter just the first few letters ...
|
| Syntax error in insertinto statement | 13 May 2008 13:48 GMT | 3 |
Hai,to every one here is my question I have designed the coding to collect the feedback report from the user, which includes Name of the user, staffno and comments.But when I click on
|
| Passing Function values to a Query | 13 May 2008 12:53 GMT | 6 |
Hi. I think this may be impossible but I will ask anyway! I have created a function that evaluates 2 values from fields in a query. The function passes a string back made up of 2 parts. E.g. ABCDE - 4a The ABCDE is a matched part of the 2 values and the 4a is how they were
|
| Help with query | 13 May 2008 12:39 GMT | 2 |
I have the following: SELECT [2-2-3-e Result Set].Communes, [2-2-3-e Result Set].[FY 07], [2-2-3-e Result Set].[FY 08], (nz([FY 08])-nz([FY 07]))/(nz([FY 07])+nz([FY 08])) AS Percentage
|
| Conditionally Update field in table with data from another table | 13 May 2008 12:13 GMT | 2 |
I am trying to create an update query that when the AcctNo in G1Table = the AcctNo in FacilityTable (which here it is the primary key), then I want the County ID and the Region number from the FacilityTable to populate the corresponding fields County_ID and RegionNo in the ...
|
| Set up mask on parameter value | 13 May 2008 09:03 GMT | 3 |
I have a query when you run it then it will pop up a little screen asking to enter begining date and ending date. I was wondering if I can set a mask on the parameter value so that I do not have to remember what is the date format. I was able to set the mask on the table but the ...
|
| Delete Query wont work | 13 May 2008 04:41 GMT | 3 |
I have a table with some duplicate records I want to delete automatically. I found this on line help lin http://office.microsoft.com/en-us/access/HA010345581033.aspx?pid=CH010713951033#13 and tried to follow the instructions. Worked OK until I got to the final
|
| how to calculate the number of person | 13 May 2008 02:30 GMT | 5 |
I want to ask how to calculate the number of patient based on the time. Time of seeing doctor - Time of registration=waiting time No of patient waiting less than 90 min.
|
| Splitting Out a listing tables | 12 May 2008 22:22 GMT | 5 |
I am trying to work out how I can take a table of data that lists AddressID, LetterNumber & LetterDate in that form to this way AddressID Letter1 Letter1Date AddressID Letter2 Letter2Date AddressID Letter3 Letter3Date
|
| Avg query | 12 May 2008 21:07 GMT | 5 |
I think I must be doing something wrong. I'm trying to get an average of 5 fields in a query using the following: Total Average Age: Avg([averageageClassI]+[averageageClassII]+[averageageClassII-a]+[averageageClassIII]+[averageageClassIV])
|
| Rakamları yazıya çevirme access 2003 de | 12 May 2008 20:39 GMT | 1 |
Access 2003'de rakamlar nasıl yazıyaçevrilir bunla ilgili herhangi bir modül gönderirseniz sevinirim. Ayrıca burda hiç türkçe soru ve cevap yok umarım access'le ilgilenen gruplar burda yazışırlar. Türkçe gruplar çoğalır.
|
| Delete Query One to Many | 12 May 2008 20:14 GMT | 1 |
I have 2 tables - partial order and backorder file1. I want to remove all order numbers on the partial order table from the backorder file1 table. I looked at the SQL view and this is what I have DELETE Back_order_file1.*, [Partial Back order].[Order Number]
|
| how do i? | 12 May 2008 17:39 GMT | 7 |
Questions on an access data base: I have two tables in a data base Employee daily ins/outs (time clock) Employee master file
|