| Thread | Last Post | Replies |
|
| Running a query on items selected from a list box. | 11 Oct 2007 03:45 GMT | 4 |
I am trying to create a query that will only show the values for names selected in a list. I have a form that has a list box that shows all of the team members. In the database there is a table that contains all of the stat information for each
|
| Use field for selection but NOT group by? | 11 Oct 2007 03:39 GMT | 1 |
I have a data table. Right now there are four pertinent fields. PPE Date Function Task
|
| Button Parameter Query | 11 Oct 2007 03:34 GMT | 1 |
I am a COMPLETE NOVICE struggling with designing a database... Have Mercy! I need my user to be able to select from a drop down list of queries from which the user can then further choose a a single or combination of 7 regions as the final criteria.
|
| Balance Comparison Query | 11 Oct 2007 03:09 GMT | 2 |
I need some help with this query/report. My query does a comparison between records in current month and records in previous month. It basically takes active account numbers and balances for current month and compares it to active accounts and balances from previous month. I ...
|
| #Error - possible Reference Library omission? | 11 Oct 2007 02:20 GMT | 1 |
I'm comparing MyGroup with the few in RtrnNotice to identify who (in MyGroup) still needs to "return Notice" I've tried the below several ways but if there is a match I'm fine (VarType 8) when there isn't a match (that's who I'm looking for) I get #Error
|
| Creating a Query in code. | 11 Oct 2007 01:35 GMT | 1 |
I am attempting to create a query using vb code. I have the function created that correctly creates the sql text but I don't know how to create a query using that sql text. I have seen other examples of code to do this but they all use Dim db as
|
| "Invalid scale" error during Crosstab | 10 Oct 2007 23:22 GMT | 2 |
I received the error "Invalid scale for decimal data type" while trying to execute this crosstab query (created with crosstab wizard) TRANSFORM Sum(INV_ages.Acres) AS SumOfAcres SELECT INV_ages.period, Sum(INV_ages.Acres) AS [Total Of Acres]
|
| Make Table Query | 10 Oct 2007 22:17 GMT | 1 |
I am currently using a Make Table query for the below - but I was hoping there is an easier way. I have to download a report from our Central office which is in another an excel file. (wp.xls) I then put this data into Access to run reports, etc on
|
| How to exclude certain records | 10 Oct 2007 20:43 GMT | 7 |
How can I create a query to exclude records containing certain words like the word "accept". If I have multiple fields containing this word "accept" and "fail" how can I exclude all records with these words from each field? I have 3000 records with 5 fields that have this word in ...
|
| Grouped query - last function , how is working ? | 10 Oct 2007 20:19 GMT | 2 |
Please help , I have the next table with recording sequence Id date Info a 2007.09.01. a first
|
| New column on redundant field | 10 Oct 2007 19:47 GMT | 2 |
This is oversimplified, but I need to export records from a 3 column table in this format: EmpName|WorkHours|WorkDate DoeJohn|7.0|6/1/2007
|
| Query question | 10 Oct 2007 17:05 GMT | 4 |
I have tried and tried to figure this out and have not. If I have 10 fields in a query (all numbers, not text) and I want an 11th field to return the highest row value in that row (inother words, I have 159,134,190,167,122,189,201,182,174,140 as the values in one row) and I want ...
|
| Update Query and record lock violations | 10 Oct 2007 17:04 GMT | 6 |
I have a local table constructed from two remote sqltables. I add records successfully via an append query in Access 2003. I am attempting to modify date records that have changed in the remote table to the local table (they change occasionally in the sqltable) via update query ...
|
| 3 conditions in a select query thats populating a newly created fi | 10 Oct 2007 16:52 GMT | 2 |
I would like to build a query that populates the value of a datafield as either "HIGH", "Med", or "low" depending on the value of a different numeric field on the table being queried. I'd like the medium-to-high threshold set at 10 (lets just say), and the medium-to-low ...
|
| Does an Update query do this? | 10 Oct 2007 16:13 GMT | 1 |
I have a proprietary database of customers that I need to specify which time zone they are all in. BACKGROUND: I have a Company table, with their address in it, and I have an
|