Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / March 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
SQL Statement (in Access)20 Mar 2006 20:11 GMT2
SELECT [Name]...
What is Name referring to in the above statement?
Thanks In Advance
20 days from "CallDate"20 Mar 2006 19:11 GMT8
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 counter20 Mar 2006 18:43 GMT10
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 query20 Mar 2006 18:18 GMT3
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 tables20 Mar 2006 18:10 GMT3
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 GMT1
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 query20 Mar 2006 17:35 GMT3
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
security20 Mar 2006 17:27 GMT1
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 queries20 Mar 2006 17:12 GMT1
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 number20 Mar 2006 17:05 GMT1
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 question20 Mar 2006 16:00 GMT2
is there a criteria that i can put in a query
Date() - 1 Years
or
Date() - 2 Years
Query problem20 Mar 2006 14:33 GMT8
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 form20 Mar 2006 09:43 GMT1
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
installation20 Mar 2006 06:52 GMT1
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 queries20 Mar 2006 06:48 GMT1
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 :
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.