|
|
Create a query for specified text in a field by
Jacqueline _Neo
Hi there,
I have a number of fields in my query. They are Customer, Document, Title.
In this query, i have include a input dialog for the user to enter the...
|
|
2 |
293 |
|
|
How to calculate overdue? by
Jim
We have a customer that has terms of June/1 or Net 60. Any orders placed
between 10/2 of the previous year and June 1 of the current year have terms
of 6/1....
|
|
2 |
254 |
|
|
Help With SQL Update by
Jason[_40_]
Hello,
I have a table in an Access database that I want to create an SQL
Query for. Here
is the table structu
Location Number
Area1 2
Area1 ...
|
May 6th, 2010 09:07 AM
by XPS350
|
1 |
326 |
|
|
|
|
9 |
464 |
|
|
Help with InStr in a query by
cherman
I have values like "2010 WW14" and "2010 WW7" in a query and I'm trying to
grab the number part to the right of "WW". It will always be a 1 or 2 digit
number...
|
|
2 |
291 |
|
|
multiple query criteria by
olive
Let's start with the fact that I am an Access novice, so if this looks like I
am way off base, and cannot get any guidance here, just let me know.
...
|
|
4 |
313 |
|
|
Integers behaving like strings by
night_writer
I hope someone can help me find the reason for this behavior.
I am using a query to run a report that needs to capture status at the
end of the month, so I...
|
|
5 |
320 |
|
|
Check Box query help by
Steph[_3_]
Morning all, looking for some more help from my gurus.
What I have:
A table with 4 or 5 text fields, and 8 Check Boxes.
What I want: A query that will...
|
|
2 |
283 |
|
|
Appned Query Performance by
Walt Herman
I have an Append query with approx 25000 records with 8 fields and I am
trying to append it into a static table and the performance is abysmal. Can
anyone...
|
|
2 |
295 |
|
|
DateDiff with variable criteria? by
Jim
I have a query field that uses DateDiff("d",,)
to calculate the difference between a ship date and paid date. I also have
=50 in the criteria row to...
|
May 5th, 2010 07:51 PM
by Jim
|
5 |
300 |
|
|
|
|
4 |
290 |
|
|
Linking on field that allows nulls by
K Essmiller[_2_]
I have two queries that I need to link together on several fields. I need to
link on a PPOCode that is sometimes null. I need a count of claims for each...
|
|
3 |
272 |
|
|
Help! Unmatched Data Query by
ChelseaS
Hello! Here's what I'm trying to do, I'm not sure if an Unmatched Data Query
is the best answer or that this can even be done in Access.
I have one table that...
|
|
1 |
243 |
|
|
grouping issue with ' is not null ' by
trevorC via AccessMonster.com
Hi All,
This first query all works fine, giving the expected results.
The second query is a copy of the first query and i changed the " IN " to "
OUT ", but...
|
|
1 |
246 |
|
|
Two records one row by
Marcie
I have a table that has 2 records per id. I want to display in a query each
value as a record.
So if Id 123 has a record with the value of 7 and another...
|
|
1 |
248 |
|
|
|
May 5th, 2010 01:32 PM
by Andy
|
5 |
315 |
|
|
Expressions by
Amin
Kindly explain to us what this expression actually means.
i got it from the sample database 2007 temlate
Qty To Reorder: IIf(0,IIf(,,),0)
|
|
1 |
253 |
|
|
Add Fields from Record by
Scott
I have two tables. One has a unique PersonID with a lot of information about
the person (one to one). Another table has one to many records with
addresses...
|
|
1 |
306 |
|
|
|
|
1 |
295 |
|
|
Using Variable as criteria by
Mr. Bud
Hi and TIA. I have a procedure that constructs an In statement and stores
that value in a module level variable. I then want to use criteria in my
query to...
|
|
4 |
338 |