|
|
Replace Co with Company by
Sandspur
I have a field that I need to replace Co with Company
Most of the time Co is at the end of the CompanyName but sometimes it is in
the middle of CompanyName
...
|
|
6 |
208 |
|
|
Count Query by
Mr-Re Man
I have a query with 5 fields
, ,,,
Permit Type has 3 values, either "Season Ticket, Standard Ticket & Concession"
There are approx 70 different schools
I...
|
|
1 |
148 |
|
|
Convert Text to Date by
jfredel via AccessMonster.com
I have a text field with date like data in it but its text data. THe field
looks like 31Dec2009 - how can i reformat that so its a recognized
date field that...
|
February 12th, 2010 06:37 AM
by fredg
|
1 |
193 |
|
|
Multiple Commas by
mdkryptoking
Some people decided to play a cruel joke and pulled two commas into a name
field and i need to split the name into a first and last name column.
Normally i...
|
|
3 |
185 |
|
|
Use Table field in query criteria by
deeds
Just like using the Forms!FormName!FieldName....can I use that same logic
with Tables? I have a start and end date in two fields within a single
table. I...
|
|
1 |
188 |
|
|
Query with Date Calculations by
kim s
I'm working in Access 07 but creating a database that is 2003 compatible.
I am absolutely sure that I am over-thinking this but can't seem to resolve
my...
|
February 11th, 2010 09:45 PM
by kim s
|
4 |
170 |
|
|
COMBINING 2 QUERIES INTO 1 by
lmiller
I have developed this query for my 7th term inventory balances:
SELECT ., .,
.
FROM
WHERE (((.)0));
This query for my 8th term balances:
SELECT ., ., .
( 1 2)
|
February 11th, 2010 09:34 PM
by lmiller
|
13 |
310 |
|
|
|
|
2 |
245 |
|
|
union query by
lmiller
I am trying to develop a union query for my 2 inventory balances. the query
comes back with the first 2 fields correctly but when it comes to the
balances...
( 1 2)
|
February 11th, 2010 05:34 PM
by lmiller
|
19 |
244 |
|
|
Joining two tables by
IgorM[_2_]
Hi
I want to join two tables (by UNION ALL). In order two identify the source
table I'd like to add a column that would contain a table name (typed in in...
|
|
2 |
165 |
|
|
Data Mismatch with join by
Jim
I have a table where the field is a TEXT field 20 characters long that I need
to join to another table with a field that is a NUMBER field 50 characters...
|
|
2 |
122 |
|
|
Parameter Query by
Nigel
I have a check box in my query. When I type "Yes" into the criteria row and
run the query, I get the results I want. However, when I change it to a
parameter...
|
February 11th, 2010 05:00 PM
by Nigel
|
2 |
143 |
|
|
Values from multipule records in 1 record by
Vics
Hello
I'm looking to create a querey that will take mulitple records from a table
and put them in 1 record in my query
For example, Lets say I have 2 tables,...
|
February 11th, 2010 03:34 PM
by Vics
|
4 |
122 |
|
|
Recalc not working by
Faraz A. Qureshi
In one of my forms I want a subform to be updated the moment I enter it and
one of it's combobox be reflecting all the entries in one of the filed in the...
|
|
2 |
158 |
|
|
Updateable Query problem in Windows 7 by
DESeibold
I'm using Office 2003 in a new windows 7 computer. I copied a database to the
new computer from the server. When I try to run the following query, I get a...
|
|
2 |
413 |
|
|
|
|
1 |
174 |
|
|
I cant create an MDE File by
naveen prasad[_2_]
Hi all ,
In my project in Access, i have converted to acess 2003, then I tried to
create an
MDE but not able to do it.
when i tried to create any other...
|
|
2 |
144 |
|
|
|
|
0 |
202 |
|
|
Retain Field Format From Excel by
Lisa W.
I have an excel file that I'm importing to Access. This field consists of
"time"...hours, minutes, seconds. The format in excel is set to "Custom" -...
|
|
2 |
195 |
|
|
|
|
1 |
119 |