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 / May 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
"Access"09 May 2007 17:23 GMT1
Is "Access" a stand alone product or part of a larger program?
Help with complex query09 May 2007 17:10 GMT1
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
Partial09 May 2007 17:08 GMT2
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 Null09 May 2007 17:06 GMT2
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 GMT4
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 counting09 May 2007 16:42 GMT5
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 Help09 May 2007 16:41 GMT1
I have a Query with 5 Tables in it.
tblRestInfo
tblVoids
tblItems
Minus today09 May 2007 16:41 GMT2
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 data09 May 2007 15:05 GMT5
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:  
Average09 May 2007 14:29 GMT1
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 200309 May 2007 14:26 GMT3
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 protection09 May 2007 13:59 GMT3
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 problem09 May 2007 13:22 GMT2
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 function09 May 2007 10:34 GMT1
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 problem09 May 2007 08:01 GMT2
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
 
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.