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
If possible edit the data from query ? by tran1728
Dear all, I use Access 2003, i join 2 tables and impossible to change the data from the table query. Please It is possible Edit the data from the table...
February 23rd, 2010 02:10 PM
by John Spencer Go to last post
5 218
Append query with username and date by Dan
I am using an append query to add a new line to my table - one of the field in this table is "Update_Date" and one is "Updated_By". How via this query I can...
February 23rd, 2010 01:49 PM
by Allen Browne Go to last post
1 228
Listing out Budget, Actual and Forecast by BL
Dear all, We have 3 tables for Budget, Actual and Forecast and the following is the example. The account in the tables can be different. We do not have a...
February 23rd, 2010 01:39 PM
by BL Go to last post
4 584
MAX function is not picking right date in ms access by Eluruking
Hi Access Gurus, Can you please help on the following issue. We are facing difficulty to find out latest date of each customer. We used MAX functionality,...
February 23rd, 2010 10:02 AM
by Allen Browne Go to last post
1 258
Query Criteria by Faraz A. Qureshi
I have a table "Trans" with fields , , I want a query to return records with dates in that are greater than or equal to the date inserted in the ! and less...
February 23rd, 2010 07:07 AM
by Faraz A. Qureshi Go to last post
2 200
key? by Carlos Santos
What record should i set my primary key to ?
February 23rd, 2010 02:33 AM
by John W. Vinson Go to last post
2 195
need to show current year and prior year totals by Lorina
I need to show current year and prior year sales by customer by part. what is the best way to get that data (will create a report). Do I create a query...
February 23rd, 2010 01:51 AM
by KenSheridan via AccessMonster.com Go to last post
8 270
Commenting in SQL by VWP1
Is there any "comment" characters I can use in SQL which will be ignored, similar to HTML's !-- comment -- ? VWP1
February 22nd, 2010 10:34 PM
by Albert D. Kallal Go to last post
3 171
Crosstab Query - Recalculate totals after each date by Laura C.[_2_]
I have created a crosstab query that displays values for individuals across time as follows: Name TransactionDate1 ...
February 22nd, 2010 08:39 PM
by Laura C.[_2_] Go to last post
2 236
Return multiple records from a single entry. by Matty G
I have an access 2000 database which has records showing when activity takes place throughout the year. Each activity has a start date and an end date so...
February 22nd, 2010 07:11 PM
by Jerry Whittle Go to last post
2 202
Outlook 2007 and problems with RSS Feeds by johniecanuck
I'm running Windows 7 on an HP Computer. Periodically my RSS Feeds stop updating , sometimes it's 4-5 and sometimes it's all of them. How can I correct this?...
February 22nd, 2010 06:37 PM
by johniecanuck Go to last post
0 172
Year to Date subquery by ram
HI I would like assistance with creating a year to date subquery. I tried to copy the MS help example but still can't get the query to run. I have the...
February 22nd, 2010 06:15 PM
by ram Go to last post
5 186
Counting Table (By Date) by Mike
Is there a way to make an table/query in Access that counts by date? For example, if I have multiple projects with different start dates, I'd like to have a...
February 22nd, 2010 04:43 PM
by KARL DEWEY Go to last post
2 169
Comparing queries by David
Hi, I am using a database storing equipment for rooms where I have two queries set up, one listing original equipment and another listing current equipment...
February 22nd, 2010 04:40 PM
by Daryl S[_2_] Go to last post
2 161
Group By, Max & Last by Statsman
I've got a table that has: ID Postsector Effective Date Contents Area Buildings Area 1 AB1 1 01/01/10 10 ...
February 22nd, 2010 03:00 PM
by Statsman Go to last post
2 184
Filter asterisks from a field by Dimitris
Hello, I have a field in a table in which there are asterisks (*) entered in some data. How can I filter those records in which asterisks are entered? For...
February 22nd, 2010 12:03 PM
by Dimitris Go to last post
2 139
Help: I have difficulties in Update Where Exists by Aldred@office
Hi all, I have a query which is exactly like this: Update tDelivered Set InvoiceID = 999 where Exists (Select * from tClient INNER JOIN (tPOin INNER...
February 22nd, 2010 08:18 AM
by Aldred@office Go to last post
2 214
Only Once by Sylvia1968
Trying to get a list of items to appear only once. I got the query to work, but it lists dups.
February 22nd, 2010 05:41 AM
by KARL DEWEY Go to last post
4 174
How do I copy one table to another. by Dennis
Hi, I am finshing up an major upgrade for some church membership project I'm working on. I have added a LOT of new fields to the tblMembership table. I...
February 22nd, 2010 05:29 AM
by Dennis Go to last post
6 179
Access 2007-Update Query by ider
I cannot open an update query to edit it. Help tells me to right click to open, however, nothing happens when I right click! Any suggestions?
February 22nd, 2010 02:09 AM
by Jerry Whittle Go to last post
1 158
Post New Thread


Display Options
Showing threads 1121 to 1140 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:39 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.