|
|
Query - Adding 50000 to an ID field by
KARL DEWEY
If it is a numerical field then try this --
MS_link: 50000 +
If it is a text field then this --
MS_link: 50000 + Val()
"Matt_Fairfield" wrote:
hey...
|
|
0 |
80 |
|
|
Date Calc/Criteria by
Anthony Viscomi
I am trying to filter records via a query; the query has a Date field
"DueDate". I would like to display the records that meet the following date...
|
November 30th, 2006 09:14 PM
by Klatuu
|
5 |
90 |
|
|
1 to Many. Duplicate field values by
KARL DEWEY
If the data in table2 is a roll-up report of table1 data I see two ways to
go. Just use as a subreport. Or use report Sorting And Grouping and have
a...
|
|
0 |
90 |
|
|
if/lookup?? by
chris
help my mind is blank again !!
i have my value field and my invoice frequncy field,
value field been the price and the inv freq been a number 1 to ...99.
i...
|
November 30th, 2006 09:02 PM
by chris
|
2 |
70 |
|
|
|
November 30th, 2006 09:02 PM
by E10
|
0 |
85 |
|
|
only show certain rows in a query by
jlorick
If you have consistently used this format for all of your records, you can
add a criterion with a wildcard in your query. You would type in the first
letter...
|
November 30th, 2006 08:41 PM
by jlorick
|
0 |
78 |
|
|
Calculating group total in report by
Danielle
Thank you Duane!
"Duane Hookom" wrote:
Group your report by PositionID and display the Group Footer section. Add a
text box in the Group Footer section...
|
November 30th, 2006 08:28 PM
by Danielle
|
0 |
91 |
|
|
append queries by
[email protected]
i have this append query its working apart from one bit
for the field Manufacure ID, I would like it to get the number from the
form i am on
How do i get it...
|
|
2 |
88 |
|
|
union query memo field by
SeekAns
I use a union query to generate a report in excel. The report has a memo
field. I use excel version 10 and all the messages in the memo fields are
displayed....
|
November 30th, 2006 07:53 PM
by SeekAns
|
0 |
78 |
|
|
SQL by
Klatuu
I assume you are in a form, but you did not say what you would do to initiate
the search, so I am guessing you will be entering the customer ID in a text
box...
|
November 30th, 2006 07:44 PM
by Klatuu
|
0 |
76 |
|
|
|
November 30th, 2006 07:33 PM
by ChuckW
|
0 |
66 |
|
|
SQL by
Ramtin
I have query, finding customers based on customer ID, What I can not do is
when there is no record on my table meaning the customer is new i want access
to...
|
November 30th, 2006 07:01 PM
by Ramtin
|
0 |
75 |
|
|
STEP BY STEP DATA ACCESS PAGE by
juan de dios
hi i'm new on asp may some one send me an example of how to bind data to a
dropdownlist and depending of the value connect to a hipperlink and open a
word...
|
|
0 |
64 |
|
|
only show certain rows in a query by
veronicamars
I have a product/serviceID Field. In a query I just want to show the product
information. The product ID numbers are like P100, P101,P102 and the
serviceID...
|
|
0 |
73 |
|
|
|
November 30th, 2006 06:31 PM
by HLD920
|
0 |
86 |
|
|
|
November 30th, 2006 06:24 PM
by Klatuu
|
0 |
85 |
|
|
league by
Dale Fye
Gil,
Try something like:
SELECT T1.TeamName, T2.TeamName
FROM tbl_Teams T1, tbl_Teams T2
WHERE T2.TeamName T1.TeamName
This should give you all of the...
|
November 30th, 2006 06:21 PM
by Dale Fye
|
0 |
87 |
|
|
Trying to return unique records only by
Dale Fye
Krista (I assume this is Krista),
Is it a hyphen separator or an underscore as you mentioned in your response
to my post yesterday? One of the problems with...
|
November 30th, 2006 06:14 PM
by Dale Fye
|
0 |
80 |
|
|
Updating primary key in multi-table db by
hime
I have a database of graduate students that uses their SS# as the primary key
in the main table, and as a foreign key in the related tables. I have
enforced...
|
November 30th, 2006 06:06 PM
by hime
|
0 |
117 |
|
|
|
November 30th, 2006 06:02 PM
by HLD920
|
0 |
93 |