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
Queries adding Zeroes by Rob
hi, i have a table which keeps track of lawyer membership in different sections (i.e. criminal law, civil law, etc.) by having their section dues (in a...
July 9th, 2004 01:55 AM
by John Spencer (MVP) Go to last post
2 418
using DLookup() to obtain a total from a group of records in a related table by Paul James
I've got two related tables - tblInvoice and tblDetail which are related by InvoiceID fields in each table. The Amount field is in tblDetail. I've got a...
July 9th, 2004 02:00 AM
by Paul James Go to last post
5 667
Update query by 1/2 entered number by Eb1mom
Two update queries. Number fields are being updated. Query is simply + A popup comes up and user enters number to be added. In second update query the...
July 9th, 2004 02:07 AM
by eb1mom Go to last post
2 756
Summarise groups of data by damien
I've got some data which looks a bit like this: row_id user sick day sick...
July 9th, 2004 02:08 AM
by John Spencer (MVP) Go to last post
3 199
Dates range within Date range by Deanne
I am currently trying to write an expression that flags whether a specific date range occurs within a certain date range. This will enable me to calculate the...
July 9th, 2004 02:09 AM
by Dale Fye Go to last post
3 518
todays date by rml
I'm trying to run a query based on todays date. What is the syntax for today in the criteria line. Thanks.
July 9th, 2004 02:12 AM
by Dale Fye Go to last post
1 139
Multiple results in a querie by Paula
I have an employee data base that has separate fields for different eligibility dates for our various benefits. I want to set up a querie/report that will...
July 9th, 2004 02:20 AM
by Dale Fye Go to last post
1 142
Missing records by AdmSteck
I have a query in which I am trying to pull the total misset parts for each month for each part. Here is the query I have: SELECT Parts.ID, Parts., Parts.,...
July 9th, 2004 02:59 AM
by Dale Fye Go to last post
1 273
sql time formatting by dp
hey guys, trying very hard to format a time for an update query (without date part) I have this so far: Format$(strTime,"\#hh\:nn\:ss ampm\#") Isnt there...
July 9th, 2004 03:05 AM
by Dale Fye Go to last post
2 158
Works in the Query - Why can't my filter do it?? by Tim
I have a query that Pulls 5 separate tables together. Table A has the major portion of data, and the Primary Key = to all the other Primary Keys. I bring 2...
July 9th, 2004 03:07 AM
by Dale Fye Go to last post
6 247
Minimum Value of three fields by Denise
I am trying to get the minimum value of three fields and cannot get it to work like excel. In the query, I tried using FieldName: Min(++. Does anyone know...
July 9th, 2004 03:15 AM
by Dale Fye Go to last post
2 127
Saving Query Closes Access by Martin
I have made a small change to a complex query. The query runs ok. However, when I try to save it, MS Access just shuts down. The query is not saved. The query...
July 9th, 2004 04:22 AM
by Martin Go to last post
2 427
Crosstab Combine by Jeremy Noland
Here is the SQL for my Crosstab : TRANSFORM IIf(IsNull(Count()),0,Count()) AS DaVal SELECT Background_Table.Country FROM Background_Table,...
July 9th, 2004 06:29 AM
by Eric Cárdenas [MSFT] Go to last post
1 155
Mutiple Condition Expression by GLS
Hi I work in a hospital and have a table of patient data including two columns - one showing the date the patient was referred and another showing how...
July 9th, 2004 08:54 AM
by GLS Go to last post
2 223
Error on Select Query by Leif
I'm trying to do a select query that has 36 fields and 18 comparisons in the WHERE clause. When I run the query I get the message: "The Microsoft Jet...
July 9th, 2004 11:37 AM
by Michel Walsh Go to last post
1 338
Is it possible to generate a PRODUCT like in Excel? by Chris
Hi, I would like to create a product as a summary - but there seems to be no product function. I toyed with the idea of using logarithms, but sadly there is no...
July 9th, 2004 01:12 PM
by Chris Go to last post
2 214
Subquery problem by Bruce
Having difficulty getting sub queries to work. I have 3 fields ASXCode, ImportDate and Close. The result should select 1 result. First I want to select a date...
July 9th, 2004 02:28 PM
by Brian Camire Go to last post
6 215
QUERY DESIGNED TO MATCH MULTIPE QUESTIONS FOR A NUMBER OUTPUT by Joe Richardson
Good Morning, I NEED HELP. I have a survey form designed and field out by 712 people. The consist of check boxes for either yes/no answers or multiple...
(Multi-page thread 1 2)
July 9th, 2004 03:11 PM
by Duane Hookom Go to last post
12 769
DH Query by Form by CS
I pulled in the "applet" from Duane Hookoms link on Rogers Access Library and I'm impressed but I ran into a little problem with calculated fields in that they...
July 9th, 2004 04:33 PM
by CS Go to last post
4 166
Query a memo field by Jana
I would like to run a query on a memo field that will show all occurrences of one word in the field. Is there anyway to do that. Jana
July 9th, 2004 04:36 PM
by Go to last post
3 403
Post New Thread


Display Options
Showing threads 1001 to 1020 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 05:05 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.