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
Pass-Through Query / Multiple ODBC Connections by Tyro[_3_]
When creating a Pass-Through Query, is there a way to create two or more “ODBC Connect Str”s in the Property Sheet? ODBC;DSN=DMH_Hub;Description=DMH_Hub...
November 24th, 2009 11:38 PM
by Douglas J. Steele[_3_] Go to last post
1 197
Convert datatype using query by ReneeD
I have create a query which combines two tables; ASSETS and UNITINFO. The UNITINFO table is linked from another database and the ASSETS table has a field...
November 24th, 2009 11:36 PM
by Ken Snell Go to last post
7 286
This should be easy but.... by wftech
I am Brand new at Access but I can't seem to make a seemingly simple task work, A Simple sign out system, I have 3 Data bases, STUDLIST, EQUIPINV, and...
November 24th, 2009 10:47 PM
by KARL DEWEY Go to last post
3 156
can't save modified query by Phil Smith
I have this query: SELECT item_types.name AS Type, SellableItemsList.item_id, item.short_desc, IsNull(!) AS Blank FROM item_types INNER JOIN (item INNER JOIN...
November 24th, 2009 10:01 PM
by Phil Smith Go to last post
2 124
Grouping results by IgorM[_2_]
Hi How can I query a table with the following data: CreditorName, CreditorID, Value so the date is summed up by Value (there are multiple entries for one...
November 24th, 2009 08:50 PM
by Dale Fye Go to last post
3 204
Records with null values aren't being returned by Lorna_Jane[_2_]
Hello, Newbie here. I am querying a one to one relationship, each record from table 1 has one or no related records from table 2. I want those records with...
November 24th, 2009 08:17 PM
by Lorna_Jane[_2_] Go to last post
5 172
Survey Qustion by dsmith via AccessMonster.com
I'm working on a survey database but I 've run into a problem. The series of questions I'm asking will all have 1 of 3 possible answers; yes, no, or NA. I'm...
November 24th, 2009 07:10 PM
by Dale Fye Go to last post
3 211
IIF in Select Query by jrizzo77
Trying to use the IIF expression in conjunction with a combo box in a form. Combo Box: Blue Red Green Blue/Red In the query I want the results to filter the...
November 24th, 2009 06:35 PM
by jrizzo77 Go to last post
3 177
A Team Required for an update query by Rivers
Ok peeps my head hurts and its seriously taxing my time and patience i think its time for the A Team lol (A=Access) ok heres my issue. im creating a...
November 24th, 2009 04:17 PM
by vanderghast Go to last post
1 167
Evaluate Yes/No Field Based on User Input by Dana F. Brewer[_2_]
Hi. I have a field that is set to Yes/No. I want to ask the user a question and based on their response (whether they type yes or no) I want the query to...
November 24th, 2009 04:00 PM
by John Spencer Go to last post
7 277
Append Union Queries by Steph_canoe[_2_]
Hello, I'm creating reports using multiple append queries to add data to a table which I export in Excel and send over to customers. My table has 16 fields...
November 24th, 2009 03:10 PM
by Rob Wills Go to last post
2 175
MID Function by ACarella
I have the following R23/24/25/26 - the then there is a text phrase R23 - then there is a text phrase R101/34/56 - then another text phrase I am trying to...
November 23rd, 2009 11:59 PM
by KARL DEWEY Go to last post
1 167
Running Total by mahmad
Hi, I would like to be able to have a running total for the month. date sales 10/11/2009 100 11/11/2009 ...
November 23rd, 2009 11:04 PM
by vanderghast Go to last post
2 210
3-Tier Crosstab Report by DT
I need to create a query which when completed will popluate a report that has a 3-tiered column layout. I have multiple Stations (numbered text field like:...
November 23rd, 2009 10:39 PM
by KARL DEWEY Go to last post
1 137
Using combo box(s) to create a query by Repent
I have a two part question as follows: 1st part: I am wanting to create a query that is driven by the user selecting a value from a combo box on a form. the...
November 23rd, 2009 09:28 PM
by Repent Go to last post
0 142
microsoft access by AB1
I have a field called the calcel date. It is either blank or have a date in it. I need to produce a query (which leads to a report) that would exclude any...
November 23rd, 2009 09:27 PM
by John Spencer Go to last post
1 158
Can I use an IIF statement with the NZ function? by Marge
I have an Employee Roster database; one of the tables tracks up to 9 promotions, transfers, reassignments, etc. (called "Movements"), and their related dates...
November 23rd, 2009 09:23 PM
by Jeff Boyce Go to last post
2 155
Salary Commissions by Llerfold
Employee Commission - I cannot get all 3 formulas to work. PAYROLL SUMMARY TOTAL SALES FOR THE MONTH 27,000.00 PRODUCTION BONUS LEVEL ...
November 23rd, 2009 07:35 PM
by vanderghast Go to last post
1 130
Conditional query question by h2fcell
I can tell I had a rough week-end because my brain isn’t working today. I have the below query with a one to many join. SELECT...
November 23rd, 2009 07:26 PM
by h2fcell Go to last post
4 173
Need an Expert... Update with a DMAX by Rivers
Ok peeps my head hurts and its seriously taxing my time and patience i think its time for the A Team lol (A=Access) ok heres my issue. im creating a...
November 23rd, 2009 07:17 PM
by John Spencer Go to last post
1 143
Post New Thread


Display Options
Showing threads 2201 to 2220 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:03 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.