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 / December 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Tow or more options in query09 Dec 2006 20:31 GMT5
In query I have
Like [Cod or * for all]
in cod column.
I would like to be able to choose two or three Cod.
Help with expression not rounding properly09 Dec 2006 12:58 GMT2
Access 2000.  I have an expression in my query that 99% of the time will
give me the correct result, that is rounds up or down correctly.  For
example, I am getting a result of .04 when I should be getting .05  The
actual number is .045 which should round up to .05  or .005 ...
Long file names to short file names09 Dec 2006 07:52 GMT2
OK, he're's the dilemma.
I have two lists of files I've imported.  One has the file names/paths in
long format that contains the path, name, size, last accessed, etc.
The other list has them in DOS format wiht name, path size, last accessed
need help creating date related query09 Dec 2006 06:41 GMT6
I have a table that contain personal information of a number of peoples and
the table have a birthdate field which contain data of the date of birth and
the time of birth of a person . Now let say my birhdate in the record is
(12/2/1989 23:36:50)
alphabetic sort problem08 Dec 2006 16:45 GMT10
I have a query that is supposed to be sorting alphabetically by location.
There are items that do not follow the sort sequence, please see below for
examples from the query.  I would appreciate any advice on where to look to
correct this.
Combine Fields08 Dec 2006 16:40 GMT2
I have a table that looks like this:
Name                           Rank                       Service
Mary Smith                   30                           Case Mgt
Mary Smith                    1                            Brain Injury
Help With Query Please08 Dec 2006 16:29 GMT6
Dear NG,
My query is letting 6 records slip through the cracks that should be
filtered.  What I'm trying to accomplish with the query below is the
following:
setting criteria problem08 Dec 2006 16:26 GMT7
Can someone help?  I am creating a training database.  I have 10 tables - 1
for each set of Work Instructions.  One set of instructions has 34 different
procedures....the table has a column for employee name and then one for each
work instruction number (to enter date training was ...
Data from record source08 Dec 2006 15:12 GMT2
I try to make a report where I need the fields fPersID and fPersName
printed, this goes in a textbox no probem. Now I need, in my VBA code, the
data from the field fTestField to see what the code should do next. I
thought I could get this code like stgX = me![fTestField], this ...
Running queries08 Dec 2006 14:56 GMT1
I want to run my query via a form on which I have created a drop down list.  
Therefore, I'll have to seperate all of the keywords into seperate entries on
the list.  E.G:
Data
Query problem08 Dec 2006 09:11 GMT2
If I have a field which is in memo format, and contains a lot of text, how do
I create a query so that just one particular word is picked out of that text?
For example if I had the following text:
apple, ball, cat, dog, elephant - how do I get access to include this entry
Create Query based on field names stored in a separate table08 Dec 2006 08:57 GMT2
Hi all, have an odd problem which I thought would be dead easy but has become
an afternoon project.
I would like to create a Select Query on a table containing numerous fields.
I want to to use a separate single record table to 'map' the field names from
Query value between min-max and return another value08 Dec 2006 08:56 GMT27
I am learning access2003 on the fly at my job and am having a real hard
time figuring this out.
I have tables with an ID column, a MIN column, a MAX column and
multiple columns following with values that correspond to the ranges
how do i multiply one column by another column in access 2003?08 Dec 2006 07:08 GMT1
i want to multiply one column by another.
how to create a query that count a few things08 Dec 2006 05:09 GMT1
I have a Member Table and below is it's struture.
Field: Name,Sport,Computer,Movie,Music
Description:
Member's Name
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 November, 2006
 
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.