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
Iif then statement needed for Access 2007 please by Heather
Hi all, I'm trying to figure out how to write an Iif Then statement in access 2007 for: iif columnZ = 10 then columnZ = A please help, SQL and query table...
December 27th, 2009 03:00 PM
by bhicks11 via AccessMonster.com Go to last post
9 303
Unique Query in not working correctly ... too complex? by BobC[_6_]
I have 4 linked tables in Access 2007. 3 fo the tables contain a notes field (SiteNotes, GroupNotes and EquipmentNotes. I want to create a report that...
December 27th, 2009 05:00 AM
by BobC[_6_] Go to last post
2 188
New User, having problems with DLookup by Phelonia
First of all, this is the first time I have tried using Access, let alone trying to build a database from scratch, so if I've made a ton of mistakes, please...
December 27th, 2009 01:32 AM
by John W. Vinson Go to last post
3 186
revers minus by mh_amri[_2_]
hi guyz,we have little office and want to make some regular thing machinary here it is: we sell stuffs(for example think us as a newspaper company) , we give...
December 26th, 2009 09:08 PM
by Bob Barrows Go to last post
1 211
revers minus by mh_amri
hi guyz,we have little office and want to make some regular thing machinary here it is: we sell stuffs(for example think us as a newspaper company) , we give...
December 26th, 2009 04:46 PM
by mh_amri Go to last post
1 208
Query records late to me by AL Rios
I need urgent help.. I have two fields in my query. They are : -Duecor (date field) -Recdate (date field) I need to know when the records were sent late....
December 26th, 2009 03:28 AM
by AL Rios Go to last post
2 210
Transfer data between Access 2003 & 2007; Data does not show on formheader by zufie
Hi had 2 questions: 1)What is the best way to transfer data that was entered into an MS Access 2003 database by using Access 2007?! (User opened her Access...
December 25th, 2009 12:38 PM
by yaghoub ghavami Go to last post
2 240
access 2007 use the old query builder format by Granpa _rb
Is it possible to use the query wizard builder format to edit existing queries in stead of the SQL format, if so how is it enabled
December 24th, 2009 06:38 PM
by Bob Barrows Go to last post
1 259
search with multi values and get resaults order by yuvalbra[_2_]
I work with access 2003 i used the select queries for exampels select * from tbl where a=val1 or a=val2 or a=val3 i want to get the resalus with this order *...
December 24th, 2009 01:10 PM
by yuvalbra via AccessMonster.com Go to last post
5 200
Multi-level Group By Clause is not allowed in a subquery by DaveF[_3_]
I have the following subquery: SELECT coin.coin , coin.size & " " & coin.coin AS CoinSize , coin.troyounces , inventory.mintyear , inventory.totalcost...
December 24th, 2009 04:04 AM
by DaveF[_3_] Go to last post
4 204
All Tables as Queries? by lettyg
Should all of my tables (except for Lookup Tables) be stored as queries?
December 23rd, 2009 10:25 PM
by Jeff Boyce Go to last post
3 194
TreeView Query and or Queries Question by Russ via AccessMonster.com
Trying to use treeview (not sure how many queries I need Or how to accomplish this) My goal is to filter a datasheet form based on my tblAssets...
December 23rd, 2009 10:11 PM
by Rob Parker[_3_] Go to last post
2 215
query to find when an event happened by Bob H[_4_]
I have 12 years of weather data in one table, and have queries to give me total rainfalls between different dates etc, as well as max and min...
December 23rd, 2009 09:14 PM
by Bob H[_4_] Go to last post
5 209
Checkbook Register by Edd[_2_]
I am trying to create a checkbook register with running balance in the query in Access I have spent hours and hours researching this with...
December 23rd, 2009 08:32 PM
by Bob Barrows Go to last post
5 181
Need specific record in report by Mary Beth[_2_]
I have inherited a Nurse Assessment database and am trying to add the feature of attaching a report to an email when the Assesment date field has been filled...
December 23rd, 2009 07:54 PM
by Mary Beth[_2_] Go to last post
4 180
Comparing Crosstab queries by Russell P
I have multiple crosstab queries that have identical formats. The crosstabs are labled Carrier1, Carrier2, Carrier3, Carrier4. The rows represent states...
December 23rd, 2009 07:07 PM
by John Spencer Go to last post
4 193
error 3061 with insert into sql by chanu
i have the following function. Public Function sqltest( ) Dim strSQL As String strSQL = "INSERT INTO " & _ "SELECT 1 AS EmpSerialID ,"...
December 23rd, 2009 06:48 PM
by Access infant Go to last post
6 248
DoCmd.RunSQL HELP!!! I will not work! by Peter
Hi all, I'm quite new to Access VBA (normally only work in Excel VBA). I was hoping the below code would return a SELECT query... Could anyone tell me why...
December 23rd, 2009 06:19 PM
by Gina Whipp Go to last post
1 183
Finding the largest size in a group by compsci610
I have a query that I am trying to find the largest number in a grouping within a list . My data is as follows 857A046613 857A086613 857A166613 What I need...
December 23rd, 2009 05:22 PM
by compsci610 Go to last post
2 178
Creating Multiple Records from Single Delimited Field by MSJ
I am working with some data that lists Supervisor Hierarchy in a Pipe Delimited format and I want to be able to have it show in a query based on each level of...
December 23rd, 2009 04:15 PM
by Duane Hookom Go to last post
1 226
Post New Thread


Display Options
Showing threads 1841 to 1860 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 11:24 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.