| Thread | Last Post | Replies |
|
| Parameter query | 26 Apr 2006 16:48 GMT | 3 |
As normal, I use parameter query to pull out single specific information. Ex. If I enter Sue in Parameter dialog box, it will pull out Sue's information. If I want to pull out two names as once (Sue and Kim), what criteria I
|
| Summing records with a common field | 26 Apr 2006 16:43 GMT | 5 |
I ran a query with the following results: Customer PO Price Handling Freight Tax 111 10 3 2 111 8 2 1 2
|
| Export specification Data Types | 26 Apr 2006 16:04 GMT | 9 |
I have seen posted (by Ken Snell) in several places in this newsgroup, instructions to open an export specification in the wizard and edit the data types for each individual field. I have found that to be impossible. From similar posts, I have surmised that there are supposed to be ...
|
| Number of Payments | 26 Apr 2006 15:22 GMT | 4 |
I am working with a table that contains the payment history for clients over the past 6 months. This table is made up of fields for each of these months with the amounts paid for that month. I need 3 separate queries to return those records of clients who have missed 0, 1, or 2 ...
|
| Complicated Cross tab query for overtime tracking | 26 Apr 2006 15:04 GMT | 2 |
I am trying to set up a cross tab query to track overtime used in a quarter but I must review it weekly for certain employees and it must sort the employee's from the lowest to the highest in overtime useage. Field names are [EmployeeName], [OTdate], [OpportuintiesGiven], and ...
|
| Next Number in series | 26 Apr 2006 14:31 GMT | 1 |
This may be something that is very easy to do, may not be, but either way, it has got me stumped. I am trying to come up with a form/function/query/task/table (whatever you would like to call it), such that from a form, I can enter
|
| Finding Duplicates | 26 Apr 2006 14:21 GMT | 2 |
I have different areas enter names they'd like to be included in a mailing. Sometimes, there are duplicates. I've been trying to create a query that finds them so I can have the creators of the lists decide among themselves who should keep it on their list and get back to me how ...
|
| Need help in DLookup Query | 26 Apr 2006 14:15 GMT | 2 |
Hi, I need help in DLookup function. The following tables and fields are involved Table ==> SYS_INFO ///////Fields ==> SYS_ID (PK), TESTER_NME_ID (FK),BEGIN_DATE, END_DATE
|
| Query issue | 26 Apr 2006 13:40 GMT | 1 |
Below I have a query that I want to return all test types 2 and 3...when I put 2 AND 3 in the criteria, it returns with not data. I do an Or statement and it gets it. The problem with the OR is that the calulation function seperates the two when I want the two to be added in ...
|
| Ordering Crosstab Query | 26 Apr 2006 13:28 GMT | 2 |
By default, my example (and any other), columns are sorted alphabetically. I want the columns to be shown in order that they were found. eg I have a table that lists 20 entries per country and want the column headings to reflect the table.
|
| Query with lookup table | 26 Apr 2006 13:26 GMT | 10 |
I have a table which has a field(column) as a lookup field from the lookup table. I am trying to do a query on that field and for some odd reason it is returning no records, not a null but an error like return. I can see the data in the field, it is there, can someone help me?
|
| Creating Turnover Report based on Query | 26 Apr 2006 07:07 GMT | 7 |
Hi, I am working on a turnover database and I am fairly new to Queries and Reports. I have 3 tables called Employees, Positions, and EmployeePositions. For starters, I am trying to get a report (that will be run monthly) that shows the total number of positions that are marked as ...
|
| how do i send an email/fax to the addresses in certain categories | 26 Apr 2006 06:11 GMT | 1 |
i have categorised my addresses in contacts an would now like to send a fax or email to those certain categories. How do I do that?
|
| Using update query to update phone numbers. | 26 Apr 2006 05:31 GMT | 4 |
As in my last question, I have a table with addresses and phone numbers. Some of the entries are outside my metropolitan area, hence, different area codes. I have already done a query to separate the foreign area codes and now need to do an update query to put a 1 in front of ...
|
| Delete empty record | 26 Apr 2006 05:19 GMT | 4 |
I want to delete a record in a table that has no data. I have tried Like "" in my query but that does not work. Please assist. Thanks
|