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 / Thread Starter Last Post Reverse Sort Order Replies Views
Why is this strSQL not working??? Please Help by Gina Whipp
If I take out the Dlookup part all is well but I really need that Dlookup. Can someone explian why? Const strSQL = "SELECT tblLister.lListerID,...
(Multi-page thread 1 2 3 ... Last Page)
February 28th, 2007 05:29 AM
by Gina Whipp Go to last post
37 2,054
Need query to find employees who have not had required training by insp36rls
I am creating a database to track employee training. I have created 3 tables: my first table is for general employee information, my second is for employee...
February 28th, 2007 05:28 AM
by insp36rls Go to last post
3 270
WHERE by skr
Can somebody please explain how WHERE works and under what circumstances it should be used? I've found that it works for some of the things I want, but I...
February 28th, 2007 01:11 AM
by John Spencer Go to last post
2 166
Office 2000 Access upgrade? by TwylightZone
Can anyone give me a definitive answer as to whether I can use the Access 2007 Upgrade program to upgrade Access that came with the Office 2000?
February 28th, 2007 12:58 AM
by Jeff Boyce Go to last post
1 111
Iif Statement by Leslie
I am trying to get the user to input the policy number if auto assign is set to no. wrkfld1 : Iif( = "No", ) Except I get dialog box "Enter Policy Number"...
(Multi-page thread 1 2)
February 27th, 2007 11:20 PM
by geebee Go to last post
11 316
Update Query Question by Gary Dolliver
Hello, I am wanting to run an update query that will update specific records in a table, and set a certain field to an already existing field, the first one...
February 27th, 2007 11:02 PM
by Gary Dolliver Go to last post
2 156
Building Expressions - DON'T KNOW HOW by Sandi
Ok - so here is my delima - I have an access database and I am using the query feature and need the query to pull out specific information. The problem is...
February 27th, 2007 10:23 PM
by Sandi Go to last post
8 215
iif function in query by skigal
I have an iif function in a query as follows: Gas Jan 06-05: IIf(1,"",IIf(1,"",(-)/)) It appears to be calculating properly but I am not able to format the...
February 27th, 2007 10:12 PM
by John Spencer Go to last post
2 141
Averages by skigal
I have a simple table consisting of 13 columns. The first col is the location and the next 12 are the scores received in each of 12 months, some months have...
February 27th, 2007 10:08 PM
by John Spencer Go to last post
6 123
how do I convert a julian date(JDEdwards) into a calendar date by Tom Fontaine
working with JD Edwards database, all date are stored in Julian Example: 107001 = jan 1 2007 There must be a function or some VBA code that does the...
February 27th, 2007 09:58 PM
by John Spencer Go to last post
4 192
Finding a value then if not found find the value -1 character and by ALEX
I'm not sure if this can be done in a query by creating a function first. Here's an example: I need to find NICKJM in the "HIER" field. If there is none,...
February 27th, 2007 08:53 PM
by Alex Go to last post
6 183
How do I keep a correct sequence in an append query? by Pam
I have a sequence of append queries I run. Each one of them has a descending sort on a numeric field. After I complete the second and subsequent queries,...
February 27th, 2007 08:37 PM
by John W. Vinson Go to last post
1 136
paramter query by JRS
I would like a query where I am prompted (thinking parameter query) for a name such as sally. the names however in the database are merged from many systems...
February 27th, 2007 07:47 PM
by fredg Go to last post
2 144
IIF Statements nested by Todd
Hi, I this statement I wrote. It works for nearly all 7500 records except for a sporatic 1,200! I can't figure out why. Any suggestions? PartInj: IIf( Is...
February 27th, 2007 07:20 PM
by Jason Lepack Go to last post
5 167
Counting the number of occurences in a string by Thuy Pham
I need to count the number of times "back order date changed" is displayed in a field. For example Text field ...
February 27th, 2007 06:55 PM
by Thuy Pham[_2_] Go to last post
4 116
How Can We Have Access Accept Order By Input Param by alee via AccessMonster.com
Hello, I want to be able to pass a string as a parameter to Access SQL query engine within Visual Studio's table adapter editor and have it return a table...
February 27th, 2007 06:49 PM
by alee via AccessMonster.com Go to last post
5 247
Querys by sebastico
How do I export a group of querys into a xls workbook?
February 27th, 2007 06:28 PM
by sebastico Go to last post
2 112
Problems with “DateAdd” by cage4000
Hi all, I am trying to subtract one Weekday from which is a Date field (dd/mm/yy), but it will only subtract 1 day in general, it will not remove the...
February 27th, 2007 06:00 PM
by Jerry Whittle Go to last post
2 139
how to make "update"query? by Fuzuy
I wondered what kind of query I have to use( or what steps or others I should do) to update a field which not only retain whatever it has already had and...
February 27th, 2007 05:31 PM
by Michel Walsh Go to last post
1 124
Need Help with Comparing Tables!!! by TotallyConfused
I had posted regarding this problem. Have not had a response that works. Last response almost worked except it was not overwriting correctly. Thought I...
February 27th, 2007 05:28 PM
by Michel Walsh Go to last post
3 140
Post New Thread


Display Options
Showing threads 19821 to 19840 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 09:55 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.