simple query no data found
Mon, 15 Dec 2008 14:18:08 -0800
built a database where table 1 fields take their data from a second table
which is used as a list eg table 1 field Authors name will pull its data from
table List of authors.this was set up using look up wizard. when i run a
query to find a name i get nothing. if i run the same query on manually
entered data ...
|
Add only new records using an append qry
Mon, 15 Dec 2008 13:25:01 -0800
Afternoon everybody,
I am trying to run an append query to add records from one table not found
in another table. I can't seem to get it to work. I have a table called
ReInsp, and a table called NonPCC, both have a field called NonPCC. I want
table ReInsp to update table NonPCC. I can only get the query to ...
|
Test with (D) or (D1) or (D2) or (DD) - Discontinued
Mon, 15 Dec 2008 13:18:06 -0800
I am trying to write a query to help me identify if a sku is discontinued.
The text field from our mainframe comes across as:
1. HAR 4/2.5 BATTERED CHEDDAR CRISPS
2. (D)GNR 8/2 3/16" BATTERED ONION RINGS
3. (D1)DMN 1/8 SPRINGROLL - CHICKEN
4. (D2)MCX 9/2.5 BBAT ONI HOT SCOOPERS
5. (DD)MCX 10/1kg BATTERED ON ...
|
Need help building query
Mon, 15 Dec 2008 20:52:39 GMT
Hello,
I need input as to how to go about building a query so I can create a report
bringing together many different pieces of information. The database
involves employee benefits.
The database contains insurance data for health, dental, vision, life,
voluntary life, disability and other products. The ...
|
compare one record to a minimum of a group of records
Mon, 15 Dec 2008 12:17:03 -0800
I have one record in table A. I have a group of records in table B. I need to
know if one of the columns in table A is less than the minimum of the group
of records in table B (for a particular column in table B). How would I do
this? ...
|
Expressions
Mon, 15 Dec 2008 11:35:23 -0800 (PST)
I have set up a query in a Returns Database and I am using the
following expression for one of the fields:
[WBDefectDescription] & (" -- "+[WPDefectDescription]) & (" -- "+
[MILLDefectDescription]) & (" -- "+[TSDefectDescription]) & (" -- "+
[TEDefectDescription]) & (" -- "+[BEDefectDescription]) & (" -- "+
[ ...
|
datepart returns erroneous week number?
Mon, 15 Dec 2008 11:16:03 -0800
I may have discovered a problem with the datepart function.
I inserted this as an expression field in a query:
test: DatePart("ww",#12/30/1991#,2,2)
With the provided optional arguments to the function (firstdayofweek
=2=vbMonday, firstweekofyear=2=vbFirstFourDays), the result should be "1" but
it returns ...
|
|
|
=hour(data)*60+minutes(data)
Mon, 15 Dec 2008 11:09:01 -0800
I have an excel sheet that uses this calculation. Now I'm tryng to simplify
my work by using access as a tool. I need the formula that would match the
excel.
...
|
Weird cross-tab question
Mon, 15 Dec 2008 11:09:01 -0800
I saw a similar question as this posted back in July but was not able to get
an answer. I am trying to create a crosstab query off of an existing query.
In the existing query (qryResidence) there is a subquery that is used to
populate one of the fields (Lease_Amt).
On its own qryResidence works fine. ...
|
query criteria Not Like ... <>
Mon, 15 Dec 2008 10:25:02 -0800
I'm building a query to filter the contents of a table of order numbers and
part numbers. The filter is a subset of the part numbers in the main table.
I need to apply the filter two different ways based on the contents of a
separate table called Toggle. If the contents of Toggle is 1 nothing is
filtered ...
|
