|
Date Range Pulling Only Month
I am trying to create a query using a date range parameter [Birthdate] that
will pull just by month not by year and is ascending order. The criteria I
used was Between [Type Begin Date] and [Type End Date]. Any ideas???
Thanks, Sue...
|
3 |
11/13/2008 9:08:23 PM |
|
|
Totals Query question
SELECT tblDesignators.ProfileCode, tblContacts.ContactID, tblContacts.
MailingID, tblContacts.FirstName, tblContacts.LastName, [FirstName] & " " &
[LastName] AS Name, tblContacts.Email
FROM tblDesignators LEFT JOIN tblContacts ON tblDesignators.ContactID =
tblContacts.ContactID
WHERE (((tblDesignators.ProfileCode)="ShiningStar"));
I have a client management database that uses one table (tb...
|
7 |
11/13/2008 6:02:01 PM |
|
|
How to avoid duplicates in an union query
Hi,
I am using Next query in my vba code
Could someone help me to obtain the results in the second table with one
query.
How not to have duplicates like below
This is an union query from 2 tables
table1 tblPersoneel : table employees active without date of date
discharge "UitDienst = date discharge"
table2 tblJaarPlannerDates: dates and days holliday or absent
...
|
10 |
11/13/2008 5:38:38 PM |
|
|
Howto? get multiple results into a single row...
Hi folks,
I'm trying the following:
there are two tables:
t1:feature-ID,feature,...
t2:customer-ID,customer,...,feature-ID,...
Now I want to have a query, which produces the following result:
feature-ID, feature, (customer-ID1, customer-ID2, customer-ID3,...)
My problem: I don't know how to establish the third row, which should
be a subquery itself, but I do not get the results o...
|
2 |
11/13/2008 3:50:59 PM |
|
|
May not be in Right Group-Please advise
My question is how would you tell Access to take the text in one column of a
table and go into a folder in the computer and open each pdf and name that
pdf with the sequential records in the Access column?
--
Janet A....
|
5 |
11/13/2008 1:45:35 PM |
|
|
append query creating new records
Hi
I have created an append query to add serial number to table where LotNumber
in table matches lot in the query where serial number is found.
My append query sql is as follows
INSERT INTO dbo_DataLots ( SerialNumber )
SELECT [SERIAL SINGLE LOT].MaxOfSerial
FROM dbo_DataLots INNER JOIN [SERIAL SINGLE LOT] ON dbo_DataLots.LotNumber =
[SERIAL SINGLE LOT].Lot
WHERE ((([dbo_DataLots]![Lot...
|
5 |
11/13/2008 1:22:18 PM |
|
|
Awkward query!
Hello All
I have a table [months], with fields 'month name' (key field), 'bacs date'
(plus a few other fields), and I have a table [alarm schedule] fields 'month
name', and 'alarm_ID' (plus a few other fields). In table [alarm schedule]
there are many records with the same value in 'month name' - but with
different 'alarm_ID' values. I need a query that will return all records
from table [...
|
3 |
11/13/2008 10:45:05 AM |
|
|
My append query and I dont understand each other
I have an append query that takes information from unbound textboxes on a
form and creates new records in a table. The problem Im having (and I suspect
that its because I dont know what Im doing) is that the query will create
several new records as opposed to just one. If my table has 10 records in it,
then the append query creates 10 new records. So the table ends up with 20
records. I just ...
|
7 |
11/13/2008 8:40:30 AM |
|
|
manipulating query result into table
Hi, I have the foloowing data and I have different set of rules to select
maximum numbers.
mytable is
sr cdate numvalue
1 1/11/2008 23
1 1/11/2008 35
2 1/12/2008 12
2 1/12/2008 35
3 1/13/2008 23
3 1/13/2008 34
4 1/14/2008 12
4 1/14/2008 34
I have following query to count numvalue in say previ...
|
1 |
11/13/2008 5:35:01 AM |
|
|
using records from different table
Hi, I am new to access. I have Three tables with different data with
similiar structure.
My table1 is
sr cdate numvalue
1 1/1/2008 31
1 1/1/2008 14
2 1/2/2008 16
2 1/2/2008 18
2 1/3/2008 25
2 1/3/2008 29
table2 is
sr cdate numvalue
1 1/4/2008 34
1 1/4/2008 42
2 1/11/2008 5
2 1/11/2008 ...
|
2 |
11/13/2008 4:28:13 AM |
|
|
Sequence numbering of documents
Hello!
I have a problem with my numbering.
I am making a database for document control, and need some pointers.
The system is as follows (and this is set in stone);
All document numbers start with a project code, then originator code,
recipient code, type code, and sequence number
An example of a doc number: FG-AIL-BP-A-0001.
So far it's easy. The problem is that the sequence number...
|
3 |
11/13/2008 1:06:32 PM |
|
|
Query to pull all records for those missing records
Hi. I have a DB of payment records, each with a payment number (not
autonumbered because they are specific to date) and a company no.
Would like to pull a report of all payment records for each company that is
missing a specific payment number. Say all payment records for any company
missing payment #10.
I got help from someone else about using a totals query as the source of
anoth...
|
6 |
11/13/2008 1:13:02 PM |
|
|
Query multiple data from source table
I have a hugh table of six thousand + rows. I am trying to create a query
that will return employees with multiple rows of data from this table. My
statement is as follows:
SELECT [TableA], Empid, [TableA], Code1, [TableA],CodeA
FROM [TableA]
WHERE ((([TableA].Code1)="Apple" And ([TableA].Code1)="Pear") AND
(([TableA].CodeA)="Red" And ([TableA]CodeA)= "Blue"));
I'm not too proficient...
|
3 |
11/13/2008 3:25:01 PM |
|
|
Mail Merge with Access & Word
I'm trying to do a Simple mail merge to our production Database. Our Testing
Access database works fine, where I'm able to open the query through the
"open source" within the mail merge function of Word, but When I try to do
the same exact steps with our Production Access database I get the following
error. Both databases are fairly identical in data and structure.
"Word can not re-...
|
1 |
11/13/2008 4:45:01 PM |
|
|
Why is my query taking so long?
So this is my query:
SELECT "a 15 Minutes" AS Category,
ROUND((COUNT(*) / (Forms!Switchie!Days)),1) AS [Workloads Completed]
FROM [Strategy Fix 1]
WHERE (QUEUETIME < 15)
UNION
SELECT "b 30 Minutes" AS Category,
ROUND((COUNT(*) / (Forms!Switchie!Days)),1) AS [Workloads Completed]
FROM [Strategy Fix 1]
WHERE (QUEUETIME BETWEEN 15 AND 30)
UNION
SELECT "c 45 Minutes" AS Cate...
|
8 |
11/13/2008 4:49:41 PM |
|
|
updatiing top values into table
Hi, I have the foloowing data and I have different set of rules to select
maximum numbers.
mytable is
sr cdate numvalue
1 1/11/2008 23
1 1/11/2008 35
2 1/12/2008 12
2 1/12/2008 35
3 1/13/2008 23
3 1/13/2008 34
4 1/14/2008 12
4 1/14/2008 34
I have following query to count numvalue in say previous 3 sr's
SELECT a.SR, B.NumValue, (count(a.Numvalue)/5) AS Numcount, max(b....
|
1 |
11/13/2008 6:35:04 PM |
|
|
Creating a two dimensional table (Crosstab type) in Access
I have a table that lists about 165K email addresses and codes; i.e.
abc@test.com 123
abc@test.com 456
abc@test.com 789
xyz@test.com 567
xyz@test.com 890
There are about 5,000 codes with over 100K unique email addresses
I want to creat a table that lists the email address and all the possible
codes next to it, i.e.
abc@test.com 123 456 789
xy...
|
2 |
11/13/2008 9:09:18 PM |
|
|
Looking for most recent value other than today's. Question
I have numerous values (a,b,......) that are associated with a specific date
and time. I would like to compare the value obtained today against the most
recent date other than today. i am looking for a 50% changed in values
between the most recent (today) and the previous value. thanks in advance...
|
5 |
11/13/2008 9:12:59 PM |
|
|
compare 2 tables
I am using Alen Brownes audit trail and I need to Make a query that will
compare two tables [contacts] and [audcontacts] I only want to display the
entries that have a certian field that is different that fiels is "rep" I
have a cold caller who gives leads to the salesmen and i want to track those
leads or should i make a hidden yes/no box that gets checked when the cold
caller enters the lea...
|
2 |
11/13/2008 9:14:22 PM |
|
|
Iif returns True part not False
I have two tables and the following code to determine price for an item when
entering a new record. It is returning the [Current Price.Sales Price] when
it is True but never give me the False
=IIf([Current Price.Sales Price] Is Not Null,[Current Price.Sales
Price],[TMC Price.DA Price])...
|
9 |
11/13/2008 9:41:09 PM |
|
|
What is ParseAggComp
I have inherited a database that uses ParseAggComp as a function, but
Microsoft help does not recognize this and I have tried searching MSOffice
online and nothing.
Any help is appreciated...
|
2 |
11/13/2008 9:53:11 PM |
|
|
Use field to select but not group by?
Is it possible to use a field to select data but not use it as a group by
criterion? Here's what I'm trying to do:
Select all time record with a date greater than xx.
Present a single total number of hours for each task code/person combo.
Right now, I get about 15 records per person, since each pay period is its
own record/row in the query results. I then create another query that
...
|
5 |
11/13/2008 10:04:01 PM |
|
|
Dsum using an autonumber
I have a query from multiple tables where I want to calculate the sum of a
volume field (number) for all records with the same autonumber.
eg
ID (PK) Volume(number)
1 3.1
1 2.5
1 2.7
1 3.0
2 3.0
2 2.4
3 1.1
3 2.5
So the results I would like are; ID 1 = 11.3, ID 2=5....
|
2 |
11/13/2008 11:10:14 PM |
|
|
Select Max date from three different columns
I have three date columns in a table and I want to select the max date of the
three.
i.e. table:
ID date1 date2 date3
1 1/1/2000 1/1/2001 1/1/2002
2 1/1/1999 1/1/2003 1/1/2000
3 1/1/1998 1/1/1995 1/1/1988
Desired result:
ID Maxdate
1 1/1/2002
2 1/1/2003
3 1/1/1998...
|
3 |
11/13/2008 11:56:12 PM |
|
|
How to Display in Forms- Join Table Query ?
Harlo, i am developing a quries base on 2 tables and got stuck with some
issues hopefully someone kind enough to provide some help and guidance...
I had a from that generate display for this 2 tables (with text boxes)
How do i get the input from this quries to display on individual text boxes ?
The form should be able to display lists of records to enable navigation
viewing this report....
|
1 |
11/14/2008 5:52:28 AM |