|
|
|
|
3 |
126 |
|
|
|
|
|
6 |
91 |
|
|
|
Running Windows Microsoft Office on a Mac by
Hannah
I have a Mac (OS 10.4) and I just bought Parallels Desktop for Mac. Does the
Microsoft Office Home and Student 2007 suite include an operating system and...
|
March 10th, 2008 01:07 AM
by Hannah 
|
4 |
94 |
|
|
|
insert date format changing by
Sensay
hi guys,
this has really took lots of time from me and i wasn't able to solve it
i have written in my VBA codes this query:
DoCmd.RunSQL "insert into exister...
|
|
1 |
85 |
|
|
|
if statement by
RhondaR
Hi. I have a text field (each one with a different number of characters)
where some of the records at the end of their sentence contain "(CA)", or
"(CA", or...
|
March 9th, 2008 11:47 PM
by fredg
|
2 |
84 |
|
|
Date/Time by
Gene
There was a post that said "Bear in mind that you cannot store a date without
a time - a default time of 00:00:00 is assumed." (See Pete, 10/27/06)
I am...
( 1 2)
|
|
13 |
170 |
|
|
|
multiply more than entry in a table by
Chris Wainwright
Hi there,
sorry to hassle you all but I have a table where each client may have more
than one mulitplier attached to their file
eg.
Client 1 . . . 1
Client...
|
|
2 |
104 |
|
|
|
Sort fields with 1.1-1, 1.1-10a, etc. by
GwenH
I have a table with a field that contains the component ID number for 800+
items. The ID numbers are as follows:
1.1-1
1.1-2
1.1-3
1.1-4
1.1-5
1.1-6
1.1-7
|
|
9 |
121 |
|
|
|
One Field Returns Wrong Information by
ridgerunner
I have a query using multiple tables and multiple primay keys that is
returning the wrong information for one field that is not part of a multiple
primary...
|
|
4 |
94 |
|
|
|
cannot see the design bottom view. by
Cam
Hello,
In the query design view, I don't know why certainly I can not see the table
field view at the bottom, I can only see the top table link view. I scrol...
|
|
1 |
101 |
|
|
|
Big Error by
PA
An update query updated a large number of field values in the wrong field.
It added the value YED-14- to the left of the existing values.
Is there a way to...
|
|
2 |
81 |
|
|
|
"Use of OR condition in UPDATE Query" by
Shaukat
I have a table that lists a set of diseases in several columns (say 2
columns, Disease1, Disease2). I want to create a new column (let us say,
Diabetes)...
|
|
2 |
128 |
|
|
|
Return date help needed by
Pat_RI
I have a table which contains a date column and what I want to return is the
2nd newest date for each specific Item. For example
Product Date
1 ...
|
|
2 |
109 |
|
|
|
Simple criteria question by
miss031
I am not too good at writing SQL, and I don't know how to do this in design
view: I would like the results of my query to be equal to ( AND
) OR . I don't...
|
March 8th, 2008 08:53 AM
by miss031
|
4 |
86 |
|
|
|
Entering multiple interactive parameters by
Mich
Hi,
I am trying to create a query with the following criteria:
1) Prompt user to enter data from a list/combo box - Required data
2) And have the option to...
|
|
1 |
92 |
|
|
|
Subquery possible? by
Jason W. Martin[_2_]
A record contains PARTID and COMPONENTID fields. There could be multiple
records per part. For example:
PARTID COMPONENTID
030.11A 030.090
030.11A ...
|
|
1 |
130 |
|
|
|
Query calculated field question by
Victoria
hello
I have a query with fields ID, Level, a1, a2, a3, a4,......... a40.
The fields a1 to a40 will either be blank or will have an integer value
from...
|
|
2 |
96 |
|
|
|
Show Crosstab query on a continuous form by
Samantha
Hi,
Is it possible to show a crosstab query on a single form (at the Detail
section) and have variable (not fixed) number of Value columns to display? I...
|
|
1 |
136 |
|
|
|
adding '00' to a field by
norm
I have a database that tracks EZ Pass tags, after several years of use we
have adapted a bar code scanner into it, now the scanner adds 2 zeroes in
front of...
|
March 8th, 2008 12:54 AM
by norm
|
4 |
92 |
|
|
|
|
|
3 |
115 |
