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
Limiting a query by Fay Yocum
I have a grant that one staff member's salary comes from. There can only be one staff member that gets paid from that grant at a time. If this person cares for...
May 26th, 2004 12:13 PM
by Michel Walsh Go to last post
1 304
"Fill-in data when there's no data" by Gary Walter
Hi Bob, I have helped several people do similar; it is for sure doable and fairly straightforward.... but I would first like to know how you will be limiting...
May 26th, 2004 11:49 AM
by Gary Walter Go to last post
0 347
more dates!!! by brigid
How is this any different than the current code? -----Original Message----- Hi, .... WHERE myField BETWEEN Nz( Nz( StartDate, EndDate), date() ) ...
May 26th, 2004 10:59 AM
by Michel Walsh Go to last post
6 1,041
Convert data. by Robert
I have a table with phone number that were imported in the following format (212)-555-0440. The field is set to text, with no input masks. I need to convert...
May 26th, 2004 10:56 AM
by ali kwok Go to last post
2 298
three leters abbr for Day of week by gal
Hi group, I have a report that runs totals accompanied with the date and the day of the week. All my days are being displayed with three letter abbreviation...
May 26th, 2004 09:56 AM
by Peter R. Fletcher Go to last post
2 329
Access 2000 SP3 Issues by Paul Lockwood
Hello We have just upgraded all of our machines to Office SP3. Since doing this I am now getting a large number of errors within Access db's. A couple of the...
May 26th, 2004 09:30 AM
by david epsom dot com dot au Go to last post
3 354
Urgent - Problems with grouping Unique values by FJP
I have three tables; tblsalesrep, tblclients, tblgeneral. tblclients references tblsalesrep to show what salesrep is assigned to that particular client,...
May 26th, 2004 09:26 AM
by Nikos Yannacopoulos Go to last post
1 293
Using IIF statement in Memo Field by J Cunningham
Hi, I'm fairly new to Access, and I need to write a query which will check a memo field to see if it is null, then display "n" (for not having data in the...
May 26th, 2004 09:19 AM
by david epsom dot com dot au Go to last post
5 896
Help!! withdrawing materials from a stock. by Chris
In a form, i have a command button with a code like below, which is making a sellection from a query (which represent the current state of a stock) to display...
May 26th, 2004 06:14 AM
by Chris Go to last post
0 290
help with not so simple query by v_roma
I apologize for reposting my question. It's actually a follow-up question, which seems more complicated than the original. Once more, for the sake of...
May 26th, 2004 02:28 AM
by ChrisJ Go to last post
1 294
Delete Record Based on Text Box by James Stephens
I have set this up to work before with one text box, but I am struggling to make it work with 2. Is there a way to make a delete query that will delete any...
May 26th, 2004 12:56 AM
by Duane Hookom Go to last post
1 529
Count Unique Values by AHopper
The following query "SixDifinPackagedUniqueQuery", using fields "JobNumber" and "UniqueLabelPack" from table "SixDifinPackaged" gives me a list of unique...
May 26th, 2004 12:05 AM
by AHopper Go to last post
6 682
ODBC CALL FAILED by bikermike
When we try to run a query that passes a date variable we encounter "ODBC CALL FAILED". This is not happening on all our computers but we can't seem to isolate...
May 25th, 2004 08:58 PM
by John Spencer (MVP) Go to last post
2 734
trouble with query by Gary B
MASTER Table: CHARGES Fields: ChargesKey, ChargesDate DETAIL Table: SERVICES Fields: ServicesKey, ServicesDate, SalesRep I need to return the Count of...
May 25th, 2004 08:25 PM
by John Spencer (MVP) Go to last post
4 355
Excel vs Acess by hermie
How can I implement the Excel COUNTA function in an Access query? herman
May 25th, 2004 07:40 PM
by Michael Hopwood Go to last post
1 286
Extract data by Tony
I'll give it a whirl. Thank you very much John. Tony "John Spencer (MVP)" wrote in message ... ...
May 25th, 2004 07:01 PM
by Tony Go to last post
1 315
Reports from Cross-Tab Queries by Jack
My cross-tab querie now works O.K. when passing parameters via the Query|Parameters route. And, of course, I can print the query results. But I want to do a...
May 25th, 2004 06:42 PM
by Duane Hookom Go to last post
1 437
Text in IIf(,,) expression in query by KaiRich
Hi all, I have four fields, if any of them hold "Y" then I want the query to return "Y" - but I only want one such field in the query. I have tried: EMP:...
May 25th, 2004 06:19 PM
by Ragnar Midtskogen Go to last post
2 319
To: Allen Browne changing date format in query by
Hi Allen. Thanks for your help. In my query, I want to search between two date fields that are formatted dd/mm/yyyy using the date field that is formatted...
May 25th, 2004 06:00 PM
by Allen Browne Go to last post
1 489
add column by Dan
is there a way to add columns in a query for example Loan officer # Loans Dan 2 Ed 3 Frank ...
May 25th, 2004 05:53 PM
by Lynn Trapp Go to last post
1 275
Post New Thread


Display Options
Showing threads 43221 to 43240 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 10:02 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.