|
|
SQL Command to List all Tables? by
Harry Whitehouse
I'm trying to read an Access database from a C++ program and get a list of
the table names in the target MDB. I've done this with SQL Server with this...
|
|
2 |
145 |
|
|
Format text by
Rodney
Hi,
I am just trying to set the format to capitalise the first letter.
I am using
L???????????
But every time I change fields it changes...
|
|
1 |
152 |
|
|
Subform parameter query by
[email protected]
There is probably a much better way to do this, and I hope there is,
but here is what I am trying to do: I have two controls on a
"subform" (a combobox and a...
|
|
1 |
175 |
|
|
query by
Helen
I want to be able to take two tables I have and join them into 1 linking it
by last name and first name. The first name in table 1 is the actual first
name,...
|
|
2 |
148 |
|
|
Accessing Queries in another file by
ACCESS2007
Database is Access 2000 format but working with in Access 2007
I have a database split into three files; one holds the tables, another
holds the...
|
|
3 |
191 |
|
|
Adding a prefix number by
CAM
Hello,
In my query I have a text field called "Location" in this field I usually
have a single digit number or a double or triple digit number. What I want...
|
|
2 |
235 |
|
|
|
|
0 |
141 |
|
|
Duplicate Query by
quest1914
I am attempting to find duplicate numbers by creating a new query in Access.
I have imported an excel file with multiple worksheets into access and would...
|
|
3 |
208 |
|
|
how to chek if a field is not null by
Moe
I have query that populates a Report based on values and fields from two
tables. However, it shoud not include any record where one specific field is
blank....
|
February 15th, 2007 02:06 AM
by Paul B
|
1 |
135 |
|
|
Invalid Argument Error with Append Query by
stenz
We've been getting an Invalid Argument error whenever we try to run an append
query. We have not had this problem in the past. We have just installed the...
|
|
3 |
121 |
|
|
First|Last Function by
May
Field “code” is a text variable in a table and it can be sorted properly in
the same way as a numeric variable. In a query, I want the dataset shows the...
|
|
7 |
150 |
|
|
weekend query by
Joel Allen
Hi there,
I have a query that does:
-
and it gives me a number of days. This works, but I want it exclude
Saturday and Sundays. Is there a way to do...
|
February 15th, 2007 12:29 AM
by Smartin
|
1 |
138 |
|
|
need help with percent by
oxicottin
I have a qry where I want to divide "Regular Delay" by "Employee Regular
Time" and give me a percent. Example:
Regular Delay 2.5hrs
Employee Regular Time...
|
|
4 |
140 |
|
|
|
|
3 |
135 |
|
|
Queries with Parameters by
Dale
Is there a way to have a 2 queries with a parameter input and then have a 3rd
call these queries selecting everything and unioning them together somehow...
|
|
2 |
158 |
|
|
show dups where all fields equal by
perryclisbee via AccessMonster.com
I have a detailed patient information table with instances where there are
duplicate claim numbers . I ran a query that showed all cases where the
claim...
|
|
1 |
166 |
|
|
flip this query by
rodchar
hey all,
i have a query that produces the following results:
field1 field2 field3
------ ------ -------
val1 val2 val3
well there are so many fields that it...
|
|
3 |
173 |
|
|
Association Difficulty by
Allison
Windows XP Pro SP2, Access 2003
I have a query containing (among other fields) the fields: fldName (text),
fldID (number), fldPrimary (yes/no field), and...
|
February 14th, 2007 10:24 PM
by Allison
|
2 |
140 |
|
|
Crosstab more than a years data?? by
Bill
Hi All,
I would like to use a crosstab query to analyse monthly data over a longer
period than a year but it doesn't seem to be able to do that, instead the...
( 1 2)
|
|
12 |
218 |
|
|
What am I missing? by
Amy Blankenship
I have a query that creates a new record but does not populate all the
fields. All fields except the memo field (reportRTF) populate properly.
I'm guessing...
|
|
7 |
144 |