|
|
Desperate for help by
[email protected]
Here is what I am trying to do: I have two controls on a
"subform" (a combobox and a textbox). I have the row source of the
combo set to the value of a query...
|
February 16th, 2007 05:10 PM
by Dale Fye
|
1 |
185 |
|
|
Last Date when two tables involved by
gmore
Hi! I am trying to get the last date on the table SIR which is linked to the
table SIR_D.
Table SIR
-----------
SIR_ID (primary key)
ENTERED_DATE
Table...
|
|
7 |
158 |
|
|
Query last 7 days by
[email protected]
HELP!!!
Using Access 2000, I have a field titled "Open (date)", I am trying to
create a query that gives me only records that have been opened in the
last 7...
|
|
3 |
188 |
|
|
summing a query by
Stever
Experimenting with summing in a query.
Have a 2 simple tables with part number and qty as fields
ie table 1 part1.....qty1
tablw 2 part...
|
|
3 |
224 |
|
|
Allen Brown please - Crosstab by
mhmaid
I am trying to use the example you shown here
http://allenbrowne.com/ser-67.html
but unfortunatly the columns are coming without value.
any help please.
I...
|
February 16th, 2007 02:26 PM
by mhmaid
|
5 |
338 |
|
|
Count IF Query by
richardwo
Hello,
I have a query with two fields, Patient Name and FollowUp. FollowUp is a
"Yes/No" field and I would like to show a list of patients with the number of...
|
|
7 |
250 |
|
|
|
February 16th, 2007 01:17 PM
by Chaote
|
0 |
164 |
|
|
|
|
1 |
237 |
|
|
Exchaning a field with data from another by
Jess
Here's my problem, I am an accountant, that is part of the problem I know.
I have a client who has data that comes out his software that has names
associated...
|
February 16th, 2007 12:46 PM
by stumac
|
1 |
147 |
|
|
Query error by
Doc Rock
I just started getting a query error when I run the following query. It
states the expression is typed incorrectly or is too complex to be
evaluated. The...
|
|
1 |
305 |
|
|
Find duplicate records in multiple tables. by
jones6
Hi, Can anyone point me in the right direction to solving this?
I have a Table which is a parent table with and Primary key ID and data.
I can find duplicate...
|
|
1 |
161 |
|
|
Crosstab almost perfect by
Blair
This is my sql
My crosstab has a total across the top, the total decreases as the count
goes up in the column rows. I would like a sub total at the bottom...
|
February 16th, 2007 04:05 AM
by Blair
|
0 |
145 |
|
|
|
|
0 |
263 |
|
|
Link AutoNumber to Text Field by
mattc66 via AccessMonster.com
Hi All,
I have 2 tables that I need to link the AutoNumber to a Text Field in another
table. Is this possible?
If so, how do I do it?
Matt
--
|
|
4 |
190 |
|
|
Running Total / Concatinate question by
Daesthai
I'm trying to get a running total for hours worked that are divided by
project/by date.
I have the following fields:
Project ID number (saved as text)
Date...
|
|
3 |
165 |
|
|
compariing and listing certain dates by
lee
I am using Access 2003 and I have a database that lists vision date, hearing
date and consent date on individuals. I would like to develop a query that
will...
|
|
4 |
136 |
|
|
Duplicate Query by
quest1914
My apologies, I should have stated that I did attempt the query wizard. I
went to Queries, New, Find Duplicate Query Wizard, and it produces a dialogue
box...
|
|
1 |
147 |
|
|
Reports due date by
Ldydi525
Hello
I created a database to generate grants received. I would like to know how
to tracks with reports are due. The reports due dates varies per item such...
|
February 15th, 2007 11:03 PM
by Smartin
|
3 |
190 |
|
|
wild cards by
Stever
how come wild cards "*" don't work in a linked table query? say I put in
as a input request, B* does not return all the part
numbers starting with B. That...
|
February 15th, 2007 10:48 PM
by Stever
|
1 |
146 |
|
|
Field alias by
Dave
Is there a way that I can query fields in table from a table containing a
list of the field names?
Thank you
Dave
|
|
1 |
156 |