|
Create Table Query
I have two tables that I need to create a mailing letter for. One of
the tables could have over 700 student records and the other table
could have 10,000 records a year depending on student grades.
Table 1
AutoID | StudentID | Last | First | Grade | YOG | SchoolYear
10001 | 9784 | Doe | Jane | 7 | 2013 | 08
10002 | 982745 | Doe | John | 6 | 2014 | 08
10003 |...
|
6 |
12/31/2008 4:10:06 PM |
|
|
parameter queries
I am running a report through a query that has three parameters asking for
the insurance, appointment date, and status. You can enter one piece of
information for each box that pops up and the report will show the data that
matches all three criteria. I want to make it so that if you press enter for
one or any of these boxes thus leaving it blank it will show all the data for
that field. F...
|
3 |
12/31/2008 4:09:10 PM |
|
|
Union Query with a Crosstab Query
I have two select queries; one for one type of revenue booked by sales reps
which is called 'Bookings' and the other for another type of revenue
generated by sales reps, and this is classified as 'Search'. These two
queries are combined in another query which is a Union Query. This works
fine. Now, I split out the sales rep revenue, by rep and by advertiser, via
a Crosstab Query. All...
|
1 |
12/31/2008 4:06:04 PM |
|
|
Primary Key
I made a from to key in data to a form. Afterwards I decided to create a
Primary key for the table. My form however is not populating the field.
Please help. Thanks...
|
16 |
12/31/2008 4:05:19 PM |
|
|
append queries
I have 3 append queries I would like to run at the same time from one
"command button" without warning messages. But before they run, I need to
delete all records in the [Table] I am appending. Below are the 3 queries.
Thanks
INSERT INTO ImportDateDue ( Job, Due )
SELECT [Date Due].[Job Number], [Date Due].[Date Due]
FROM [Date Due]
WHERE ((([Date Due].[Date Due])>Now()-1));
INSERT...
|
3 |
12/31/2008 3:56:40 PM |
|
|
Is it possible to have multiple queries updating from common crite
Hi,
Our end of month reporting uses masses of queries, all of which run from
common criteria, e.g. date x to date y.
Some of these criteria, e.g. start date for reporting purposes and end date
are common to all queries and it would be a huge benefit to be able to set
them only once, rather than having to go into every single query and set them.
Using some form of today / current mon...
|
4 |
12/31/2008 3:52:29 PM |
|
|
Criteria of parameter queries
I have created a bibliographic database using Access 2003. Here some
parameter queries have been made to retrieve textual information through the
text box. For this I have designed the criteria as Like "*" &
[Forms]![Form1]![TextBox1] & "*" for a particular field. This crieteria can
retrieve any exact single word or phrase. But it couldnt retrieve phrases
containing any punctuation, if e...
|
3 |
12/31/2008 3:42:01 PM |
|
|
Concantonate Addresses
My address list is a bit different in that it has only four
fields--StreetNumber, StreetName, Unit and Building. Up to three of these may
be blank (Null) for any given record in my Address table.
In my query I want to concantonate the address parts into one field. I
currently have:
Address: IIf(IsNull([StreetNumber]),"",[StreetNumber] & " ") &
IIf(IsNull([StreetName]),"",[StreetName...
|
5 |
12/31/2008 5:59:43 AM |
|
|
Table differences
I get a weekly schedule sent to me in an excel file that has about 200 rows
of addresses, descriptions, and dates. In the past we have gone through last
weeks list and this weeks list to find differences. This takes way too long
for something that access can do. I have got to the point of comparing
existing records to last weeks records but not been able show new records
that were not on l...
|
2 |
12/31/2008 5:34:08 AM |
|
|
Link Excel Workbook to datasource
How do I create table in Excel and connect to a database. From there I want
to continously generate update query monthly based on certain
criteria(Queries).
Please I am a novice in this. Any step by step instruction will do. Or Link
to useful information as to get this done.
THanks...
|
2 |
12/31/2008 5:05:00 AM |
|
|
query to pull records based of subquery column
Hello all..
I am really really in need of a help.
I have a table and a query, table1 and query1. Query1 has the following
columns and rows:
ID Audit
223 2
234 3
225 1
226 2
The column ID is unique, have one record per row and data in column Audit
are not unique.
Here are the columns and rows for table 1. Records in column ID are unique
but can have more tha...
|
5 |
12/31/2008 3:55:01 AM |
|
|
String contains query.
How can I create a query that will search for the existance of a char. field
in a string. I'm using Access 2000.
For example:
The char. field would be 'CEC' and the char. var is 'CHL ABC DEF CEC'
Thanks....
|
5 |
12/31/2008 3:50:03 AM |
|
|
Parameter Query that does not prompt
I have created a simple parameter query. What I would like to do is:
SELECT * FROM QUERY1(param1=2008) and get back the data for year
2008.
SELECT * FROM QUERY1(param1=2007) and get back the data for year
2007.
The problem is, it ASKS for the year, is there a way to actually pass
in the year whithout making a form?
Thanks in advance...
|
2 |
12/31/2008 1:28:40 AM |
|
|
Reminder Query
Hi All,
I have a need to show records that are 3 month or older from a set date. How
would I wright a query to extract that data?
--
Matt Campbell
mattc (at) saunatec [dot] com
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200812/1
...
|
7 |
12/31/2008 1:10:33 AM |
|
|
Query help
How do you get this to terminate on a null value or empty value.
SELECT STORPOGTRASH.[SPOG#], STORPOGTRASH.[POGSTR#]
FROM STORPOGTRASH
WHERE (((STORPOGTRASH.[SPOG#])=[PLEASE ENTER A PLANOGRAM NUMBER]));
Any help would be greatly appreciated...
|
2 |
12/31/2008 12:14:01 AM |
|
|
Append Query in VBA (?)
I have a string of append querys that I need to run monthly.
I've been doing it by first importing the tables I need to
append, and then running the append querys. It's gotten
pretty smooth, so I thought it might be time to roll them
into code behind a form, and just run the lot of them, in a
particular sequence, from a single button.
But I've never done anything like that before.
He...
|
2 |
12/31/2008 12:06:05 AM |
|
|
QUERY QUESTION
WHAT DO I NEED TO DO WITH THIS QUERY TO GET IT TO TERMINATE ON A NULL STRING
OR 0?
SELECT STORPOGTRASH.[SPOG#], STORPOGTRASH.[POGSTR#]
FROM STORPOGTRASH
WHERE (((STORPOGTRASH.[SPOG#])=[PLEASE ENTER A PLANOGRAM NUMBER]));...
|
7 |
12/30/2008 10:10:03 PM |
|
|
pulling records from one table based of another table column
Hello all..
I am really really in need of a help. This query of my project has hold me
back now for months. The project is to develop a database.
I have two tables, table1 and table2. Table 1 has the following columns and
rows:
ID Audit
223 2
234 3
225 1
226 2
The column ID is unique, have one record per row and Audit is not unique.
Here are the columns and r...
|
6 |
12/30/2008 10:07:10 PM |
|
|
Quering a drop down column from a table
I am trying to select entries in a table that have "Vancouver" listed in the
column City. I have used the following criteria in the City field:
"Vancouver"
This works when the City column entries in the table are manually entered,
but does not work when City column entries are selected from a drop down list
which references another table. Insteqd, I get a balnk query return.
How...
|
3 |
12/30/2008 10:07:08 PM |
|
|
2 functions 1 field in an append query
I am trying to do a split of one field into two and put the last two digits
of an 11 digit number in field number two. I used the statement below. I
also want to use a format statement in the same field so the leading zero
doesn't get taken off when exporting the data. How can this be done. The
statement is as follows.
PCP SUF Id: Mid([PCP ID],10,2)
I want to add this format st...
|
2 |
12/30/2008 9:59:32 PM |
|
|
dialog box
I have two queries that prompt for a beginning and ending date. I run a
macro to run both queries, and get prompted twice for the beginning and
ending date. I would like to create a dialog box, and need the detail I
would put in the criteria for the query.
Thanks...
|
2 |
12/31/2008 4:14:05 AM |
|
|
NIKE AIR JORDAN FORCE FUSION SHOES AJF 5 V JORDANs 5 FUSION NIKE
shoes on
AIR Jordan 1 (paypal payment)www.king-trade.cn
AIR Jordan 2
AIR Jordan 3
AIR Jordan 4
AIR Jordan 5 (paypal payment)www.king-trade.cn
AIR Jordan 6 Rings
AIR Jordan 6
AIR Jordan 7
AIR Jordan 8
AIR Jordan 9 (paypal payment)www.king-trade.cn
AIR Jordan 10
AIR Jordan 11
AIR Jordan 12
AIR Jordan 13 (paypal payment)www.king-trade.cn
AIR Jordan 14
AIR Jordan 15
AIR Jordan 16
AI...
|
1 |
12/31/2008 5:15:47 AM |
|
|
Prada shoes (paypal payment)www.king-trade.cn )
Footwear (paypal payment)www.king-trade.cn )
Paul Smith shoes
Jordan shoes
Bape shoes
Chanel shoes (paypal payment)www.king-trade.cn )
D&G shoes
Dior shoes
ED hardy shoes
Evisu shoes
Fendi shoes (paypal payment)www.king-trade.cn )
Gucci shoes `
Hogan shoes (paypal payment)www.king-trade.cn )
Lv shoes
Prada shoes (paypal payment)www.king-trade.cn )
Timberland shoes
Tous shoes
Ug...
|
1 |
12/31/2008 5:16:17 AM |
|
|
How to Find & Replace the # Symbol
Using MS Access 2003 SP3 I am unable to [Find & Replace] the # symbol.
How do I do this?...
|
2 |
12/31/2008 2:22:12 PM |
|
|
linked view from database, Can append but not refresh- help?
I have a database which is linked to another and provides a view. The view
is then imported to a table by an append query. I need to be able to refresh
the data in the table as it changes. I have tried an update query and also
the refresh data option but neither works.
Can anyone help?...
|
2 |
12/31/2008 3:45:16 PM |