| Thread | Last Post | Replies |
|
| SQL Statement (in Access) | 20 Mar 2006 20:11 GMT | 2 |
SELECT [Name]... What is Name referring to in the above statement? Thanks In Advance
|
| 20 days from "CallDate" | 20 Mar 2006 19:11 GMT | 8 |
I have a date field in my query called "CallDate". I need the query to give me records that are 20 days after the "CallDate". How can I do that?
 Signature DHLively
|
| record counter | 20 Mar 2006 18:43 GMT | 10 |
am particularly dim this morning..... have simple table with field that is a Ref that varies: Ref 1
|
| Help selecting an additional field in my query | 20 Mar 2006 18:18 GMT | 3 |
So far I the following aggreate query. In addition to what is below I have a date field for which should select the date that corresponds to the record with the Min(tbl_ASX_Data.Close). The field is called IMPORTDATE and is in the same
|
| count from multiple tables | 20 Mar 2006 18:10 GMT | 3 |
Im creating a query for my chart to lookup a count of records from 3 different tables using the Driver ID field. I have got the following code but it comes up with the following error 'You tried to execute a query that does not include the specified expression 'Driver ID' as
|
| pulling random record (when running query?) | 20 Mar 2006 18:09 GMT | 1 |
I have a table with the names of approx 3500 records. I want to have a query pull a random record from this table table: PowerTabDirectory Field: Item (this is a autonumber)
|
| change to UPDATE query | 20 Mar 2006 17:35 GMT | 3 |
I have the following query: SELECT Tbl_archive.[Loan Acct #], Tbl_archive.status AS thurs_status, DLookUp("[status]","tbl_archive","[PopEnterDt] = #" & Date()-2 & "# AND [loan acct #] = " & [loan acct #]) AS wed_status, IIf([wed_status]<>"chargeoff" And
|
| security | 20 Mar 2006 17:27 GMT | 1 |
i have made a small database for my logbook. i am being asked by my colleagues that i should give them the file as they see it to be helpful. now the problem is that when i use "user level security wizard" and create a user with limited privilages and place it in say
|
| Updating criteria in queries | 20 Mar 2006 17:12 GMT | 1 |
I have several queries that pull different records, but often times based on the same time frame, like the month of January, or last week. Is there a way I can update the criteria in several queries with a macro or code.
|
| Calculate a number using a specified date and another number | 20 Mar 2006 17:05 GMT | 1 |
Trying to make a date value trigger a set number (11) to be added to another number on the first day of each month.
|
| date field question | 20 Mar 2006 16:00 GMT | 2 |
is there a criteria that i can put in a query Date() - 1 Years or Date() - 2 Years
|
| Query problem | 20 Mar 2006 14:33 GMT | 8 |
Thanks in advance for any help with this query. I'm getting syntax errors and "too many arguments" errors. What I'm trying to do is count the number of trucks only if the TotalLoss is above $0.00:
|
| How to create and/or combination queries to display in a form | 20 Mar 2006 09:43 GMT | 1 |
User needs to be able to sort from any single combo box or any combination of all 4 boxes The results are displayed in a list box I have been able to get results where the records have all combinations but
|
| installation | 20 Mar 2006 06:52 GMT | 1 |
why I can't install office xp service pack 3 ? -- dmdrnhfsigw6ishnnj;faewopmvc,c,ufsssssssddfbbbjmuuk,,k,hbmjfgbhjhdfklgopywopttjhjgmgdmfmb;vgfm;fheey][tpwrtprgjt,gewlfe''rlryo6ypkq[pl5yp[q[rmgthjy6otr34qw;ef,rg,gmdmf'';g;m;afmfmgtlllflgkl;,ftk4o4op3
|
| Removing duplicate entires from multiple queries | 20 Mar 2006 06:48 GMT | 1 |
Question, I have a query that's pulling info back from other queries that seperate out overdue names for classes they need. The query looks like this :
|