|
|
#name?/ deleted record error by
Pogue Mahone
I've used a database for a year, many users adding info to it. I've written
many queries and they've worked beautifully. This week I've been getting a
"record...
|
September 10th, 2005 06:56 PM
by Ofer
|
3 |
115 |
|
|
#num! by
joemeshuggah
is there a way to get around this?? i have an access database that is set up
with a link to a text file that is created via teradata sql assistant. this...
|
|
5 |
205 |
|
|
#num! by
DDBeards
I am trying to null out any field that a #num! appears in. I have tried all
the solutions posted so far and can find none to help. The fields are date...
|
September 13th, 2006 05:33 PM
by Rob
|
1 |
85 |
|
|
#Num! displayed in a control by
zufie
I see #Num! displayed in a control ( in a textbox of a subform).
What can I do to avoid this error?
Do I need to add =IIf(=0,0, to the
beginning of the...
|
|
1 |
113 |
|
|
#Num! in Link File by
Mike
I am trying to link an excel file into my database. However when it is
finished linking, I have #Num! throughout the file. Certain fields in the
file contain...
|
|
1 |
184 |
|
|
$ and decimals in calculation by
troublecat12
I have a calculation in a query based on currency in my table. However, the
results show up without a $ symbol or the two decimal places I have in my
table...
|
|
1 |
91 |
|
|
$ Complex Access Query by
[email protected]
I would be happy to pay $50 via Paypal to the first person to
successfully answer my question.
I am using Access 2003 and Excel 2003 (I'm hoping to be able to...
|
|
4 |
196 |
|
|
% of callers repeat/unique by
Al
I currently have a query that I use to review individuals who've called more
than once within a month (based on a few criteria, but most importantly a
field...
|
|
1 |
78 |
|
|
% of Orders that fall into discreet ranges by
JJP
I would like to know what percentage of orders in my database fall into
discreet price ranges. i.e. 0 to 10K, 10-25K, etc.
I have been able to set up formulas...
|
July 26th, 2008 07:49 AM
by JJP
|
2 |
101 |
|
|
% of total by
Chad
I have a crosstab query that return the number of members by membership type
in each region (see below):
TRANSFORM Count(tblCustomerData.) AS
SELECT...
|
|
1 |
115 |
|
|
% of total needed by
christine t.
I need to add a field showing the % of total. The table looks like this:
Company Name Category Type Paid Amount % of Total Paid Amount
Armstrong...
|
|
2 |
92 |
|
|
% Query by
T Horner
I have a table with thirty-five fields. Thirty of those fields only have two
possible options. I have another field that has a list of thirty
entries(CTM's). I...
|
|
1 |
119 |
|
|
% query based on dates. by
MurdocUK
Hi,
I need to run a query to find out % of site visits made within 10 days of
receipt of a case. Both fields are of the date type and the site visit...
|
|
6 |
140 |
|
|
% sign in access by
Dodzie99
Does access accepts the "%" sign for missing values in a query?
|
|
2 |
72 |
|
|
%USERPROFILE% in Command line by
KPR
Hi,
I'm trying to create a generic shortcut to open an Access database located
on each of our network users desktops. What I'm trying is below and I can't...
( 1 2)
|
|
11 |
155 |
|
|
and by
Slipps
Hi Anyone
I am trying to build an IIf formulain access with a true if a number is more
than 99 but less than 200. Everytime it comes back that I am missing...
|
|
5 |
118 |
|
|
AVG by
Octet32
Im try to find out which stuents had a greater then avg grade how do i write
this?
I tryed the below no luck.
SELECT studentname
FROM students
WHERE...
|
October 19th, 2007 06:54 PM
by Octet32
|
3 |
91 |
|
|
Change data source by
Jonathan
Hi, I have set up a bunch of queries linked to a test data source. I now want
to change the data source to the live data source.
What are the steps that I...
|
|
4 |
121 |
|
|
=(Now()-1) by
Novice2000
What does this mean in criteria for date? Thanks
|
August 25th, 2008 09:56 PM
by fredg
|
1 |
114 |
|
|
|
|
3 |
182 |