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 Views Reverse Sort Order
an ALIAS question? by cinnie
hello gurus I have a Report based on the Cross Tab query shown below: TRANSFORM Count(qryEmp.SiteID) AS CountOfSiteID SELECT qryEmp.SiteName,...
March 22nd, 2010 05:41 PM
by cinnie Go to last post
3 321
Concatenate multiple rows Into one Unique Identifier by garvic82
I need to concatenate multiple rows into one unique identifier. So, my unique identifier is #id. The number of multiple rows can vary for each #id and each...
February 16th, 2010 10:35 PM
by John W. Vinson Go to last post
1 321
Criteria for a Select Query by Chris
I have a table that I am trying to match up the Last Name, First Name, and Date of Birth to another table . I have created join properties for those three...
October 26th, 2009 09:39 PM
by Duane Hookom Go to last post
9 321
parameter with iif statement in query criteria by Doug Glancy
Win XP Access 2003 In a select query, I want the criteria to be "Is Not Null" if the parameter is left blank and for the query to not filter on that field. ...
(Multi-page thread 1 2)
February 10th, 2010 08:23 AM
by Jose Penate Go to last post
10 321
¯äsite¤@*Ó by weeed
¼ìÄê¤ý, ¦ÊÅܬP§g, r102030r, ¥§¶ø·s¤B 4 ±ø¥´¹v¥J.
May 31st, 2005 03:56 PM
by weeed Go to last post
0 320
1 Attachment(s) printing "blank" pages by John
Hi I need to print "blank" invoices with invoice numbers only at the top. I have a table full of invoice numbers which I am using as the record source for the...
(Multi-page thread 1 2)
July 6th, 2005 02:10 AM
by John Go to last post
15 320
I need update query to run from combo box by Bill_De
In my application I have a form with a combo box. What I want to do is select an item from the combo box and have that item removed without deleting it from...
(Multi-page thread 1 2)
August 12th, 2005 04:53 AM
by Marshall Barton Go to last post
15 320
How to join 2 Access tables to return ALL records from both tables by JER
Newbie to posting questions! I have two tables and have defined my relationships. In my query, I want to return ALL data from BOTH tables. How can I do this?...
January 12th, 2006 01:28 AM
by Tom Ellison Go to last post
4 320
show Count of "empty" records by GillWeb
Hi I'm compiling a simple database to analyse responses to a questionnaire, most of which are multiple choice responses. I need to be able to have queries...
(Multi-page thread 1 2 3)
June 20th, 2007 12:37 AM
by KevinT Go to last post
24 320
Concatenation Problem by robastyk
Hi, All, I'm new, confused and apologize for the interruption, but I've got a puzzle and hope someone can help. I have a table that is growing and now has...
May 17th, 2005 06:33 PM
by robastyk Go to last post
2 320
Query By Form Criteria Problem(s),,maybe AND/OR issue by FerryMary
Hi Again {{sheepish wave}} Using Access 2003 Querying Maintenance Jobs What I did: Created Query with desired fields Created Form based on query In header...
May 16th, 2005 07:47 PM
by Ofer Go to last post
1 320
Date Restrictor for this month by Haji
Hi, How do I do a date restrictor that gives me month to date numbers (June 1 to June 16th) . Also, How do I get a date restrictor for last june month to...
June 16th, 2004 03:54 PM
by Van T. Dinh Go to last post
1 320
Variable table name by GB
I need to run the same query on different tables. There is no difference in structure between these tables. For example, I need to run: Select * from...
August 11th, 2004 06:10 PM
by LeAnne Go to last post
6 320
SQL problem on DELETE by ChrisP
I have a table which has 5 primary keys. I am having a problem when I try to run a DELETE statement. 3 of the Primary keys are a Date/Time type. The error...
August 19th, 2004 07:53 PM
by Gerald Stanley Go to last post
1 320
Append Queries by DLAM
Hi, I don't know a lot in Access Queries. How can I use an Append query and everytime when I use it, it will only append the data (invoice number) which is...
September 23rd, 2004 05:31 AM
by Duane Hookom Go to last post
1 320
Executing SQL from Cross Tab Wizard in VBA by Leo
Hi - Any idea why the SQL queries that are created by the Cross Tab Query Wizard cannot be ran in VBA? It starts off with the 'TRANSFORM' statement, as...
October 12th, 2004 08:41 PM
by Leo Go to last post
1 320
Primary Key field validation in forms by Steve
Hi ; I use the forms function to record information into a table . There is a primary key defined for one of the fields that allows me not to input duplicate...
November 12th, 2004 04:02 PM
by Gerald Stanley Go to last post
7 320
Populating fields based on matching records in Excel by Rose
The quick background: The ultimate result of this project is a report with information from several different sources. Some information has to do with the...
December 15th, 2004 05:55 PM
by Rose Go to last post
0 320
Update Right & Left Columns by G. Edwards
One of our Access users has a question he has posed, for which we are still struggling to answer. Let's see if I can explain his goal as clearly as you would...
March 3rd, 2005 05:23 PM
by '69 Camaro Go to last post
1 320
Find Records that ovelap by John H
I have a table with 2 date fields startdate and enddate. They vaules are long int in yyyymmdd format. I want to check for any overlap between records. Eg if...
May 25th, 2004 12:51 PM
by Gary Walter Go to last post
1 320
Post New Thread


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