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 Replies Reverse Sort Order Views
select query by talktobatchu
Hello I'm using a select query in VBA to retrieve a set of rows by enterning the begining year and ending year by using a 'Between' keyword. When I run the...
September 20th, 2004 10:01 PM
by talktobatchu Go to last post
2 120
delete query by tom
How do I write a query that will delete all rows in a table where the date column is greater than 30 days old? Thanks in advance! Tom
September 23rd, 2004 12:40 AM
by John Spencer (MVP) Go to last post
2 153
Criteria in a query by Krish
In a select query I have added a criteria to a field as . If no department is entered in the box that is prompted, I get no results. How do I make the query to...
September 23rd, 2004 04:44 PM
by fredg Go to last post
2 113
Criteria using DateDiff function in SELECT Query. by EricB
I have a query that used te DateDiff function. The purpose of the query is to show the records that are older then 30 days up until 120 days. I'm using this...
September 24th, 2004 08:36 AM
by EricB Go to last post
2 375
MakeTable Query -- Field Must be "Double" vs. "Decimal" by Tom
In a "MakeTable" query, I use an expression that calculates the following (sample): Total: (*0.6+*0.4) When I execute the query, field "Total" always becomes...
September 23rd, 2004 06:44 PM
by Tom Go to last post
2 250
Running Param Qry from Form; not filtering... by Lorian
I'm running a parameter query from a control on a form, with the form setting 9 parameters. I've got the query running beautifully when I run it without the...
September 23rd, 2004 10:43 PM
by Lorian Go to last post
2 148
'Un-Crosstab' by colin ashley
I have a table that shows the jobs that people carry out. The column headings are person ID's, and the row headings are job ID's. An 'x' at an intersection...
September 26th, 2004 07:40 AM
by colin ashley Go to last post
2 211
Union query duplicates by SHIPP
I am creating a union query. It seems that Access removes items from the result where all fields are duplicates of another record. I want the duplicates...
September 24th, 2004 05:02 PM
by SHIPP Go to last post
2 128
How do I set up Date query in a crosstab query? by Doddysgirl
I have set up a crosstab query that works fine. I now want to have the user enter the beginning and ending dates for this query. I am unable to make this...
September 24th, 2004 08:20 PM
by MGFoster Go to last post
2 358
Using Current date information by MTRacer
I am looking for a way to tell a query to check the current day of the week then assign a number. For example: Currently, my data is driven by a 'data date'....
September 22nd, 2004 08:29 PM
by James Cox Go to last post
2 324
repost - 'Undefined function' and 'Too complex' errors by Lorian
2 questions: 1. I created a parameter query that prompts the user for up to 7 different parameters, and set it up so that if the user leaves any of the...
September 23rd, 2004 05:51 PM
by Lorian Go to last post
2 260
how to select only max date by Ben
Hi all, I have a table with structure like: date ID status 09-01-2004 001 active 09-05-2004 001 ...
September 23rd, 2004 08:49 PM
by Ben Go to last post
2 123
Check constraints spanning multiple tables by markeboy
I understood this feature wa introduced in Jet 4.0 but I cannot get this to work. I want to ensure that a foriegn key being entered matches an entry...
September 22nd, 2004 12:19 AM
by markeboy Go to last post
2 225
Confirm Action Query by Nick
When I start up my database I would like to stop the Confirmation of action queries. I know how to do this using options but others users use the database...
September 21st, 2004 03:09 AM
by Nick Go to last post
2 224
Number of days in a given month by Hallgeir
Is there a (easy) way to find the number of days in a month if I have the date. Example: If the date field is 08.10.04, I want the Daysinmonth field to show...
September 21st, 2004 04:30 PM
by Allen Browne Go to last post
2 242
Design Grid not visible by Mike
After checking the scroll bars (only viewable one is on the right and none are viewable on the bottom), trying all combinations of window maximizing /...
September 21st, 2004 09:12 PM
by Go to last post
2 113
Count Unique Records - from a Newbie (Repost) by RFJ
I've got a simple query where I can't get the syntax right. The aim is to report each unique organisation name once only - but the following code shows...
September 21st, 2004 10:15 PM
by John Vinson Go to last post
2 261
COUNT multiple fields by Shanin
I keep having problems with this type of query when I get more than two items, so I don't know if it's possible. I would really like to make a query that...
September 23rd, 2004 02:11 PM
by Shanin Go to last post
2 202
Blank Space to Zero by Chris
I have read many posts on converting a blank space to zero but cannot seem to make it work. Here is the sql statement from my query, any suggestions. SELECT...
September 22nd, 2004 05:49 PM
by Chris Go to last post
2 174
auto numbering in query by [email protected]
I need to start my auto number with a specific number, how do I do that? Thanks
September 24th, 2004 11:16 PM
by MarkD Go to last post
2 287
Post New Thread


Display Options
Showing threads 20001 to 20020 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 04:28 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.