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
How to get query to return total using wildcard by workweek
I have a query that has 3 criterion in it as follows: Business Unit, Location, Category. These criterion are all chosen by the user on a loaded form. ...
March 9th, 2010 09:59 PM
by KARL DEWEY Go to last post
1 173
Iif statement and time format by TDC
I have a table with a time field that displays a long form time (12:00:00 AM) by default. Through a query I want to build a work shift field for grouping...
March 9th, 2010 09:40 PM
by Marshall Barton Go to last post
2 199
How to get a query to call the parameter form by WillyNPG
I am trying to use a form to get query parameter dates as is detailed in the help article "Make a query ask for input" The query does not open the date range...
March 9th, 2010 06:42 PM
by KenSheridan via AccessMonster.com Go to last post
6 325
Getting rid of a Having clause by DawnTreader
Hello I appologize ahead of time... this is going to be nasty... SELECT dbo_CUSTOMER_ORDER.CUSTOMER_ID AS CustID, dbo_CUSTOMER.NAME,...
March 9th, 2010 05:40 PM
by vanderghast Go to last post
1 169
Brain Freeze help with combobox and query by kc-mass
Hi, I have a personnel form with typical personnel data. On the form is an combo that has a data source of employeeID, LastName, First name. The first (0)...
March 9th, 2010 04:59 PM
by Marshall Barton Go to last post
7 254
recursively retrieve records from 2nd table based on records from by elsamiro2351
I have two separate queries, that show the wanted results. I tried hard but i cannot "merge" them into query/subquery. I am not sure if subqueries are the...
March 9th, 2010 02:29 PM
by John Spencer Go to last post
2 160
Nz - need code - by Bibi
I have a crosstab query that yields no value where I need a 0 value for further calculation. I do not write code: This is the SQL for the crosstab....
March 9th, 2010 01:21 PM
by Bibi Go to last post
2 161
Count query by jamccarley
How would I set up this query? All I want to do is count the number of errors on a certain cell in our machining process. I have a field, , all the way...
March 9th, 2010 06:20 AM
by Duane Hookom[_4_] Go to last post
3 204
Subquery with subraction - challenging by clalc
Sorry I repost my question because I think my previous post got burried. I have to subtract a value from one table and calculate the result in another table. ...
March 9th, 2010 03:56 AM
by clalc Go to last post
3 275
My Access query shows blank in the label merge by Club Secretary
When I try to merge the Access query I want into label format, the query shows blank. I can merge the database table with no problem but not my query. What...
March 9th, 2010 12:13 AM
by Jeff Boyce Go to last post
1 146
Stacking Date/Time from Row to Row by Joshua
Hello there. I'm trying to run an update query that will look at a previous row's end date and fill in the same date in the current row's start date. I've...
March 8th, 2010 07:55 PM
by John Spencer Go to last post
3 163
efficient method of finding closest date by specify input value by xmi
can it be specify the input value to the formate with YY-YY, that means let the use to key in 09-10 from the query. and the 09-10 means the date range...
March 8th, 2010 07:35 PM
by KARL DEWEY Go to last post
3 166
Update Query by Iram
Hello, For every record in a table I need to update one of four Yes/No check box fields based upon date span. If the "In Date" is in the same month as...
(Multi-page thread 1 2)
March 8th, 2010 07:26 PM
by John W. Vinson Go to last post
10 312
DateAdd compile error by Kirk P.
Using this formula to subtract 5 hours from a date/time value in tblTIMEZONE. DateAdd("m",-5,!) I'm getting a compile error. The DST_Begin value is stored...
March 8th, 2010 06:07 PM
by Kirk P. Go to last post
1 194
military time by tmecurio
The database field is a date-time field. I want to report it in military time but change the format to 0000 not 00:00
March 8th, 2010 05:42 PM
by Stefan Hoffmann Go to last post
1 188
Can there be too many sub queries within a single query? by Guitarzann
I am trying to combine the results from more than 15 queries into a single query in an attempt to save opening 15 different queries individually. The query...
March 8th, 2010 05:37 PM
by Guitarzann Go to last post
4 181
calculated field - difficult by clalc
I have to make a calculated field in the query where the value from one table is deducted from the value in another table. Is that possible ? Here is the...
(Multi-page thread 1 2)
March 8th, 2010 02:19 PM
by clalc Go to last post
11 496
pictures by raismisuaween
pictures picture pictures of death pictures of pictures
March 8th, 2010 11:17 AM
by raismisuaween Go to last post
0 202
Pass Through Query - not returning rows by Gary Watson
I've written some SQL, which when run on SQL Server 2005 returns rows. Plugged this SQL into an Access 2003 pass through query, but when run it reports an...
March 8th, 2010 10:51 AM
by Stefan Hoffmann Go to last post
1 250
SomeHelpWithSubform by alawagi71 via AccessMonster.com
Hey! I have form with sub form each row in the main form belong to many rows in the child form i want to know how many rows in the subform belong to each row...
March 8th, 2010 07:31 AM
by alawagi71 via AccessMonster.com Go to last post
7 200
Post New Thread


Display Options
Showing threads 941 to 960 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:34 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.