|
|
Select record External Source by
John
Hi:
I would like to insert a record and the record is extracted from Excel file
in Access 2003. I know I can write the SQL command as:
insert into...
|
|
4 |
197 |
|
|
'Not In' query not seem to be working by
John
Hi
Access 2000 SP3. I have a Clients table which has 5400 records.When I run
the below query to return all records in Clients table that have matching
keys...
|
|
6 |
110 |
|
|
Repeating a Total in Mutiple Records. by
John
I have a table with several months of monthly reports (One for each month.),
I have a planned percent complete in another table. The planned percent...
|
October 4th, 2008 01:00 AM
by John
|
2 |
98 |
|
|
Oldest date by
John
I want to build a query to return a list of employees and the dates they
reached a certain level. In simple terms My table looks like...
|
|
2 |
80 |
|
|
Date calculation in query by
John
Hello.
I'm having a bit of a problem with a query. First of all, let me just
emphasize that the final result of the query I want to build would be...
|
|
3 |
88 |
|
|
Rounding Time? by
John
Hello,
I am needing some assistance with the following:
I want to take someones hours for the day and round them with the following
rule =
If you work 5.01...
|
November 19th, 2008 11:11 PM
by John
|
4 |
149 |
|
|
List controls on a tab page? by
John
Hi,
I have a form that has a tab strip with 4 or 5 tabs on it. I'm trying to
write some code that will list all the controls on a specific tab page.
I can...
|
November 26th, 2008 04:23 AM
by tina
|
4 |
107 |
|
|
removing spaces by
John
I have a query that has a date and time field. What I would like to do is
read the only the date, for example; 11/12/2008 12:34:67pm. I tried this
test1:...
|
November 25th, 2008 06:59 PM
by fredg
|
2 |
68 |
|
|
current month by
John
I have a query that has the date and time as 11/26/2008 12:42:33pm, what I
want to do is pull the current months data using the system date/time. I've
tried...
|
November 27th, 2008 09:35 AM
by KatyTK
|
9 |
120 |
|
|
|
August 12th, 2008 10:47 PM
by John
|
0 |
58 |
|
|
Rolling 3 Month Average by
John
I have been working on this all day and can't seem to make it work. I have a
crosstab query that shows a cost code and description and monthly period
cost. ...
|
August 11th, 2008 07:31 PM
by John
|
1 |
111 |
|
|
Finding the date of last pay rise by
John
Hi
I have a Jobs table with Staff ID, Job Rate and Job Date. Staff start at a
rate and their jobs from that day onwards have that rate. Then they get a...
|
|
8 |
99 |
|
|
Date issue by
John
I have a sql database that access is using to do some queries on, in the
queries there is a date/time field. I've used the datevalue() function to
remove...
|
|
9 |
124 |
|
|
Assigning ID by group by
John
Hi
I have a table of contacts with their associated companies. How can I assign
numeric company ids in sequence to these records such any records with the...
|
|
1 |
109 |
|
|
simple select query variable question by
John
I haven't used Access in a couple of years but I used to know how to do
this.
Very simply I have one table of Products and I want to enter Criteria into
the...
|
June 6th, 2008 11:52 PM
by John
|
4 |
125 |
|
|
A97 - Query from a Form not working by
John
I have a table with about 70 "skills" which are based
on an employee survey (to be used for an emergency)
such as Electrician or Roofer or many others
Each...
|
|
1 |
130 |
|
|
Dinamically Build a CrossTab by
John
I have a form with the following selections a user may select:
1. Date format: "Ordinal" or "Calendar"
2. Group By: "JV ID","CMIS ID", or "Craft"
3. Value to...
|
July 11th, 2008 07:18 PM
by John
|
2 |
118 |
|
|
CrossTab Help! by
John
I have a query that uses a subquery to calculate a prior period cost, so I
can calculate the difference between a total todate cost this month and the
total...
|
July 16th, 2008 09:51 PM
by John
|
6 |
169 |
|
|
|
July 18th, 2008 11:49 PM
by John
|
4 |
116 |
|
|
|
April 17th, 2009 10:28 PM
by John
|
4 |
86 |