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
SELECT Statement Question by Robin
Table: Description: One row per email sent in by a student. Emails are feedback on the course they are taking. Columns: = class they are taking =...
January 18th, 2010 05:14 AM
by Clifford Bass via AccessMonster.com Go to last post
8 264
append query for dates and hour by Ian
I need to create a table filled with the followin data HOURID DATE HOUR 1 Jan 1 06 1 2 Jan 1 06 2 ...... ...
January 18th, 2010 03:28 AM
by John W. Vinson Go to last post
4 177
SQL help requested by cinnie
hello gurus I'm a volunteer with a sports club that hires many students on a part-time basis. I'm really struggling with some SQL used in their payroll...
January 18th, 2010 02:40 AM
by cinnie Go to last post
2 152
MVPs out in force by Dale Fye
Looks like the MVPs have been out in force lately. You guys have been so hot on answering questions the last couple of days that there have not been many...
January 18th, 2010 02:06 AM
by david Go to last post
8 407
making SQL the source for a report? by Howard
I am currently rewriting a big database from using things like DoCmd.OpenReport "Rpt_Y10_A2C_movement_by_student", acViewPreview, where the report's data...
January 18th, 2010 02:02 AM
by Duane Hookom Go to last post
5 156
Access date in 1 field and day in another by George
I have a Form that allows me to enter the date in one field and the day of the week (as a 3 letter day) into another field. I want to have the day computed...
January 17th, 2010 10:19 PM
by John W. Vinson Go to last post
3 115
Combobox for criteria help by [email protected]
Hi everyone, I realise this is probably on here somewhere but I can't find it. I am basically trying to run a query from a combobox selection on a form. Here...
January 17th, 2010 09:52 PM
by Dale Fye Go to last post
5 261
qryRandom by Teddy
I am creating a query called qryRandom I want it to display one random record from tblRandom, each time I execute it. Do you know what I need to do with...
January 17th, 2010 09:35 PM
by Marshall Barton Go to last post
1 157
Variable as FieldName to populate a combobox by Matt Shiells-Jones
OKay - this is probably really reall easy but I cannot for the life of me figure it out... I have 3 tables that I want to cross reference (sort of) - Table...
January 17th, 2010 09:02 PM
by Duane Hookom Go to last post
1 178
Subquery help PLEASE! :P by Accessor
Hi all. I'm about to throw in the towel on this subquery. I've checked it and rechecked it. OK, as an overview, I have two tables, one of names of industries...
January 17th, 2010 05:00 PM
by John Spencer Go to last post
2 180
Prior 3 Mo Avg Function by cru
I am trying to find easier way to calculate prior 3 mo average. Currently, I am doing the manual calculation in Excel after importing from Access. I would...
January 17th, 2010 08:14 AM
by Allen Browne Go to last post
1 176
How do I left justify a date by DavidSherwood
I have a date with format 'yyyy mmmm'. I would like it left justified. The help says I can use ! but when I type '!yyyy mmmm', Access changes it to '!"yyyy...
January 17th, 2010 05:24 AM
by KARL DEWEY Go to last post
9 213
Duplicate Queries by Tom
I am using Access 2007 query wizards to do the following, but seem to be unable to take it one step further. In the Wizard, I identify 3 columns if they are...
January 17th, 2010 01:40 AM
by Sylvain Lafontaine[_2_] Go to last post
5 189
Compare data that do not exactly match by ModernGIS
I am in the process of comparing data from (2) different databases to find differences in the same type of data. Example: I have customer names in one system...
January 16th, 2010 09:54 PM
by Wilpeter Go to last post
3 130
Setting a Month Criteria by Ken Hudson
I have a table (tblData) with dates as one of the fields. I have another "control" table (tblControl) into which I have recorded a date, e.g. 12/31/09. In a...
(Multi-page thread 1 2)
January 16th, 2010 09:15 PM
by John W. Vinson Go to last post
10 183
Query to look for unused data by Russ via AccessMonster.com
I have a product table "tblProducts" with field named "productcatID" that is linked to the "tblCategories" via the category id, how can I make a query...
January 16th, 2010 04:32 PM
by Marshall Barton Go to last post
1 178
too complex query by Barb
hello I'm using Access 2003 SP3 and here is my query based on single table PARAMETERS StartDate DateTime, EndDate DateTime; SELECT...
January 16th, 2010 02:01 AM
by Allen Browne Go to last post
5 293
multiple records from one by SuzyQ
I have a table that has an activity with a related table with start dates and end dates for a particular category of activity such as planning phase,...
January 16th, 2010 01:55 AM
by Allen Browne Go to last post
1 136
Formatting Help - Query Result for "Range" by LisaInAz
Team - I really need a suggestion. I am importing the following query result into an excel sheet (that is the media the customer wants). Below is sample of...
January 15th, 2010 11:08 PM
by Pendragon Go to last post
3 141
subtrscting 2 different columns from 2 tables by rzaxl
I have 2 tables that are joined together on a one to one basis by the primary/foreign key. Both tables consist of an integer field called wkno as well as...
January 15th, 2010 09:12 PM
by KARL DEWEY Go to last post
3 118
Post New Thread


Display Options
Showing threads 1601 to 1620 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:24 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.