How do I Delete records 120 days old?
Tue, 16 Dec 2008 08:05:01 -0800
Created a database that imports records from Excel. Trying to create a query
that will delete records that are over 120 days old. Cannot figure out the
criteria to use in the delete query. ...
|
Access duplicates query
Tue, 16 Dec 2008 07:37:17 -0800 (PST)
Hi people
I have an access query I am trying to implement in a database....due
to the nature of the data it is selecting...there will be duplicate
entries (the data is for a series of events and finds people who have
visited the events. Therefore, if a person has visited more than one
event, they will show mo ...
|
Update query
Tue, 16 Dec 2008 07:11:03 -0800
I have 2 tables...
Table 1: has two fields- "Reports" and "Current Period"- current period is
yes/no.
Table 2: has 13 fields- "reports" and "PD 01-PD12"
I want to run an update query...I want to use Table 1 to update Table 2
depending on the Period...
I was hoping in my update query to link by report, a ...
|
Query Column A type and Column B type = cost
Tue, 16 Dec 2008 07:00:11 -0800
I wonder if anyone can give me some pointers in the right direction.
Ill trying to write a query which will form the basis of a report
Basically its cost of engineering works and how much it would cost to build
a certain type of chamber in the ground.
I have a table containg information about different ch ...
|
Nested Query
Tue, 16 Dec 2008 05:28:01 -0800
I want to insert into table1 and read max ID at same time and use this query
in MSACCESS 2000. it rerurns an error. How can I correct it?
Insert Into Table1(ID,QTY) Values(
(Select Max(ID)+1 From Table1)
,50) ...
|
Need Money????
Tue, 16 Dec 2008 00:05:00 -0500
Need Money, visit http://dinero4ever.blogspot.com
Now!!!! ...
|
Querie with Data Entry and Wildcards
Mon, 15 Dec 2008 15:26:02 -0800
I am working on a database and I want to make the search for business names
easier. Some of the business names are long and I want the search to use a
string and a wildcard. In a query you can use [...] to enter specfic data eg
[Enter Town] Tamworth, and all businesses in Tamworth show. So as you can
imagine ...
|
|
|
Strip Decimal
Mon, 15 Dec 2008 15:11:01 -0800
I have two different tables that have ICD codes, its just that in the
selection list the codes do not contain the decimal, but in the master list
they do. How do I remove that decimal? Thanks a bunch ...
|
Query Help
Mon, 15 Dec 2008 15:00:01 -0800
I have a query built that brings back info based on a phone number I enter.
Is there a way to have the query ignore dashes in a phone number that I paste
into the query? I copy in 555-123-4567 but my data set has the number listed
as 5551234567. Thanks ...
|
Join on an Empty Field
Mon, 15 Dec 2008 14:45:15 -0800 (PST)
I am trying to use Access to confirm that input files are being
properly imported and processed by a third party app - testing the
developer's work.
And I am using access to join the tables that represent that input and
output. Anyway, when I match on a given column of data that contains a
mix of values like ...
|
