|
|
DateSerial in Query by
Kazlou
I have used DateSerial in the control source in field in my table to
calculate the renewal date, adding 36 months to the original date, all works
great. When...
|
|
1 |
169 |
|
|
Select statement assistance by
Danielle
Data Information:
table1: tblPayGradeStructure
Fields to be used: CurrGrade and CurrBreakpoint
table2: tblPredSalary
field to be used: PredSalary (note...
( 1 2)
|
|
11 |
287 |
|
|
Export qry results to another database by
Pilgrim
In my office I run 2 databases (same design but different data). I would like
to be able to export a recordset to the other database or to a format that
the...
|
February 14th, 2007 05:52 AM
by Len
|
1 |
149 |
|
|
Export qry results to another database by
Pilgrim
I wanted to email the datapacket for them to work with. Keeping in mind they
have limited or no knowledge of databases.
"Len" wrote:
Is the client...
|
February 14th, 2007 05:26 AM
by Pilgrim
|
0 |
173 |
|
|
dividing a month into 5 production weeks by
Shah1398
i am facing problems in dividing a month into 5 weeks and then showing
production of different sections of a factory in each week and also in each
week there...
( 1 2)
|
|
10 |
276 |
|
|
Make Multiple Tables via Query by
Michael_V
I've tweaked some vb code which streamlines repetitive tasks. Essentially it
takes Table1 and parses it into individual tables based upon a list in Table2...
( 1 2)
|
|
15 |
268 |
|
|
Queries won't open in Design View by
Bob
Hello,
I am using Access 2007 Trial Version. I am trying to open queries in design
view but get an error. The same queries open fine in design view in...
|
February 13th, 2007 11:19 PM
by Bob
|
0 |
123 |
|
|
|
|
1 |
115 |
|
|
Special Character '#' by
Samantha
Is it possible to query a field for a special character '#'?
I'm trying to query a desc field that has '(B#)' in it.
So far, I'm using: Like "*(B#)*", but...
|
|
6 |
138 |
|
|
|
February 13th, 2007 09:49 PM
by Ron
|
6 |
171 |
|
|
Matching Queries by
[email protected]
I have numerous Excel lists that I need to merge into a master
database. Some lists have partial, identical information, some have
similar info with different...
|
|
0 |
138 |
|
|
End If without block If by
ZIMMJE
I CONTINUE TO GET COMPILE ERROR: END IF WITHOUT BLOCK IF!!!! CAN ANYONE TELL
ME WHAT IS WRONG?
Sorry so long I wanted to provide the detail --
In a query I...
|
|
5 |
194 |
|
|
|
|
3 |
132 |
|
|
|
February 13th, 2007 08:03 PM
by Sighman
|
3 |
142 |
|
|
|
|
4 |
139 |
|
|
Series of action queries by
ashg657
Hi, I have a procedure which runs when a particular summary form is opened.
The procedure runs a series of action queries which update data in many
tables so...
|
|
8 |
134 |
|
|
|
February 13th, 2007 07:35 PM
by Lewis M
|
2 |
164 |
|
|
querry - choosing selection by
Viktor via AccessMonster.com
I have the following query:
SELECT Students.stdFirst, Students.stdLast, Courses.crsName
FROM Students INNER JOIN (Courses INNER JOIN CoursesTaken ON...
|
|
1 |
172 |
|
|
|
|
14 |
259 |
|
|
Setting a criteria to lookup from a table. by
Surrealdogma
I want my query to show me only those records in a table with a certin name.
The field on the table project info table is set to look up
from the Clients...
( 1 2)
|
|
10 |
333 |