|
|
Update Query by
Access Rookie[_3_]
How do I create an update query to automatically assign the create date of
9/24/2009 as the end date for for the record with the create date of 9/15/09.
ID ...
|
|
1 |
240 |
|
|
Querying Dates by
Martin
Hello,
I am looking for some advice on how to tackle querying some data.
I have two tables, table one with around 10,000 records per month and
columns...
|
|
5 |
262 |
|
|
query to update familyID by last name by
Kathy R.
I have a set of about 500 names that I need to break down into family
groups. The data was imported from an old database and this set of
names does not have...
|
|
4 |
260 |
|
|
SubQueries by
Bruce
I am running Access 2007 SP2 on Windows XP Professional SP 3. I have a query
that I need to run a subquery to obtain a value in the previous record....
( 1 2)
|
March 21st, 2010 04:43 PM
by Bruce
|
14 |
616 |
|
|
Adding lines together to create one line by
clalc
This is probably very simple but somehow I can't remember how to concatenate
lines, so I have one line. Here is example:
Table: Notes
OrderNo LineNo ...
|
|
4 |
299 |
|
|
Query with 2 parameters asks for 3 by
Avid Fan
I want to search on first and last name at the same time, so I have made
a combined field called BigName. When I run this query I get a request
for three...
|
|
2 |
271 |
|
|
|
|
2 |
231 |
|
|
DSum in Query by
Peter
DSum in Query
Hi. I think this is probably an error in my syntax and I’d really appreciate
some help please. I have a financial database that has many...
|
|
3 |
289 |
|
|
syntax for Week number by
Revned
Hi,
Can anyone help me how figure out a correct syntax for week no.
I have tblRev with fieldname:Date
I want access automatically display the week no....
|
March 21st, 2010 03:54 AM
by Revned
|
3 |
204 |
|
|
Days in part of the month by
Leo
If I have a date ('VisitDate')then if I need to know how many days in that
particular month from that given date, the following VBA code...
|
March 21st, 2010 12:13 AM
by fredg
|
1 |
210 |
|
|
Fields in a query by
sjcowden
I am trying to create a query but when I run it I get the message - query too
complex. Am I limited to the number of fields I can incorporate into a query
or...
|
|
4 |
233 |
|
|
Help with a partial match query by
Whirled.Peas
I asked this question here many, many years ago and have since forgotten
the answer.
I have a table with address data in it, spread over several fields. One...
|
|
6 |
215 |
|
|
ODBC errors? by
Zoomiest
I have a webserver hosted in my basement running a MySQL database. I
am using ODBC to connect to it, and run queries with MS Access. I have
done this for...
|
|
4 |
192 |
|
|
|
|
8 |
361 |
|
|
|
|
1 |
241 |
|
|
IIF and formatting by
Huber57
I hope someone can help!
I am running MS Access 2003. I have two Expressions built in a query that
look like this:
Expr5: IIf(0,,"TBD")
Expr2:...
|
|
9 |
316 |
|
|
Converting a Date by
FC
I have a column with dates in the format mm/dd/yyyy. I would like to have an
additional column the will give me only the month and another only the year,
all...
|
|
2 |
194 |
|
|
Best 5 bids by
JulieFlynt
I have a dB that has two main tables not associated with a relationship.
Table One is baseline info from previous year with information about each
line item...
|
|
3 |
152 |
|
|
Query to unnormalize some data by
Joseph Greenberg
I have a the table with fields , , . It is normalized. I
want to select out = 1 or 2 (easy enough), and create two new
variables and , so each record has...
|
|
4 |
195 |
|
|
|
|
3 |
194 |