|
|
|
|
3 |
215 |
|
|
join with different number of rows by
stickandrock
I have a table(A) that is joined to 2 other tables (B and C). The Key in all
3 of these tables is Part. Part 123 in on Table A 1 time, on Table B 3 times...
|
|
7 |
209 |
|
|
Query in a subform field by
Joanne
Hello,
I have a database that tracks vacation time. The main form has the basic
employee information and the subform has a list of all the days taken. If...
|
|
1 |
141 |
|
|
Batching Append Queries by
Steve
I have two tables that are joined through a joining table where the PK of
both are inserted when there is a relationship between the two PKs. My
problem is,...
|
November 19th, 2009 07:34 PM
by Steve
|
5 |
142 |
|
|
Query for Multiple Lookups by
Rita_M
I'm using Access as the reporting tool for a third-party-developed
proprietary database (I can't change the structure of the database). The
database has a...
|
|
2 |
145 |
|
|
Yes/No parameter for selecting either by
Owl
I would like to know if it is possible in a query to have a parameter that
will allow the user to select either Yes or No, and if so please supply the...
|
November 19th, 2009 07:04 PM
by Owl
|
3 |
182 |
|
|
Alias outfield column header by
PatK
I have a question about Aliasing fields in a query, if that it the right
terminology.
I have linked my Access DB to an external sharepoint list. The person...
|
November 19th, 2009 06:51 PM
by PatK
|
3 |
248 |
|
|
Aliasing a column header field name by
PatK
I am linking my access DB to a sharepoint list. The field name in the list
(I have no control over it) is: Prod (Month Start)
I want to change the name of...
|
November 19th, 2009 06:48 PM
by PatK
|
2 |
143 |
|
|
Text to Time converstion problem by
D. Stacy
The goal of this effort is to convert text data into time data. The data
comes in 0045, 0200, 0530, etc. BUT it does not always come in in 4 digit
text...
|
|
2 |
139 |
|
|
|
|
1 |
133 |
|
|
Inserting a character by
BlackKnight
In a table I have a textfield containg data like B09-001, B09-002 etc.
Now I am almost at B09-999, so I like to insert a "0" so that the data look
like...
|
|
5 |
174 |
|
|
|
November 19th, 2009 11:06 AM
by james
|
3 |
149 |
|
|
NZ function by
ErinCullen
I am trying to use an nz function on a query, so that I get a zero instead of
a blank. I can't figure out where to actually type the nz function. Do I type...
|
November 19th, 2009 03:25 AM
by kc-mass
|
1 |
111 |
|
|
I can't figure out how to do this. by
SF[_5_]
Hi,
I can't figure out how to do this. I want to check if staff is available in
the office by create query from TravelTable (TravelID, EmployeeID,...
|
November 19th, 2009 03:00 AM
by SF[_5_]
|
3 |
167 |
|
|
Counting records in a query by
OssieMac
I have a query created with the query builder that has the Unique values
properties set to Yes. I would like to be able to add a virtual field to the
query...
|
|
9 |
217 |
|
|
making an equation in access by
Dani.
Hi, I would like to create a field that works out a formula based on other
fields. i.e field z=field4, when field 1field 2 - field 3 etc. Yes, it may
be a...
|
|
2 |
116 |
|
|
print multiple reports from databse by
alecgreen
Hi
I have a table in my database that contains customer orders, within
those orders are the products reuired to fulfil the order. For each
product there is a...
|
|
0 |
98 |
|
|
Adding Information to a Table by
Toria
Here's my scenario:
I have a table called SCT. It has about 150,00 records with many fields. I
took all the account numbers from this table and looked up...
|
November 18th, 2009 06:17 PM
by Toria
|
2 |
110 |
|
|
SQL Error Help by
RayToddJr
The following is the SQL that I have in my code:
strSQL = "INSERT INTO taDEFENDANTS(TrusteeDefendantID)" & _
"VALUES(lngTrusteeDefendantID)" &...
|
|
1 |
97 |
|
|
Report from a Crosstab w/Parameters by
sg
I'm working on a crosstab query that has parameters. I read an article that
said to add the parameters to the Query/Parameters as well as in the criteria...
|
|
1 |
110 |