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
Query to group similar number combinations? by esn
I'm trying to create a make-table query that will group records by two fields. The fields, named "Left" and "Right," both contain 4-digit identification...
May 14th, 2010 11:55 PM
by esn Go to last post
4 850
Join on a calculated field by accesswanabe
I am trying to provide a SQL query to the rowsource of a combobox. I am trying to use two tables to do this but am not sure how to go about it. The table...
May 14th, 2010 11:29 PM
by accesswanabe Go to last post
5 822
Limiting Records in an Update Query by Amy E. Baggott
I have a report that generates assignment sheets for exhibitors who have received booth assignments so that the orders can be updated (for various reasons,...
May 14th, 2010 09:51 PM
by golfinray Go to last post
5 832
Find Duplicates Query Wizard Question by NFL
After using the duplicate wizard, what is the next step? Do I manually select the records individually and manually delete each one while the query is...
May 14th, 2010 08:46 PM
by golfinray Go to last post
1 794
What does this query error message mean: Cannot open database ". by peter
I get a weird error message when I try to run a make table query, but yet the same query will work as a select query. I know the file isn't currupt, as I've...
May 14th, 2010 08:24 PM
by Bob Barrows Go to last post
2 1,455
Friday's Due Date by RRS
Every Friday, I run an error report which searches for errors with an Audit_Date between last Friday (a week ago) and Thursday (the day before the report is...
May 14th, 2010 07:55 PM
by John W. Vinson Go to last post
3 810
criteria on form by Christina
GOod day I have two queries pulling data from two tables, with criteria between start date and end date. .. I have a third query pulling those results...
May 14th, 2010 07:50 PM
by Amy E. Baggott Go to last post
1 703
filter by Simon L
I have a database that have two fields: Tier and S Tier. There are different values in these fields (e.g. Tier:1, 2, 3, 4... S Tier: 1, 2, 3, NC, DME...)....
May 14th, 2010 05:54 PM
by Simon L Go to last post
4 716
Lag 1 day relationship by Michelle
Sorry if this is a duplicate, but I tried lots of searches here. I can't seem to find my answer anywhere. I have 2 tables that I need to join by date and...
(Multi-page thread 1 2)
May 14th, 2010 05:47 PM
by John W. Vinson Go to last post
11 1,440
Tricky Accounting query - and not sure how to build it by Corey-g via AccessMonster.com
Hi All, Sorry for the 'not so descriptive' subject - but there wasn't enough room to write "Need help with Financial data from multiple tables to follow where...
May 14th, 2010 04:10 PM
by Corey-g via AccessMonster.com Go to last post
2 817
Crosstab column data count by tmb
I have a crosstab query with Well Name as row heading , site visit Dates as column headings (formatted as "yyyy"), and averaged water level measurements data...
May 14th, 2010 03:36 PM
by vanderghast Go to last post
6 905
Default Value-Complicated by Iram
Hello, I have a Module that pulls the username of the person logged into the PC (if you would like to see this code, let me know). I have a table called...
May 14th, 2010 03:01 PM
by PieterLinden via AccessMonster.com Go to last post
1 762
Help with query calculation by Craig McLaughlin[_2_]
I need a calculation to determine holiday pay. I have the total hrs work*5.6/52 is the calcuation I use. HOWEVER if the person works more than 39 hrs a week...
May 14th, 2010 02:32 PM
by Krzysztof Naworyta Go to last post
2 760
query trouble by PieterLinden via AccessMonster.com
SELECT UniqueColor.readname, UniqueColor.colour, UniqueColor.number, First (UniqueColor.height) AS FirstOfheight FROM UniqueColor GROUP BY...
May 14th, 2010 01:50 PM
by PieterLinden via AccessMonster.com Go to last post
0 717
Query null value problem by ffulmer via AccessMonster.com
Hi All, I have created an application that among other tasks will convert currencies into a base currency. The user selects a base currency then enters...
May 14th, 2010 06:54 AM
by ffulmer via AccessMonster.com Go to last post
2 686
If Statements (Nested??) by Warren Phillips
I am trying to accomplish the following in a Microsoft Access 2007 QUERY. I want to evaluate a field called "Cost Type" for the following values and then...
May 14th, 2010 04:09 AM
by Duane Hookom[_4_] Go to last post
7 745
First function returning min by esn
I am analyzing wildlife research data and need to find the record that represents the first time an individual animal was detected in a given year. I thought...
May 13th, 2010 11:31 PM
by esn Go to last post
5 721
REMOVING LEADING ZERO by Jessica
I have loan numbers that consist of all numbers or alphanumeric fields. Not all loan numbers have the same digits, however, they are all formatted to 35...
May 13th, 2010 08:48 PM
by KARL DEWEY Go to last post
2 891
IIF function help in query by Cam
Hello, I have the following field in the query to look at a field PartDesc, if any of the text have a *BUSH* word, return yes, otherwise no. BUSH:...
May 13th, 2010 07:28 PM
by fredg Go to last post
3 781
Query and date selection by Chrissy
I test to see if a reservation begins between 11/15-3/31 of any year. So far I have come up with, for the reservation begin date: Between #11/15/2009# And...
May 13th, 2010 03:07 PM
by Chrissy Go to last post
8 875
Post New Thread


Display Options
Showing threads 201 to 220 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 08:30 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.