|
|
wildcard by
Joel Allen
Hello,
I have the following criteria in a query. It will find anything with the
letter "H" in it and it works.
Like "*H*"
I want it to be a a prompt...
|
|
4 |
149 |
|
|
IsNull by
Mike Will via AccessMonster.com
I've tried and tried to rewrite the following section of my sql statement to
no avail using IsNull in place of Nz. I need to use this query in a...
|
|
2 |
210 |
|
|
|
|
1 |
137 |
|
|
|
|
2 |
173 |
|
|
Unwanted parameter dialogue box! by
CW
In my Corporates table (and on the associated form) I have a field called
Mailshot? and it is formatted as a Y/N. Needless to say, this is to flag
which...
|
February 12th, 2007 08:11 PM
by CW
|
2 |
140 |
|
|
Adding the data of two columns together. by
Roman B.
I have two columns I need to add the data together and place into a third
column.
for example.
Column 1 says - widget
Column 2 says - 002
I would like...
|
|
1 |
163 |
|
|
Criteria of two field values being equal by
B. Meincke
I need to create a query that returns records from a table where the first
six characters from one field equals the first six characters from another,
and...
|
|
2 |
135 |
|
|
|
|
0 |
152 |
|
|
|
|
3 |
123 |
|
|
subform query by
Spring
I am using ID# field as a combobox of unbound field in a form to
select and display related information shown at the subform, so a memo
field is warpping...
|
February 12th, 2007 04:52 PM
by Spring
|
0 |
118 |
|
|
Feild could refer to more than one table? by
John T Ingato
Can someone tell me what is wrong with this SQL. When I try to run it I get
an error:
The specified field '" could refer to to more than one table
ilisted n...
|
|
2 |
115 |
|
|
Am I forcing the 0's correctly? by
Dos Equis
Hi all,
Using this code:
SELECT tbl_Carrier.CID, & " " & AS
Name,Cint(NZ(Count(tbl_Complaint.Complaint),0)) AS
FROM (tbl_Carrier INNER JOIN (tbl_Area...
|
|
5 |
140 |
|
|
Record Counts in Query level by
Jai_Friday
Good Morning/Afternoon to all...
A quick question I hope....
Is there a basic function in query level that will put the record number on
each record
What I...
|
|
5 |
127 |
|
|
Fractional seconds by
Jeroen
Hi,
I am creating a database for a swimming association and they need to enter
100ths of a second.
The problem is, Access does not seem to support fractional...
|
|
3 |
201 |
|
|
|
|
2 |
203 |
|
|
Equi join by
CoachBarkerOJPW
Can anyone give a simple definition of what an equi join is? The text book I
am using isn't really clear on how to create one.
Thanks
CoachBarkerOJPW
|
|
4 |
122 |
|
|
Append crosstab result to a table by
crafty
have following data:
1234 fred client
1234 tom owner
1235 ralph client
1235 bill owner
crosstab query result:
1234 fred tom
1235 ralph bill
I want to append...
|
February 12th, 2007 05:44 AM
by crafty
|
2 |
128 |
|
|
Compare Sets of Data by
David127
I have a list of products that have multiple features. Some optional some
manditory. I'd like to compare my table of products and features with a
reference...
|
|
1 |
136 |
|
|
Popup on Running a Query???? by
Bill
Hi All,
Is there anyway of getting something to popup when a query is run from the
main menu. I appreciate that it can be made to happen through a macro or a...
|
February 12th, 2007 02:22 AM
by tina
|
3 |
164 |
|
|
update query by
DucateAssignment via AccessMonster.com
Is there anyone that knows how to import a txt file into access and create an
update query to update a table?
Any help would be appreciated.
--
Message...
|
|
6 |
132 |