| Thread | Last Post | Replies |
|
| Tow or more options in query | 09 Dec 2006 20:31 GMT | 5 |
In query I have Like [Cod or * for all] in cod column. I would like to be able to choose two or three Cod.
|
| Help with expression not rounding properly | 09 Dec 2006 12:58 GMT | 2 |
Access 2000. I have an expression in my query that 99% of the time will give me the correct result, that is rounds up or down correctly. For example, I am getting a result of .04 when I should be getting .05 The actual number is .045 which should round up to .05 or .005 ...
|
| Long file names to short file names | 09 Dec 2006 07:52 GMT | 2 |
OK, he're's the dilemma. I have two lists of files I've imported. One has the file names/paths in long format that contains the path, name, size, last accessed, etc. The other list has them in DOS format wiht name, path size, last accessed
|
| need help creating date related query | 09 Dec 2006 06:41 GMT | 6 |
I have a table that contain personal information of a number of peoples and the table have a birthdate field which contain data of the date of birth and the time of birth of a person . Now let say my birhdate in the record is (12/2/1989 23:36:50)
|
| alphabetic sort problem | 08 Dec 2006 16:45 GMT | 10 |
I have a query that is supposed to be sorting alphabetically by location. There are items that do not follow the sort sequence, please see below for examples from the query. I would appreciate any advice on where to look to correct this.
|
| Combine Fields | 08 Dec 2006 16:40 GMT | 2 |
I have a table that looks like this: Name Rank Service Mary Smith 30 Case Mgt Mary Smith 1 Brain Injury
|
| Help With Query Please | 08 Dec 2006 16:29 GMT | 6 |
Dear NG, My query is letting 6 records slip through the cracks that should be filtered. What I'm trying to accomplish with the query below is the following:
|
| setting criteria problem | 08 Dec 2006 16:26 GMT | 7 |
Can someone help? I am creating a training database. I have 10 tables - 1 for each set of Work Instructions. One set of instructions has 34 different procedures....the table has a column for employee name and then one for each work instruction number (to enter date training was ...
|
| Data from record source | 08 Dec 2006 15:12 GMT | 2 |
I try to make a report where I need the fields fPersID and fPersName printed, this goes in a textbox no probem. Now I need, in my VBA code, the data from the field fTestField to see what the code should do next. I thought I could get this code like stgX = me![fTestField], this ...
|
| Running queries | 08 Dec 2006 14:56 GMT | 1 |
I want to run my query via a form on which I have created a drop down list. Therefore, I'll have to seperate all of the keywords into seperate entries on the list. E.G: Data
|
| Query problem | 08 Dec 2006 09:11 GMT | 2 |
If I have a field which is in memo format, and contains a lot of text, how do I create a query so that just one particular word is picked out of that text? For example if I had the following text: apple, ball, cat, dog, elephant - how do I get access to include this entry
|
| Create Query based on field names stored in a separate table | 08 Dec 2006 08:57 GMT | 2 |
Hi all, have an odd problem which I thought would be dead easy but has become an afternoon project. I would like to create a Select Query on a table containing numerous fields. I want to to use a separate single record table to 'map' the field names from
|
| Query value between min-max and return another value | 08 Dec 2006 08:56 GMT | 27 |
I am learning access2003 on the fly at my job and am having a real hard time figuring this out. I have tables with an ID column, a MIN column, a MAX column and multiple columns following with values that correspond to the ranges
|
| how do i multiply one column by another column in access 2003? | 08 Dec 2006 07:08 GMT | 1 |
i want to multiply one column by another.
|
| how to create a query that count a few things | 08 Dec 2006 05:09 GMT | 1 |
I have a Member Table and below is it's struture. Field: Name,Sport,Computer,Movie,Music Description: Member's Name
|