A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
#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 Go to last post
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...
April 27th, 2010 03:33 AM
by John W. Vinson Go to last post
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 Go to last post
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...
March 31st, 2009 11:00 PM
by KARL DEWEY Go to last post
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...
April 23rd, 2010 06:03 PM
by KARL DEWEY Go to last post
1 167
$ 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...
September 11th, 2007 04:42 PM
by Jeff Boyce Go to last post
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...
May 13th, 2008 11:55 PM
by [email protected] Go to last post
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...
December 10th, 2008 07:52 PM
by Michel Walsh Go to last post
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 Go to last post
2 100
% 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...
October 10th, 2007 12:08 AM
by KARL DEWEY Go to last post
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...
January 13th, 2009 02:58 AM
by Marshall Barton Go to last post
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...
October 18th, 2005 12:41 PM
by John Spencer Go to last post
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...
April 2nd, 2007 01:49 PM
by MurdocUK via AccessMonster.com Go to last post
6 140
% sign in access by Dodzie99
Does access accepts the "%" sign for missing values in a query?
October 29th, 2008 03:49 PM
by KARL DEWEY Go to last post
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...
(Multi-page thread 1 2)
February 23rd, 2009 12:17 AM
by John W. Vinson Go to last post
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...
November 26th, 2008 03:16 PM
by Michel Walsh Go to last post
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 Go to last post
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...
May 31st, 2006 09:05 AM
by Jonathan Go to last post
4 121
=(Now()-1) by Novice2000
What does this mean in criteria for date? Thanks
August 25th, 2008 09:56 PM
by fredg Go to last post
1 114
=Format(Date(), "mm yy") does not display monthly data? by Paul Casavant
I am trying to get my query to compile our current monthly pass rates. The above Criteria does help in displaying pass rates on an associated report, but they...
December 14th, 2005 12:11 PM
by Paul Casavant Go to last post
3 182
Post New Thread


Display Options
Showing threads 121 to 140 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:28 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.