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 326
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 324
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 341
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 303
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 883
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 345
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 269
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 258
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 637
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 252
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 412
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 323
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 286
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 269
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 287
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 256
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 254
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 461
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 342
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 316
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:57 PM.


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