|
|
update a multivalued field access 2007 by
Joana Villas-Boas
I have an old Access 2003 table with logical fields to categorise my clients,
once there where no multivalued fields in that version.
I converted that...
|
November 17th, 2009 05:29 AM
by Dale Fye
|
1 |
541 |
|
|
|
|
2 |
114 |
|
|
2 Table Query issues by
dohernan via AccessMonster.com
Below is my current Query.
It behaves oddly. I am rather new to this all.
At this time there is only 1 Record in the Address table, and that address is
used...
|
|
7 |
249 |
|
|
Auto join in access 2007 by
David Z
I have checked AutoJoin in the Access Options, however, when i place two
tables w/ identical primary keys, it does not auto join them. It appears to
be not...
|
|
8 |
157 |
|
|
Delete Queries, any help appreciated! by
jim_s
First post, after much lurking.
I'm fairly new to Access, so please go easy on me, everyone!
I'm having problems with deleting records. I have an archive...
|
November 16th, 2009 03:13 PM
by jim_s
|
4 |
125 |
|
|
Close Matches??? by
Bill
Hi All,
I have two large tables (year 1 and year 2) of financial transactions that
contain a field with supplier name. I need to compare both tables for...
|
November 16th, 2009 02:51 PM
by Dorian
|
2 |
145 |
|
|
|
|
1 |
134 |
|
|
Show Fiscal Year by
turks67 via AccessMonster.com
How can I query a fiscal year of October 1,2009 to September 30,2010 with
expression in a query?
Is it possible to do this without changing the to and from...
|
|
2 |
122 |
|
|
date recognition problem in Access 2007 by
Norm Sund
I have a database made in ms 2003, i installed ms2007 and now the querry does
not recognize dates in the year 2010.... anyone have similar problem and find
a...
|
|
1 |
116 |
|
|
Newbie Query Help! by
Kabby
I'm driving myself insane trying to find the answer to what I believe is an
incredibly simple question....trying to teach myself Access as I go along.
I have...
|
November 16th, 2009 12:26 PM
by Kabby
|
4 |
163 |
|
|
Help with queries by
Alstar
Hi Guys,
This is the first time after school that I am trying to use ms access at
work and i need ur help in creating a query.
Any help will be highly...
|
|
1 |
119 |
|
|
|
|
3 |
127 |
|
|
Parameter Query by
Deb
I finally got a query to pull exactly what I wanted from the table, however
the query is based on a crosstab query and a select query. I'm trying to
make it...
|
|
1 |
131 |
|
|
delete identical duplicate records by
Jules
Is there a way to delete identical records in a table where all the fields
are identical? The way I have been doing it is by creating new auto number
field...
|
|
1 |
126 |
|
|
Logical Expressions in Access by
RoadKill
Okay, I am trying to put together a logical formula similar to what I would
in Excel.
This is what I have. But I want more options. For example, if they have...
|
|
8 |
183 |
|
|
Issue in create a certain query by
Benjamins via AccessMonster.com
Hi,
I have 2 tables: tblRecord and tblRange
tblRange contain 4 field:
fldCode, fldStart, fldEnd
fldCode (Text)(Only Manager will know the code, User will not...
|
|
2 |
262 |
|
|
Help with sql string building by
Jack
Hi,
I need to convert a QBE query to sql string
The QBE in sql is as follows:
SELECT EmployeePlant.EmployeeID, EmployeePlant.EmployeeName,...
|
November 13th, 2009 11:14 PM
by Jack
|
2 |
168 |
|
|
|
November 13th, 2009 09:43 PM
by LarissaR
|
3 |
122 |
|
|
Numbered Transactions by
Mike
I have a query with specific results that have fields such as concatenation,
division, amount, etc....I want to have a field which numbers the rows in...
|
|
4 |
114 |
|
|
Query and Combo Box by
MB
I'm using 2007. I have combo boxes on my data entry form. For example:
Pipe Material. Choices a PVC, Concrete, CLay. The query does not return
the...
|
November 13th, 2009 09:19 PM
by MB
|
2 |
130 |