|
|
SQL and Query results don't Match by
Filo
In a very simple query I entered that I only want to retrieve data for
product 200. After the query runs results show results for product 200 but
also for...
|
July 10th, 2008 01:31 PM
by Ron2006
|
2 |
689 |
|
|
|
|
2 |
849 |
|
|
update blank fields by
Ra
Hi,
I have two imported tables.
Table1:
CSPC Toolset Month
B3851 AB3851 4/1/2008
B3853 AB3851
B4852 AB4852 4/10/2008
|
July 10th, 2008 11:57 AM
by Ra
|
3 |
712 |
|
|
multiple condition queries by
stuart
morning all
hopefully someone out there can offer some assistance
i am building an access application in which i wish to be able to intially
look at all the...
|
|
1 |
793 |
|
|
Conditional Criteria within a query by
Kerry
Hi! I've got the following fields and I want the second to contain criteria
contingent on the value of the first:
Dept_NBR is a number coming from a form...
|
|
4 |
707 |
|
|
Conditional IIF question/null value by
Kerry
Hi! I've got a combo list in a form which I have the choices of multiple
numbers and an ALL choice (21, 22, 23, 24, ALL). I'm trying to use an IIF...
|
July 10th, 2008 05:42 AM
by Kerry
|
2 |
728 |
|
|
Offer a Default in a Criteria by
Ross[_3_]
Hello all,
I want to create a query that offers a Default in the criteria under a Date
field, for example:
"default as Date today -7"
This will allow the...
|
|
2 |
657 |
|
|
Adding A Leading Space - Update Query by
Singinbeauty
Hello,
I need to add a leading space in a field to make the entry 6 digits because
I have one table being matched to another but on one the WO#'s that have 5...
|
|
8 |
709 |
|
|
Crosstab Parameter Decleration by
AccessARS
Hello,
I have been researching this for couple of days and with some trial and
error managed to build this croostab statement. Unfortunately my parameter...
|
|
2 |
658 |
|
|
IIF/UpdateQuery/AppendQuery??? by
susan
This morning I got help with the IIF statement but now it got a little more
complicated (to me):
the original:
If StdPrice = 0, give me "rebill"
If Part#...
|
|
1 |
628 |
|
|
Missing Records in a 2 Table Query by
Itenoeth
I have a query where I am combining two tables- "Leads" (contacts) and
"Listings" (addresses). Not every Lead has a corresponding record in the
"Listings"...
|
|
2 |
623 |
|
|
Queries and reports by
theIThombre
Hey Gang,
Quick question- I have a staff member who is tryiyng to find out which
queries are connected to certain reports. She is in the process of printing...
|
July 9th, 2008 09:21 PM
by Klatuu
|
4 |
781 |
|
|
|
|
5 |
686 |
|
|
Dues Query by
DNork
I have a employee database. In the database, union members are a subset of
employees, as such their "member status" is "member" or "member-LOA" while
non...
|
July 9th, 2008 09:10 PM
by Klatuu
|
2 |
613 |
|
|
Append query for data recovery by
Steel Banana
Hi, newbie here. I've recently lost a lot of data from an Access database.
I've since recovered it, and would like to combine it with additional data
created...
|
|
1 |
584 |
|
|
Concatenate in a query - Access 2003 by
Judi
I have a table which refers to two groups of salesmen, District Managers and
Sales Service Managers. DM's are over SSM's and both are referred to in the...
|
July 9th, 2008 08:26 PM
by Judi
|
4 |
714 |
|
|
|
|
7 |
773 |
|
|
Query ?? by
dazoloko via AccessMonster.com
Dear All
I have a table with the following fields which I have uploaded from a
spreadsheet
ID Number
Reference Type
Reference
There are two reference...
|
|
3 |
715 |
|
|
Query INSTR function? by
William
I'm using a query and need strip out data.
Here is an example of the data I have to work with:
85123147/RS08
85123147W/RS08
TEX-M/SS09
I need my query to...
|
|
2 |
600 |
|
|
Help with calculation flow days by
Cam
Hello,
I got a query that I try to calculate the number of days at several
operation, but not sure how to go about calculating in query. In the query I
got...
|
July 9th, 2008 04:33 PM
by Cam
|
0 |
611 |