|
|
date confusion by
UGAJohn
I would like to run a query to determine if a datetime field in table1 falls
between start date and end date in table2. If so I would then like to
assign...
|
February 2nd, 2010 07:17 PM
by cm 
|
2 |
103 |
|
|
|
Why I get "Type Mismatch" by
Kostas
Why I get "Type mismatch" with this code (VBA)
The 'sale_Date' field is date/time field
-----------------
Dim strSQL as String
Dim dbs As Database
Dim...
|
|
1 |
102 |
|
|
|
Criteria by
Steven
I need help with this criteria statement of a query where
I am saying if Field Combo01 is Null then give me all
records but if Combo01 has a value then query...
|
|
1 |
102 |
|
|
|
active x error by
Kim
I am receiving active x control errors in when trying to create a query.
|
|
1 |
102 |
|
|
|
IF function in Microsoft Query? by
DES_Optima
I am attempting to pull data from SQL database into Excel using Microsoft
Query. Field_1 has either a "C" or "D" in it. Based up content I need to
either add...
|
|
1 |
102 |
|
|
|
Complex Query...Maybe by
Access Lover
Hi all,
I have a chain of linked tables in one to many relationship as such:
Customers Table is the main table with these tables linked to it:
1. Payments
2....
|
October 31st, 2004 09:01 AM
by Brian
|
1 |
102 |
|
|
|
Batching records by
Gettingthere
HI all,
I have a table called transaction, with theses columns; Inv_Nr, Cash, CC,
Chq. Where the payment for the invoice is put under the appropriate...
|
|
1 |
102 |
|
|
|
self join query in access by
Shahzad
dear respected gurus,
I would like to knew how to apply append,insert query for a self table
where no primary keys issues.
i do have problem say there are 5...
|
|
4 |
102 |
|
|
|
Filter By Selection by
Kenny G
Hello,
I have a Continuous Form with a record source as a query, "qMainContinuous".
The idea behind the form is to constantly filter by selection until all...
|
December 7th, 2004 04:37 PM
by Kenny G
|
4 |
102 |
|
|
|
Create Aggregate function by
Pross
I am working on a project where I have to calculate the geometric mean of a
set of values from an Access table. I know that it is possible to create my
own...
|
|
5 |
102 |
|
|
|
Select Top 20 by
Scott Reynolds
Hello!
Could someone please tell me why this query does not show top 20 Products
ordered by Hits?
SELECT TOP 20 Id, ProductName, Hits
FROM Products
ORDER BY...
|
|
5 |
102 |
|
|
|
calculating in query by
hermie
I have a table with soccer results and want to calculate th e points of the
won lost or equal gamein a query.
Example: result portugal - holland 2-0 gives 3...
|
July 6th, 2004 07:00 PM
by hermie
|
2 |
102 |
|
|
|
save a query as a table by
JR
Is there some method that will allow me to save an
existing query as a table?
Thanks,
JR
|
July 12th, 2004 04:07 PM
by
|
1 |
102 |
|
|
|
Add leading zero by
Jay
Location_Num Machine Number
06 DUD006
07 DUD007
07_1 DUD07_1
08 DUD008
09 ...
|
|
1 |
102 |
|
|
|
|
|
1 |
102 |
|
|
|
Pull Fields From Multiple Tables by
WDP
Hi:
I have "inherited" an Access Database that has several hundred tables. I don't know why it was setup this way...but it had to be a beginner that did it. ...
|
|
1 |
102 |
|
|
|
Too many fields defined??? by
MChrist
I have some very lengthy and complex queries I am running that has about 45 columns in it, and once I'm done with the subqueries, I am using a UNION ALL...
|
|
1 |
102 |
|
|
|
Parameter with a List box by
Colby
My mdb works off of two main companies (A and B).
I am trying to build a parameter query that instead of just asking which
company it should run for; I want a...
|
August 11th, 2004 07:05 PM
by Colby
|
2 |
102 |
|
|
|
Calculating columns by
Taher
Hi there
I have a table and I need to obtain the sum of all of the
values in a particular column. Firstly, how do I
distinguish which column I want to sum up;...
|
|
2 |
102 |
|
|
|
Calculating Weekly Totals by
Van
I have a data base in Access XP that tracks total number of visits each
Friday for 6 or 7 years.
I want to count the number of visits for each year. My query...
|
|
1 |
102 |
