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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How do I get a spreadsheet to print fullsize?15 Nov 2006 17:48 GMT1
When I print a works spreadsheet it downsizes the document instead of
printing it full size on my paper.  What do I do to get it tio print full
size?
Truncate phone extension15 Nov 2006 17:43 GMT7
I run a query for exporting purposes.  I do NOT wish to alter my existing
table.
That said, how do I truncate the "ext: ..." from the query results?
As usual, help is greatly appreciated.
Take out SumOFMyFieldName from Query15 Nov 2006 17:31 GMT3
I have a few queries I am exporting to Excel. Is there a way I can automate
or perminatly change the the field name to only show the field name and not
the SUMOF portion that is at the beginning of my calculated fields? If so how
would I go about this?
add records to a table from a recordset15 Nov 2006 17:12 GMT1
i am creating a recordset in code that I want to dump into a table so I can
pull from it in a query.  is this possible?  how?  
here is the code i have to create the recordset...
Set qd = con.CreateQueryDef("", sql8)
Pass one parameter date?15 Nov 2006 15:59 GMT4
I am exporting two reports from one button on my form. I have two queries
running 2 seprate reports. How do I go about passing the parameter to the
other report? In other words I want the user to type in the first and second
date only once to open the report, not twice. This ...
Searching Data Base15 Nov 2006 15:43 GMT2
I have Access DB, I have tables, one of the tables is cust_details.
The table has fields like: cust_id
                                   cust_name
                                   cust_address
Query in Multiple Fields15 Nov 2006 15:13 GMT1
I have two tables with mostly the same fields.  Specifically, they both
contain a field called "Author."  I would like to design a query that allows
me to search in both "Author" fields, while only having to use one
parameter/search term, and so the resulting table contains the ...
Calculating Material Usage15 Nov 2006 14:56 GMT7
I need to summarise the amount of inventory used over a specified period, I
have a query that gathers this data but I need to calculate totals for each
inventory item not the summary used in each BOM. The problem is that each
inventory item is used in many Bill of Materials and ...
adding product qty fields from multiple records to transaction record15 Nov 2006 14:49 GMT3
I need to take a field value from multiple records in one table and
append those values to the end of an associated single record in
another table.  (Or, create a third table.)  I am an Access newbie --
having gotten by fine with Excel until now.  I have Access 2000.  
Query to combine records based on matching criteria. PLEASE help.15 Nov 2006 14:12 GMT10
Hello all, I'm new to access and having some difficulities. Any help I could
get I would really appricate.
I have two tables from which im trying to combine records.
I have 4 fields in each table.
Query or Form for criteria between . . .15 Nov 2006 13:16 GMT2
I need to I need to set up a mailing list with criteria such as: 541101 -
541105. Is it possible to do this? I've been working on this for a while!
If it is not possible I'll have to filter each criteria # individually and I
have many.
Select Query15 Nov 2006 13:15 GMT3
I am new at the use of access. I am using Access 2000 on a Windows 2000
system.
My question is (if possible). Select records with the greatest date field.
Example:
Concatenate text15 Nov 2006 12:55 GMT3
Here are my fields.
[Figured]  This field is sometimes blank.
[Cut]
[Veneer]
Consumption during time window15 Nov 2006 12:32 GMT3
As part of a safety stock - reorder point analysis, I want to compute the
historical consumption during specified time windows. As a start point, I
have a list of all net consumptions per day (Material|Plant|Date|Consumption).
Till now, I used a not-so-quick-but-dirty method by ...
Change field type from VB15 Nov 2006 11:00 GMT2
I have an Access database with a table containing a decimal field wich has
these properties:
precision: 18
scale: 5
 
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.