|
|
Show items not null by
mattc66 via AccessMonster.com
I have created a query.
SELECT qryItemsWith26Chars.ITEM, qryItemsWith26Chars.DESCRIPTION,
qryItemsWith26Chars.
FROM qryItemsWith26Chars
WHERE...
|
|
4 |
239 |
|
|
|
|
13 |
417 |
|
|
name error by
rdv
I have a select query in Access 2007. It has always worked in the past, and
still works when I run it. However, when I try to switch to design view, I
get...
|
|
1 |
209 |
|
|
update all records in table by
APINDARA
I have a table that contains 80,000 records and want to add a field that I
can use to note year and location of receipt of record.
Something like 2004AB or...
|
|
6 |
228 |
|
|
Select records from 6 combo boxes by
Shiva
Hi,
I am in urgency to create a form having 6 combo boxes on it which is
supposed to select data from a table containing a huge data. I want to add a
click...
|
|
1 |
151 |
|
|
Convert column Data Type by
Alastair MacFarlane
Dear Group,
I have 2 tables with the following schema:
Table A:
ID (Integer)
LinkID (String)
Table B:
ID (Integer)
|
|
2 |
219 |
|
|
Query Help by
Mike
I am trying to set up a query to show a merit increase for two different
employees using their social security number. Each of them is receiving a
different...
|
|
1 |
116 |
|
|
Grouping by
Greg
Hello,
A question.
If I have a table like this:
777 555 1111, 7/1/2008, 1, 333
777 555 1111, 6/1/2008, 0, 444
777 555 1111, 7/1/2008, 1, 555
|
July 17th, 2008 03:25 AM
by Greg
|
2 |
139 |
|
|
|
|
1 |
145 |
|
|
Need help on a Query Calculation by
Eric
I'm trying to figure out how I can create a query that would do the following
calculation. Any help would be much appreciated.
My problem lies around the...
|
|
1 |
116 |
|
|
Getting a query to accept a null value by
TESA0_4
Hi,
I have created a form with two unbound combo boxes. One allows the user to
select a code that represents a type of risk and the other allows the user to...
|
July 17th, 2008 12:06 AM
by TESA0_4
|
2 |
135 |
|
|
query numeric values from text by
Mary G
Hello,
I'm not finding an exact match to my situation. I have received an export
file with the address (street address, city, state, zip) all contained in one...
|
|
4 |
149 |
|
|
CrossTab Help! by
John
I have a query that uses a subquery to calculate a prior period cost, so I
can calculate the difference between a total todate cost this month and the
total...
|
July 16th, 2008 09:51 PM
by John
|
6 |
169 |
|
|
|
July 16th, 2008 09:45 PM
by ToniS
|
4 |
120 |
|
|
Criteria issue for limiting a query by
Antavas
I have built a query1 that allows me to enter a date range for when an issue
is opened. I then built another query2 off of that one using these criteria:
...
|
July 16th, 2008 09:43 PM
by Antavas
|
2 |
127 |
|
|
|
July 16th, 2008 09:09 PM
by Todd
|
4 |
143 |
|
|
Math calculation by
Ac
Hi,
I have the Excel work sheet to calculate the data (about 25 columns and 300
rows) that are the data for making a chart in the Excel now. Because the...
|
July 16th, 2008 07:35 PM
by Ac
|
3 |
150 |
|
|
How do you substitue a value for #Error by
Barry
I'm running a query that returns #Error for some rows. I tried to run
iif(iserror(),1,0) but it still returns #Error. I have also tried
isnull, isempty,...
|
July 16th, 2008 06:42 PM
by Barry
|
4 |
135 |
|
|
|
|
3 |
122 |
|
|
insert syntax help required by
vandy
Hi all,
I have a login form were a sysadmin can enter new values into the table.
I need the values entered into the table through the form.
i have 3...
|
|
5 |
129 |