| Thread | Last Post | Replies |
|
| "Access" | 09 May 2007 17:23 GMT | 1 |
Is "Access" a stand alone product or part of a larger program?
|
| Help with complex query | 09 May 2007 17:10 GMT | 1 |
I've got a query that I'm not sure how to develop. My tables: Quotes - QuoteNo, RaisedBy, Customer QuoteItems - RecordID, QuoteNo, PartNo, Lifecycle, Value
|
| Partial | 09 May 2007 17:08 GMT | 2 |
In a query, I have under criteria [Enter the country: Example USA] for a field of countries. (I found from sample query) How do I get it to list countrys starting with "U" by just putting U in?
|
| Only Null | 09 May 2007 17:06 GMT | 2 |
I need to limit this output to only records without a close date (TR_CLOSEDATE) Any suggestions??? SELECT tblTrackingData.TR_GRIEVANCECOORDINATOR, tblTrackingData.ICNNO, tblTrackingData.TR_GBU, tblTrackingData.TR_DATE_TIMERCVD_HOI,
|
| Add a row to a query result. | 09 May 2007 17:01 GMT | 4 |
I have a query that I am using to return a list of jobs to be used as the data source of a combo box in a local vb.net application. job: job_id, job_num, other insignificant columns
|
| Problem counting | 09 May 2007 16:42 GMT | 5 |
I have a table called [locums sessions] which includes the fields 'locdate' and 'locname' and key (autonumber) field 'locserial'. 'locname' is the name of a locum doctor, and 'locdate' is the date on which that doctor worked a session.
|
| Query Help | 09 May 2007 16:41 GMT | 1 |
I have a Query with 5 Tables in it. tblRestInfo tblVoids tblItems
|
| Minus today | 09 May 2007 16:41 GMT | 2 |
I just want to count the number of days since a record was received.. Could anyone please help me plug in todays date. This is an example of wht I tried, everything except the last -[Date()] works fine?
|
| Data in a column moved to same Row as related data | 09 May 2007 15:05 GMT | 5 |
I have a table with one column that has data separate from the rest of the table. I need to move it to the same row as the other columns when the information matches. Example:
|
| Average | 09 May 2007 14:29 GMT | 1 |
I'm able to run the number of employees by Month and Division Year Division Month Actual Count 2006 Accounting January 325 2006 Accounting February 326
|
| Access 2003 | 09 May 2007 14:26 GMT | 3 |
I'm trying to run a multiple parameter query to search 1 field and bring up 3 search results. The field is text and it looks like this: 024-001-006 I would like it to bring up approximately 3 different results but pull only
|
| Queries and data protection | 09 May 2007 13:59 GMT | 3 |
I created a query and I would like to know how I can protect certain displayed data fields within that query from update. I retrieve names from my database and my query will allow others to change the names. Some fields I want them to be able to change, others not. How do I ...
|
| query problem | 09 May 2007 13:22 GMT | 2 |
I have two tables. One for employees Info, the other one for employees completed tasks. In employee’s info table, employee ID is primary key while in employee completed tasks table the employee ID is foreign key. Moreover, in the
|
| now function | 09 May 2007 10:34 GMT | 1 |
Hello, I want to know how many people on the access data aren’t old enough to vote? The age requirement is 21. I want to be able to list it up by using the "NOW" function in query mode, but wasn't sure what I have to put in the criteria to get that information out. My date ...
|
| Query problem | 09 May 2007 08:01 GMT | 2 |
I have two table for employees Table 1 for all employees(ID# , Name) Table 2 for employees who made the survey(ID# , name) What I want to do is showing the employees who do not make the survey
|