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
Parameter query with and multiple "NOT / OR" selection criteria by Peg Hall
I get incorrect results when I do the following query: Field a = "X" Field b = Not "Y or Not "Z" Field c = Between and
June 1st, 2010 07:00 PM
by KenSheridan via AccessMonster.com Go to last post
2 863
Queries by Sherry
I need help with this , it will not run, am i missing something. Private Sub Worksheet_Activate() Call Sheet5.getvalues Call Sheet5.SortRange1 End...
June 1st, 2010 07:00 PM
by Sherry Go to last post
0 286
Create a Query that Prompts for Date and Time by SSi308
I am in the beginning stages of setting up a call database that tracks calls made by sales people. The table includes separate fields for date and time. A...
June 1st, 2010 03:19 PM
by SSi308 Go to last post
4 561
Query Running Balance by Abdul Shakeel[_2_]
I am using the following query to create running balance at every change of Invoice Number but no luck, here Invoice Number is a text field SELECT...
May 31st, 2010 02:33 PM
by Abdul Shakeel[_2_] Go to last post
4 457
Allen Browne's Has the Rcd been Printed - Taking it further by Dennis
Hi, I'm using Allen Browne's code from Has the Rcd been Printed and all of that is working great. I'm now trying to implement the Taking it Further - Track...
May 31st, 2010 06:36 AM
by Dennis Go to last post
0 282
First and Last Problem by Dan[_33_]
For some reason First and Last are giving the wrong data in a Totals query. I assume that somehow the data is not ordered correctly in the main table, but it...
May 31st, 2010 04:10 AM
by david Go to last post
9 569
Using check boxes to select criteria to run query by Natalie
I need some help. I have 5 check boxes. There is one for each country of Canada UK USA France Germany And i want the users to be able to tick which countries...
May 31st, 2010 01:10 AM
by KenSheridan via AccessMonster.com Go to last post
3 755
Combo Box Query Help by Scott_66701 via AccessMonster.com
I have a combo box with hospital names in it. I am wanting to select a hospital from the combo box and have the the address text box automatically fill in...
May 30th, 2010 08:33 PM
by Tom van Stiphout[_2_] Go to last post
1 435
Query on a subform by Jeffrey Marks
I have a form that displays an outing for members to sign up. There is a subform where I display the members of the organization (via a combo box), using a...
May 30th, 2010 06:23 PM
by KenSheridan via AccessMonster.com Go to last post
3 461
Very difficult query (?) by PayeDoc
Hello I've been struggling with this all day, and although I think I'm near a solution (actually I thought that 2 hours ago!) it now involves 4 nested queries...
May 30th, 2010 05:26 PM
by Dennis Go to last post
9 333
Change colour of a field by DontKnow
Hi Guys, Are you able to change the colour of a field dependant on the fields current value in datasheet view. When the output from a query is opened, I...
May 30th, 2010 09:47 AM
by DontKnow Go to last post
6 310
Translate if statement in query by Jazz
I took both of these if statements from a query in an access database and I am trying to interpret them. New Request: IIf(IsNull(!),0,!) Old Request:...
May 29th, 2010 08:46 PM
by vanderghast Go to last post
1 221
Select Top with aggregate function by Mike P
I have a SQL statement that returns an count and average amount paid for a customer in a table. I wish to alter the SQL so I only get the first X rows...
May 29th, 2010 05:48 PM
by John Spencer Go to last post
1 296
query data from a parent-child table by PieterLinden via AccessMonster.com
grupy wrote: Id like to know how I can query lets say a specific record from a parent-chil table For example, lets say parent table is Products using...
May 28th, 2010 10:47 PM
by PieterLinden via AccessMonster.com Go to last post
0 304
Dropdown choice eliminated from selections by Erinayn
I have a simple scenario... We have a list of 20 items and I'd like people to identify the top 10 to them. I created a dropdown but was wondering if I can...
May 28th, 2010 10:39 PM
by PieterLinden via AccessMonster.com Go to last post
2 259
Query SQL Syntax by Rob Hamlin
I have 2 queries that I am building another query off of. I have on query with the name of project contacts in it. I have another query with all the...
May 28th, 2010 10:15 PM
by KenSheridan via AccessMonster.com Go to last post
3 280
Joining 3 Queries That Count by jjones
I am trying to decipher the “status” of records in my table based on two date fields and the name of the agent assigned to each record. The fields are as...
May 28th, 2010 08:35 PM
by jjones Go to last post
8 400
Count Yes/No for three fields in one column by Marilyn Myers
I work with Access 2007. I have a table with 4 columns: Date Mailed, 2nd, C w/o Inv, and C w/Inv. I can get the monthly totals by grouping on Date Mailed...
May 28th, 2010 06:46 PM
by Daryl S[_2_] Go to last post
2 306
Access 2K2: making numbers up in a query sum by The Dude
Hi all! I am running a query in a subform where I sum a * . Units are imported from a csv file with 3 decimals and operation sign is either -1 or +1: For...
May 28th, 2010 04:46 PM
by John Spencer Go to last post
1 323
unique records Access 2003 by RogerBPWD
Problem: Eliminate duplicate values based on one field and still maintain the availablity of otherfields for the retained record. I sort on date to bring the...
May 28th, 2010 04:32 PM
by John Spencer Go to last post
2 312
Post New Thread

Display Options
Showing threads 61 to 80 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:06 PM.

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