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
Query design help requested by Victoria
hello to all I'm fairly new at this! Here's my situation. qryA and qry B have identical structures. The PKey used in both is EmplID. I need to know how...
November 27th, 2009 04:24 PM
by Victoria Go to last post
2 262
Not statement not working by jerry001 via AccessMonster.com
I went through the forum but couldn't find an answer to that ok so I need a query that gives all records that don't have a set of values in a field. i.e....
November 27th, 2009 02:20 PM
by jerry001 via AccessMonster.com Go to last post
2 254
Duplicate Returns. by Andrew
Sometimes when I do a query, I get the record listed twice (or more) after hitting Run. The records aren't duplicated in the table, so why am I getting two...
November 27th, 2009 08:35 AM
by Allen Browne Go to last post
3 234
Combo Box Not in List function by Leo
I have a combo box that lists the option (limited to list) from a table called tblALLRECCS which has only one field called RECS. How do I write a code in Not...
November 27th, 2009 06:41 AM
by John_G via AccessMonster.com Go to last post
1 180
Update query only partially working by [email protected]
Hi I'm trying to run an update query but for some reason it's only updating some of the records. The weird thing is that the field that i'm coparting to update...
November 27th, 2009 06:28 AM
by John W. Vinson Go to last post
1 169
Requerying Automatically by DawnTreader
Hello All I have a query like this: SELECT utblPartListPriceQuery.ID, utblPartListPriceQuery.Partnumber, dbo_PART.ID, dbo_PART.DESCRIPTION, ...
November 26th, 2009 11:15 PM
by DawnTreader Go to last post
1 201
Merging queries by column in access by Xmas
Hi, I have a series of queries which get data aggregated by year, e.g. select year(date), min(var1), avg(var1), max(var1) from table where (ridiculously...
November 26th, 2009 09:44 PM
by vanderghast Go to last post
1 193
Previous Dates by Peter
Hi all, i am ashamed to admit that i can not figure this one out.. In one table i have the DateCreated field. In my query i want to display all records...
November 26th, 2009 06:31 PM
by Peter Go to last post
2 176
Temporarily disable relationships/constraints by Ben8765
Hi, I am trying to do append queries from many tables in database 'A' to tables in database 'B' through vba code. The problem is that there are...
November 26th, 2009 06:26 PM
by John Spencer Go to last post
1 178
Joining tables by IgorM[_2_]
Hi I have two tables - one for debtors and one for creditors, both have the same columns (name, number, NIP, value). I want to create a table (query) that...
November 26th, 2009 03:15 PM
by Rick Brandt Go to last post
1 197
Query duplicated entries by Jose Lopes
Hello everyone. Sorry for such a newbie doubt, but since my Access and SQL experience is a bit “trial and error” I don’t even know what to search for...
November 26th, 2009 03:06 PM
by vanderghast Go to last post
1 197
Double Booking Query by Andy Day
At present I am trying to make a database for room bookings at work. I'm at the point where I need the database to check for double bookings on the rooms. I...
November 26th, 2009 02:36 PM
by Andy Day Go to last post
3 171
Archive in query by Frank Situmorang[_3_]
Hello, If I have an Invoice Input Form based on query, which query is also based on 2 tables, supplier table and Invoice table. If I archived that an...
November 26th, 2009 10:03 AM
by Frank Situmorang[_3_] Go to last post
0 166
create append query resulting in multiple new records by 8l2255
I have a new transaction form. It has fields TransactionID (autonumber), ProductID, EquipmentID, UnitsReceived and a few more. When I create a new...
November 26th, 2009 06:04 AM
by 8l2255 Go to last post
4 221
Columns using month and year by Sheri
I am trying to create a LAG report that gives what month/year (Jan 2006-Dec 2009) service was given (the rows) to month/year service (again Jan 2006-Dec...
November 26th, 2009 05:54 AM
by Tom van Stiphout[_2_] Go to last post
1 168
there isn't enough free memory to refresh the display by Siegfried
I'm working with a table of over 1 million records. After running a query I try open it in design view I get the above message. Any suggestions how to get...
November 26th, 2009 05:51 AM
by Tom van Stiphout[_2_] Go to last post
1 181
How to use Delete Query for specific for rows 5 by Steph_canoe[_2_]
I would to use a Delete Query for all rows of Table A after Row #5. Is there a way I can filter so the delete query remove Rows 5 in Table A ? Thank you
November 26th, 2009 01:35 AM
by KenSheridan via AccessMonster.com Go to last post
1 208
Age calculation in Query by Dave
Access 2003 I am trying to calculate the age of a person directly in the query. Not sure it is possible but here is what I have tried that does not...
November 26th, 2009 12:14 AM
by JONEPONE Go to last post
6 295
# in table by instereo911 via AccessMonster.com
Hi, I have a table w/ multiple values on one column seperated out by a ";#" sign. Example: State Number ;#Central;#COVA;# ...
November 25th, 2009 10:32 PM
by John W. Vinson Go to last post
1 173
Crystal Reports formula to Access by lindag
Any suggestions on how to use this formula in Access? if not(IsNull({MASTER.JMT_DATE})) then "Post Judgment"else if (IsNull({MASTER.JMT_DATE})) and...
November 25th, 2009 10:09 PM
by lindag Go to last post
2 155
Post New Thread


Display Options
Showing threads 2161 to 2180 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 07:25 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.