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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
I HAVE MESSED UP A FONT11 Aug 2006 13:01 GMT1
I uploaded some font packs and somehow it has messed up all my incoming
emails that have the ARIAL font and replaced it with a unknown new -
illegible graffiti font... I have been to the font library and enabled and
disable fonts and sections but it's still doin it ...PLEASE HELP ...
Criteria11 Aug 2006 11:57 GMT2
I've got a query that asks you for a specific date and returns details on
that date: [What Date?] in the 'Criteria' field
What I'd like to do is return details between two certain dates. In other
words, in the 'Criteria' field return between [Start Date?] and [End Date?],
Counting in several fields11 Aug 2006 05:31 GMT5
Suppose I have a table with some fields containing the codes (integer
numbers) of some products (brands) and another table
containing the products together with their codes, just like this:
ID    PRODUCT NAME
How do I set up query to look for parameters in a form?11 Aug 2006 05:30 GMT1
I have followed the tutorial posted by Sal Ricciardi (Using parameters with
queries and reports). The form (dialog box) with combo boxes and command
buttons works great until I try to set the query to look for the parameters
in the form. In design view, I add the following in the ...
How to do Time Calculations in Access11 Aug 2006 05:18 GMT1
I am working on a database for tracking billable hours. In the database I
have a table set up that employees enter their daily time. I have two fields
TimeStarted - Medium Time Format - Input Mask 09:00\ >LL;0;_. This is the
same for both and TimeFinished. I am then creating a ...
Two columns as one11 Aug 2006 05:16 GMT1
I have some records where one column is a part, the other is the
problem with the part. One part can have different problems, but all
the parts are defective.  I need to do a query of the top ten defects.
Could I have some advice on how to query the top ten defects?
45 Days between multiple occurrences.  My brain may explode!  (help)11 Aug 2006 05:11 GMT2
Hi everyone.  I really thought I was getting a handle on all this till
this evening. Now I am worried that my brain is going to explode.
My db has two kinds of customer services, I'll loosely define them as
Type_A and Type_B.  I have a list telling me which service category id
Pivot a row header11 Aug 2006 03:07 GMT1
I have a scheduling system that has a union query to join the open
service calls between 2 departments.  On any given Dat , some techs
have 3 stops, some have 7.  Right now with my demo code, it shows the
following:
Function with two recordsets11 Aug 2006 01:48 GMT6
The following is a sub function of the functions used in our research
db.  Am encountering an error in my second recordset - called
MARKSTRING.
COUNTSTRING seems to work fine on its own but once markstring is added
How do I sum colums in Access Query11 Aug 2006 01:47 GMT1
I'm trying to sum each column but it doesn't do it by hitting the "sum"
button.  However, in the headings of each of the columns, it puts SUM OF,
disrupting my existing column headings.  Any suggestions?
Compare two fields, find near match10 Aug 2006 23:45 GMT12
I am trying to compare the information in one field to the information in
another (basically an automated find/replace, one table to another):
Field1                   Field2 (Replace With)
belmont park n   | Belmonte Park N
"Enter Parameter Value" when sorting10 Aug 2006 22:28 GMT4
I'm a bit of an access newbie, so sorry if this question is a bit daft
but I couldn't find the answer in any FAQs.
When I have a query like this:
SELECT [fdTestThis] AS fdSortThis, tbMyTable.fdMonth AS fdTestThis
Parsing memo field into texy fields10 Aug 2006 22:00 GMT7
I need to separate the text in a memo field by the psuedo field headings (not
my design)
A portion of the memo field looks like this
Date(mm/dd/yy):
Cross tab on query results error -103810 Aug 2006 21:51 GMT2
I'm having trouble with a crosstab query which I need to transpose to the
results of my initial query.
This is an example of my initial queries result
Key           FieldName              Psuedo                                  
Using an Access form to enter parameters for a Query10 Aug 2006 21:42 GMT1
I have a query with 4 parameters that feed a report.  I have made a form with
combo boxes with the criteria for each of the parameters and have it set to
open when the report is opened.  When the criteria is set for the parameters
and the enter button is hit the criteria doesn't ...
 
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.