|
|
Unmatched Query by
I have created an unmatched query using the wizard.
However I wanted the query to check more than one field
before returning the unmatched records?
Any ideas?
|
|
1 |
1,112 |
|
|
|
August 13th, 2004 04:16 PM
by LeAnne
|
1 |
629 |
|
|
Parameter query with wildcards by
Instead of using the Enter Parameter Value dialog box
with the below criteria:
Like "*" &
& "*"
I would like to use a text box on my...
|
|
3 |
630 |
|
|
|
|
1 |
641 |
|
|
|
|
3 |
840 |
|
|
most recent date by
ok I've seen tons of answers to this question but none of them really work for my purpose, or I just simply don't understand.
Here's what I'm trying to do:
I...
|
September 7th, 2004 01:55 AM
by
|
2 |
606 |
|
|
comparing tables by
Does anyone know how I could find all the values in one table that are not in another?
I have a table named login; the fields are ID, first_name,...
|
September 8th, 2004 12:44 AM
by Tonín
|
1 |
750 |
|
|
|
|
4 |
873 |
|
|
Forms by
Hi,
how can I create a Form with a Datasource of two tables.
Regards
cucmejc
|
|
1 |
527 |
|
|
Like Converts to ALike in Query by
Hello,
Not sure if anyone has seen this but I have a dB that
will no longer perform parameter based queries using the
LIKE keyword. Instead it changes it to...
|
August 12th, 2004 04:51 PM
by
|
2 |
575 |
|
|
|
|
1 |
505 |
|
|
Querying from 2 Records by
I need to pull information from two fields in a table into
one field in another. I am trying to condense it into one
step but didn't know if it was possible. ...
|
June 14th, 2004 01:50 PM
by
|
2 |
592 |
|
|
Problem with a report by
Hello:
I'm attempting to produce a report in Access. The report
will have page breaks when the header info changes. The
problem is that the pages will break...
|
|
3 |
1,004 |
|
|
no results returned in query by
Hi!
These are my fields: event_id, LOC, GCS, and sample.
Now I am writing a query to return all fields when say
event_id=2 and LOC is null.
So what I did...
|
|
1 |
572 |
|
|
Combine update queries into one query by
I have a schedule database that uses 9 update queries
to "rotate" the schedule. The first query changes all
records with a ShiftID of 8 to 9. the next query...
|
June 30th, 2004 11:09 AM
by rp
|
4 |
555 |
|
|
Query on a date range by
I have a table called tblUnAvail with LName, FName, Start
and Stop fields. Another table called tblSchedule displays
Sun - Sat as text fields as well as the...
|
August 9th, 2004 12:15 AM
by Doug
|
2 |
614 |
|
|
Finding Duplicate Records by
I have a table that contains the following information:
Auto ID, PersonName, EventName, EventDate
PersonName, EventName, and EventDate are not unique.
There...
|
|
1 |
910 |
|
|
Oracle 1013 error by
i have read many users with this problem but no one seems
to know the solution. i have linked tables to an external
oracle database. when runnning a query,...
|
|
1 |
732 |
|
|
Tasks Not Completed by
I have a query of a table that lists all tasks for this
year.
I have another table that records each employee, the task
completed, and the date it was...
|
|
3 |
795 |
|
|
Count/Frequency of text within a table by
To whom it may concern
Can you tell me how I can create an access query which
will look in a column and produce a count of how
frequently a piece of text or a...
|
March 10th, 2005 04:09 PM
by JaRa
|
2 |
541 |