|
|
Display parameter used for query by
Pyrite
I have a query set up to search for people eligible to access a specified
site. An unbound combo box on a form allows the user to select from a
predefined...
|
July 18th, 2008 03:48 PM
by Pyrite
|
2 |
150 |
|
|
Query Date criteria by
Jasper Recto
I have a query that has a date criteria that is in a range. For example it
runs from 1/01/08 to 03/31/08.
Is it possible to change the criteria so it...
|
|
1 |
149 |
|
|
Left Join Query by
Danu
This should be simple but I am having a problem. I have a table which I have
set up in a left join query against a much larger table. The common field is
the...
|
July 18th, 2008 01:34 PM
by Danu
|
2 |
144 |
|
|
Update Query combine two functions by
Darmahart
Is there a way to combine two functions in the Update To box for one field?
I'm trying to use Replace() to get rid of two excess strings of duplicate...
|
|
2 |
119 |
|
|
|
|
11 |
258 |
|
|
Union Query by
Royce Schnepp
Here is my dilema if you will. I am working on a database for foreclosure
sales, in the process of appeding information from DBF files to tables, the
primary...
|
|
6 |
192 |
|
|
2 fields of different lenghts by
Revis01
I am creating a queary of 2 tables. Common field is Account number. Table A,
the filed is 15 characters. Table B, the field length is 25, and the 10...
|
|
2 |
132 |
|
|
extract part of a text value into a date by
sherriross81
I have a field that is a date but it is stored as a string. I am not allowed
to change the field data type, but in my access report I would like to
display...
|
|
2 |
126 |
|
|
|
July 17th, 2008 09:54 PM
by Todd
|
1 |
106 |
|
|
query based on different devices by
Nick A Carter
I work in a very large IT database that tracks serverfarm racks and the
equipment on them. We just had a new field added to the database and I need
to...
|
|
2 |
164 |
|
|
append query question by
PattiP
I'm keeping track of monthly meter readings with a sample of 6 accounts. I
have created an append query that copies the previous month's accounts to the...
|
July 17th, 2008 08:44 PM
by PattiP
|
6 |
159 |
|
|
Parameter Queries by
alecgreen
I have a parameter query, using between and to which works fine, but I
want to enhance the query to do the following.
1) I want to be able to select...
|
|
3 |
201 |
|
|
|
|
5 |
181 |
|
|
IIF statement failing by
Hank
I use the following in a query:
PastDue: IIf(Date(),Format(25+-,"currency"),"")
Something has changed. The code worked great for a while, but not it will...
|
July 17th, 2008 07:32 PM
by Hank
|
3 |
118 |
|
|
Inconsistent query results by
franky
Hello,
I have a link to a vfp database table. I also have a local table with some
of the items that exist in the vfp table. When I run a query with an...
|
July 17th, 2008 07:26 PM
by franky
|
0 |
142 |
|
|
Update Query for Fiscal Date range by
workweek
I have one table that contains Today's Date. I have a second table that
contains fiscal month dates. For example July = 6/28/2008 - 8/01/2008. I
need to...
|
|
2 |
143 |
|
|
Query an Asterisk in the description by
Scott
Some of our product descriptions have an asterisk in the description to flag
those products. How do I query all the products that have an asterisk in the...
|
July 17th, 2008 05:15 PM
by Scott
|
3 |
166 |
|
|
Doesn't recognize Crosstab gen Fields by
Bonnie A
Hi everyone! Using A02 on XP. I have a table with multiple records for 1-4
quarters. I have my first query (Query01) that pulls by (contract
number) and ....
|
|
5 |
198 |
|
|
Error when creating make tables by
fgwiii
I have been using the same make table queries for months and when I ran two
different queries yesterday, I am receiving errors on both queries after the...
|
|
1 |
127 |
|
|
Compound Select by
JimS
I have a cool new form I'm having trouble with the rowsource
property...primarily because I'm hard-headed... Here's the situation:
I want to select as my row...
|
|
1 |
105 |