|
|
Delete records from second table by
sebastico
Hello
I have two Tables.
tblMain(MainID)
tblSec(FamID, Group, MainID)
MainID has same attribute in both tables
tblMain has the correct records.
How can I...
|
|
3 |
937 |
|
|
Has Hierarchy the Parameter between years? by
sebastico
Hello
Access 2003. I have a query with the following parameters.
Like !. & "*" ‘Data are in TAA
Like !. & "*" ‘Data are in TBB
Like !. & "*" ‘ Data are...
|
|
5 |
936 |
|
|
Default Dates by
Ampridge
I have a query that calculates records between two dates as
Between And
Is there a way to show a default value for the beginning and ending dates in
the...
|
|
2 |
935 |
|
|
append Query duplicating records by
Alex
I have an Append Query which runs from an On click event
attached to a command button in a form.
When the append query fires it adds records to a table
which...
|
|
1 |
935 |
|
|
Date syntax in query by
Ginger
I get an error message with the following sql statement. It
does not seem to like the format "short date". Could
someone check the syntax for me and see where...
|
|
1 |
933 |
|
|
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 |
932 |
|
|
Query is not updatable - by
Doug Johnson via AccessMonster.com
Please help. I've created a query which is pulling data from 11 tables. The
query is not updatable. I've spent hours reading other postings ...
|
|
3 |
932 |
|
|
Very difficult query (?) by
PayeDoc
Hello
I've been struggling with this all day, and although I think I'm near a
solution (actually I thought that 2 hours ago!) it now involves 4 nested
queries...
|
May 30th, 2010 05:26 PM
by Dennis
|
9 |
932 |
|
|
'Not in' Query by
John
Hi, I have a few tables and want to run a query, but am
not sure how the sql will work out. I have a table that
has a list of students, and a results table...
|
May 24th, 2004 05:16 PM
by Newbie
|
2 |
930 |
|
|
Using IIF statement in Memo Field by
J Cunningham
Hi,
I'm fairly new to Access, and I need to write a query which will check a memo field to see if it is null, then display "n" (for not having data in the...
|
|
5 |
929 |
|
|
"Group By" problem by
JMCS
We have a query that has been working quite happily for over ayear, but has
suddenly decided to play up, giving a "No current record" message box. The
query...
|
|
3 |
929 |
|
|
|
|
1 |
929 |
|
|
Convert text to Combo by
Mickey[_4_]
Hi,
I have some 20,000 entires populating a text filed that ideally should
be a combo box. I'm looking for the best way forwards with this and
wonder if...
|
|
1 |
928 |
|
|
Books & Otehr Sources by
Mickey[_4_]
Apologies for repeating what has probably been asked before although my
newsreader can't find anything! I'd appreciate any advice on Access
books and...
|
|
1 |
927 |
|
|
Union Query Issue by
Larry
Hi guys.
I'm using Access 97 (SP2) to do some work for a client.
I am running a Union Query on two tables tht are identical, to create one
set of data. Here...
|
July 12th, 2004 08:53 AM
by Pete S
|
4 |
927 |
|
|
|
|
2 |
924 |
|
|
Query Quandries by
Frank
i have a table, tblgeneral, that contains order
information on customers, referenced by tblcustomer, what
i am attempting to do is show how many unique...
|
May 24th, 2004 06:19 PM
by Frank
|
2 |
924 |
|
|
SQL server backend by
inungh
My mdb file is moving tables from mdb backend to ODBC link to SQL
server tables, but queries are in the front end.
Should I change the queries to stored...
|
|
2 |
923 |
|
|
|
|
1 |
921 |
|
|
Limiting Records in an Update Query by
Amy E. Baggott
I have a report that generates assignment sheets for exhibitors who have
received booth assignments so that the orders can be updated (for various
reasons,...
|
|
5 |
920 |