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
Merging three tables by John
Hi I have three tables with a common id with which they can be linked. I need to merge them in a way that the resultant table has all records from three...
December 27th, 2006 03:15 PM
by Gary Walter Go to last post
5 141
Make Table Query Table name restrictions by azpat via AccessMonster.com
Is there any way to create a table name in a make table query that will include the date? I want to have a history of tables and would like to have the date as...
December 27th, 2006 04:09 PM
by Jeff Boyce Go to last post
1 71
Help with Query by DeMangello1
This is my curent query: SELECT User.PKey, User.UserId, User.Administrator, User.MedONLY, User.FilterCRT1, User.FilterCRT2, User.FilterCRT3, User.FilterCRT4,...
December 27th, 2006 06:09 PM
by John Vinson Go to last post
2 78
concatonating by Linda
I am attempting to combine 3 fields into one and not having much success. I've created a new field called GRANTALL in a query to accept this. All fields...
December 27th, 2006 06:26 PM
by Linda Go to last post
5 78
Query Date by coconutt
I have two tables joined one to many. The one is patient name, the many is scan date. When I run my query it will give me the patient name as many times as...
(Multi-page thread 1 2)
December 27th, 2006 06:33 PM
by Rick Brandt Go to last post
11 164
Countif ? by marcus.
Hi, Hi I'm trying to do a countif function (although that does exist in access), but something else should be fairly simple... I'm in a 'Totals Query' where I...
December 27th, 2006 06:36 PM
by Rick Brandt Go to last post
8 170
Date Range Issue by Kevin
I have a database where I am attempting to create a complex weekly report for employee production. I am struggling with the date portion of this project. The...
December 27th, 2006 07:01 PM
by Marshall Barton Go to last post
2 63
add a field in a query for ALL observations, where only the value of the field is available for only few, rest should be zero by zia
Hi I have two tables. Table 1 has say HHID 1 to 1000 (1000 rows) and different fields. Table 2 has only intermittent HHIDs say 456, 12, 23..and 100 such HHID...
(Multi-page thread 1 2)
December 27th, 2006 08:28 PM
by '69 Camaro Go to last post
16 190
URGENT HELP NEEDED WITH GETTING AVERAGES BY QUARTER by Ashley
I need some urgent help with quarter field I have 3 columns in my database OrderNo, OrderData, OrderAmount say that the date right now is Jan 07 then I...
December 27th, 2006 10:05 PM
by KARL DEWEY Go to last post
2 89
Delete query warning message by WilliamP61
Hi Thanks for reading my question. I have a delete query that works fine. However, I want to circumvent the Access warning messages so that I can add my own...
December 27th, 2006 11:38 PM
by WilliamP61 Go to last post
4 92
simple data replacement by Novice2000
Hi, This should be simple, but I am still pretty new at this. I have a main table in which each record has a unique identifier (Policy No.) and each record...
(Multi-page thread 1 2)
December 28th, 2006 12:09 AM
by John Vinson Go to last post
10 151
Multiple records are changed automatically - unwanted auto fill by Rod Smothers
ACCESS DB for tech inventory purposes. I'm updating some information directly in a query datasheet view. While trying to change a room number where a...
December 28th, 2006 12:15 AM
by John Vinson Go to last post
5 115
IFF One Date = Another Date by Nanette
I've been trying to get the below query to work. It only pulls a couple of dates. Any suggestions on how to fix it? IIf(( = ), IIf(( = ), IIf(( = ), IIf((...
December 28th, 2006 05:04 AM
by Duane Hookom Go to last post
9 107
Query with most recent contract by sarah
I could use some help. I have a table with customer info and a table with contracts. They are linked by an ID field. I would like to create a query that...
December 28th, 2006 07:16 AM
by sarah Go to last post
2 70
Need help with query by Darin Connors
Happy Holidays everyone. I have a task to create a report from a data set. I think the quickest way is to query the data. fields: Date, Region (ie BC, AB,...
December 28th, 2006 01:01 PM
by Gary Walter Go to last post
4 113
Union Query Not writing to table by [email protected]
I have a union query that is quite simple: SELECT DetailCust.OrderNumber, Mid(DetailCust.ProductCode,3,2)+MID(DetailCust.ProductCode,7,2) AS...
December 28th, 2006 01:53 PM
by [email protected] Go to last post
3 74
Making it harder than I need to by Novice2000
Hi, Thanks in advance for tyring to help me. Maybe I could have been more clear about what I am trying to do, but I have posted before without a...
December 28th, 2006 03:51 PM
by Novice2000 Go to last post
8 122
One field with multiple values in combination with calculations in a Query by Andre
I have a table with one of the fields is a look up field with multiple values. After that I made a query with all the field from that table. If I run it from...
December 28th, 2006 04:15 PM
by Allen Browne Go to last post
1 78
Join Problems by Tonk
The qry COADS contains only 86 records, one for each county. The qryScanLog contains 88 records, one for each county. I have tried all possible joins and I...
December 28th, 2006 05:35 PM
by Tonk Go to last post
4 95
update query design questions by PJDooley
I'm using Access 2003 and windows XP. I'm building an update query based on a select query to update information in one table with a new table. I have a...
December 28th, 2006 06:03 PM
by Rick Brandt Go to last post
1 66
Post New Thread


Display Options
Showing threads 22001 to 22020 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 02:36 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.