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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Parameter query26 Apr 2006 16:48 GMT3
As normal, I use parameter query to pull out  single specific information.
Ex. If I enter Sue in Parameter dialog box, it will pull out Sue's
information.
If I want to pull out two names as once (Sue and Kim), what criteria I
Summing records with a common field26 Apr 2006 16:43 GMT5
I ran a query with the following results:
Customer PO      Price    Handling   Freight     Tax
111                   10            3             2            
111                   8              2             1           2
Export specification Data Types26 Apr 2006 16:04 GMT9
I have seen posted (by Ken Snell) in several places in this newsgroup,
instructions to open an export specification in the wizard and edit the data
types for each individual field. I have found that to be impossible. From
similar posts, I have surmised that there are supposed to be ...
Number of Payments26 Apr 2006 15:22 GMT4
I am working with a table that contains the payment history for clients over
the past 6 months. This table is made up of fields for each of these months
with the amounts paid for that month. I need 3 separate queries to return
those records of clients who have missed 0, 1, or 2 ...
Complicated Cross tab query for overtime tracking26 Apr 2006 15:04 GMT2
I am trying to set up a cross tab query to track overtime used in a quarter
but I must review it weekly for certain employees and it must sort the
employee's from the lowest to the highest in overtime useage.  Field names
are [EmployeeName], [OTdate], [OpportuintiesGiven], and ...
Next Number in series26 Apr 2006 14:31 GMT1
This may be something that is very easy to do, may not be, but either
way, it has got me stumped.
I am trying to come up with a form/function/query/task/table (whatever
you would like to call it), such that from a form, I can enter
Finding Duplicates26 Apr 2006 14:21 GMT2
I have different areas enter names they'd like to be included in a mailing.
Sometimes, there are duplicates.  I've been trying to create a query that
finds them so I can have the creators of the lists decide among themselves
who should keep it on their list and get back to me how ...
Need help in DLookup Query26 Apr 2006 14:15 GMT2
Hi, I need  help in DLookup function. The following tables and fields
are involved
Table ==> SYS_INFO
///////Fields ==> SYS_ID (PK), TESTER_NME_ID (FK),BEGIN_DATE, END_DATE
Query issue26 Apr 2006 13:40 GMT1
Below I have  a query that I want to return all test types 2 and 3...when I
put 2 AND 3 in the criteria, it returns with not data.  I do an Or statement
and it gets it.  The problem with the OR is that the calulation function
seperates the two when I want the two to be added in ...
Ordering Crosstab Query26 Apr 2006 13:28 GMT2
By default, my example (and any other), columns are sorted alphabetically. I
want the columns to be shown in order that they were found. eg I have a table
that lists 20 entries per country and want the column headings to reflect the
table.
Query with lookup table26 Apr 2006 13:26 GMT10
I have a table which has a field(column) as a lookup field from the lookup
table.  I am trying to do a query on that field and for some odd reason it is
returning no records, not a null but an error like return.  I can see the
data in the field, it is there, can someone help me?
Creating Turnover Report based on Query26 Apr 2006 07:07 GMT7
Hi, I am working on a turnover database and I am fairly new to Queries and
Reports. I have 3 tables called Employees, Positions, and EmployeePositions.
For starters, I am trying to get a report (that will be run monthly) that
shows the total number of positions that are marked as ...
how do i send an email/fax to the addresses in certain categories26 Apr 2006 06:11 GMT1
i have categorised my addresses in contacts an would now like to send a fax
or email to those certain categories.  How do I do that?
Using update query to update phone numbers.26 Apr 2006 05:31 GMT4
As in my last question, I have a table with addresses and phone numbers.  
Some of the entries are outside my metropolitan area, hence, different area
codes.  I have already done a query to separate the foreign area codes and
now need to do an update query to put a 1 in front of ...
Delete empty record26 Apr 2006 05:19 GMT4
I want to delete a record in a table that has no data.
I have tried Like "" in my query but that does not work.
Please assist.
Thanks
 
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.