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
Multiple Queries to Multiple Reports by mguffey5
I have a database that tracks cadets that will commission into the military and they are broken into their year groups. My problem is that to generate a...
June 3rd, 2010 03:53 PM
by kc-mass Go to last post
1 902
How can I query a set of dates but exclude non-working days? by Pilgrim72
Hi there, I was hoping that someone might be able to help me. My Access knowledge is at best, rather limited, and I am stuck now and cannot proceed further...
June 3rd, 2010 03:37 PM
by Pilgrim72 Go to last post
0 785
Parameter queries that allow users to choose items from a list by venajoe
Dear Access 2007 VBA Gurus, I have a "Worship Song" database. The tables...
June 3rd, 2010 02:38 PM
by venajoe Go to last post
3 878
2007 Concatenation problems by AllenK
I am using Mr. Hookums formula he gave me for concatenation in Access 2003 and it works fine. As soon as I copy it into 2007 I get error messages. I have...
June 3rd, 2010 01:12 PM
by AllenK Go to last post
2 774
Calculated field question by WembleyBear
I have a query that summarises sales data for a particular month and cost centre. The data comes from our accounting system and is held in a single table in...
June 3rd, 2010 11:53 AM
by WembleyBear Go to last post
2 793
Parameter Query Using Combo Box by PleaseHelpMe
There are no recorsd being returned when i run my parameter query. SELECT TrackingID, DocumentNumber,DocumentType, RequestDate,DueDate, ProgramID,...
June 2nd, 2010 11:09 PM
by PleaseHelpMe Go to last post
6 1,331
Parameters to search between years by sebastico
Hi Everyone, Access 2003. I have a query that I have set up so the user can type in in a txtbox (in a form) the year (string) and the query workks great. This...
June 2nd, 2010 07:45 PM
by sebastico Go to last post
2 746
Has Hierarchy the Parameter between years? by sebastico
Hello Access 2003. I have a query with the following parameters. Like !. & "*" ‘Data are in TAA Like !. & "*" ‘Data are in TBB Like !. & "*" ‘ Data are...
June 2nd, 2010 07:44 PM
by sebastico Go to last post
5 832
SQL Update question by Afrosheen via AccessMonster.com
Good morning, I have 3 fields , , & . Rotation and adn are True/False fields. The printtab is a number field. In stead of having 3 SQL statements, I'd like to...
June 2nd, 2010 05:14 PM
by Afrosheen via AccessMonster.com Go to last post
2 913
Please help with access expression by joe_G
Hello, I was hoping someone could assist with the following expression in access that combines the Left function and Len function: I have column called ID,...
June 2nd, 2010 05:13 PM
by John W. Vinson Go to last post
2 961
Delete records from second table by sebastico
Hello I have two Tables. tblMain(MainID) tblSec(FamID, Group, MainID) MainID has same attribute in both tables tblMain has the correct records. How can I...
June 2nd, 2010 04:06 PM
by sebastico Go to last post
3 841
Last record/entry from a table by Hurrikane4
My table has three columns, AcctNum, TransDate, SeqNum I need a query that only displays the last "SeqNum" when an "AcctNum" had multiple entries on the same...
June 2nd, 2010 03:58 PM
by KARL DEWEY Go to last post
2 646
deduct order quantity from credit limit by klp via AccessMonster.com
I have on my customer master, a field for credit limit. The user can input the credit limit for that particular customer. When the user then goes in to the...
June 2nd, 2010 03:36 PM
by KARL DEWEY Go to last post
1 765
Union Query and Field Alias by SSi308
I have created a union query and now want to create a field alias to specify which records come from which query. The union query works as such: SELECT * FROM...
June 2nd, 2010 03:14 PM
by SSi308 Go to last post
7 925
Free Live Voice and Video Chat!Connect with Over 4 Million Membersdownload now by nisha verma
Free Live Voice and Video Chat!Connect with Over 4 Million Members download now on http://www.tkqlhce.com/click-3714215-10516597
June 2nd, 2010 12:26 PM
by nisha verma Go to last post
0 1,439
convert currency to string by shank
AMOUNT: CStr(!*!) How do I convert $45.50 to "45.50" ...? No matter what I do I keep dropping the zero to "45.5" thanks!
June 2nd, 2010 08:08 AM
by Wolfgang Kais[_4_] Go to last post
1 677
Average time with a single entry by Alejandro
Hello there, i have a form with a query that calculates the average processing time for a event and it works fine when there's been more than one entry. I...
June 2nd, 2010 01:38 AM
by John Spencer Go to last post
2 781
Inventory Loop by Jim
I need a way to loop through an invoice and figure out the number of boxes being used per order. We have the same product that can go into multiple size...
June 2nd, 2010 12:17 AM
by KARL DEWEY Go to last post
2 710
Random Function for Selecting Records by esn
Hi everyone, This should be simple. I'm trying to pull one random record from each group within a table. The groups are "Units" - geographic areas, and I...
June 1st, 2010 08:19 PM
by esn Go to last post
5 1,025
A Great Big Thank You! by Daniel[_20_]
Firstly, let me apologize for making this beautiful cross-post. I know it bad etiquette, but in this instance I'm hoping no one will truly mind (after all...
(Multi-page thread 1 2 3)
June 1st, 2010 07:07 PM
by Albert D. Kallal Go to last post
22 1,914
Post New Thread


Display Options
Showing threads 41 to 60 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:19 PM.


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