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
Show items not null by mattc66 via AccessMonster.com
I have created a query. SELECT qryItemsWith26Chars.ITEM, qryItemsWith26Chars.DESCRIPTION, qryItemsWith26Chars. FROM qryItemsWith26Chars WHERE...
July 17th, 2008 04:42 PM
by mattc66 via AccessMonster.com Go to last post
4 239
Passing value to Query Criteria from a ListBox by Atif
I am using Access 2007. Presently I am using a Command Button to call a Macro which opens a Query in Pivot Chart view. Now I want to use a ListBox which has...
(Multi-page thread 1 2)
July 17th, 2008 03:55 PM
by bhicks11 via AccessMonster.com Go to last post
13 417
name error by rdv
I have a select query in Access 2007. It has always worked in the past, and still works when I run it. However, when I try to switch to design view, I get...
July 17th, 2008 03:03 PM
by Allen Browne Go to last post
1 209
update all records in table by APINDARA
I have a table that contains 80,000 records and want to add a field that I can use to note year and location of receipt of record. Something like 2004AB or...
July 17th, 2008 01:55 PM
by Michel Walsh Go to last post
6 228
Select records from 6 combo boxes by Shiva
Hi, I am in urgency to create a form having 6 combo boxes on it which is supposed to select data from a table containing a huge data. I want to add a click...
July 17th, 2008 01:03 PM
by Al Campagna[_2_] Go to last post
1 151
Convert column Data Type by Alastair MacFarlane
Dear Group, I have 2 tables with the following schema: Table A: ID (Integer) LinkID (String) Table B: ID (Integer)
July 17th, 2008 10:06 AM
by Alastair MacFarlane Go to last post
2 219
Query Help by Mike
I am trying to set up a query to show a merit increase for two different employees using their social security number. Each of them is receiving a different...
July 17th, 2008 08:14 AM
by [email protected] Go to last post
1 116
Grouping by Greg
Hello, A question. If I have a table like this: 777 555 1111, 7/1/2008, 1, 333 777 555 1111, 6/1/2008, 0, 444 777 555 1111, 7/1/2008, 1, 555
July 17th, 2008 03:25 AM
by Greg Go to last post
2 139
Help with a query by [email protected]
I have the following tables: Project ProjectFile Files Components StandardTypes Schema:
July 17th, 2008 03:06 AM
by John W. Vinson/MVP Go to last post
1 145
Need help on a Query Calculation by Eric
I'm trying to figure out how I can create a query that would do the following calculation. Any help would be much appreciated. My problem lies around the...
July 17th, 2008 12:40 AM
by John Spencer Go to last post
1 116
Getting a query to accept a null value by TESA0_4
Hi, I have created a form with two unbound combo boxes. One allows the user to select a code that represents a type of risk and the other allows the user to...
July 17th, 2008 12:06 AM
by TESA0_4 Go to last post
2 135
query numeric values from text by Mary G
Hello, I'm not finding an exact match to my situation. I have received an export file with the address (street address, city, state, zip) all contained in one...
July 16th, 2008 09:56 PM
by Jeff Boyce Go to last post
4 149
CrossTab Help! by John
I have a query that uses a subquery to calculate a prior period cost, so I can calculate the difference between a total todate cost this month and the total...
July 16th, 2008 09:51 PM
by John Go to last post
6 169
select Statement w/i inner joins by ToniS
I am having a select problem, below is what I am after. TableA Number 1 2 3 4 5
July 16th, 2008 09:45 PM
by ToniS Go to last post
4 120
Criteria issue for limiting a query by Antavas
I have built a query1 that allows me to enter a date range for when an issue is opened. I then built another query2 off of that one using these criteria: ...
July 16th, 2008 09:43 PM
by Antavas Go to last post
2 127
Update query that is updating fields not included in any statement by Todd
I have been downloading data from a website that I import into a table. From there I run queries on the data to append and update my tracking table for the...
July 16th, 2008 09:09 PM
by Todd Go to last post
4 143
Math calculation by Ac
Hi, I have the Excel work sheet to calculate the data (about 25 columns and 300 rows) that are the data for making a chart in the Excel now. Because the...
July 16th, 2008 07:35 PM
by Ac Go to last post
3 150
How do you substitue a value for #Error by Barry
I'm running a query that returns #Error for some rows. I tried to run iif(iserror(),1,0) but it still returns #Error. I have also tried isnull, isempty,...
July 16th, 2008 06:42 PM
by Barry Go to last post
4 135
I need to subtract5 pallets allready inserted. by Marco
Hello. I building a little access database to insert pallets. I have a problem here. I need to insert pallets numbers in a table with quantities but I need...
July 16th, 2008 06:11 PM
by Bob Barrows [MVP] Go to last post
3 122
insert syntax help required by vandy
Hi all, I have a login form were a sysadmin can enter new values into the table. I need the values entered into the table through the form. i have 3...
July 16th, 2008 06:04 PM
by Bob Barrows [MVP] Go to last post
5 129
Post New Thread


Display Options
Showing threads 9881 to 9900 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 12:17 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.