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
Trying to Siplify a Query in MS Access 2003 by Rich/rerat
I am a real Novice to MS Access 2003. I am trying to create a query to populate a form to be used as a subform in another form. I have created the form that...
May 25th, 2010 05:09 PM
by Jerry Whittle Go to last post
1 294
Extracting from Crosstab query by Peter Kolbe
Hi I have a fingerprint time attendance system running, with its software that uses a microsoft access db. it currently has a crosstab query that results as...
May 25th, 2010 01:36 PM
by John Spencer Go to last post
2 480
getertete by rafael
May 25th, 2010 01:31 PM
by rafael Go to last post
0 320
Report by turks67 via AccessMonster.com
I'm trying to open Two reports with one command button. But everytime I click the command button it goes to the report2. How can I open report1 click until I...
May 25th, 2010 01:14 PM
by vanderghast Go to last post
1 358
parameter for text by sebastico
In Access 2003. In a form I have a parameter to search for a word at a a time Like ..txtWords]&"*" which works well. .. In order to enter more than two...
(Multi-page thread 1 2)
May 25th, 2010 12:36 PM
by Bob Barrows Go to last post
10 614
Query based on multiple parameters - Access 2003 by Pam
I would like to create a query where the user can input 2 or more parameters (part numbers), separated by comma and/or space and return information about...
May 24th, 2010 07:21 PM
by Bob Barrows Go to last post
1 424
Obtaining the correct results from a two table query by [email protected]
I have two tables say A and B, what I am trying to achieve with the query is just to display records that have the received field ticked in table A and the...
(Multi-page thread 1 2)
May 24th, 2010 06:01 PM
by [email protected] Go to last post
12 652
Syntax error in CREATE TABLE statement. (Error 3290) by zufie
I am trying to Create a table from DDL code. Upon running the query I get the error: Syntax error in CREATE TABLE statement. (Error 3290) Here is my code...
May 24th, 2010 05:11 PM
by Bob Barrows Go to last post
2 1,574
Append from 1 table to 2 tables by alhotch
I have a reservation application that I have obtained reservation data from an email message (daqta from which is entered into the tblWorking table). The...
May 24th, 2010 04:29 PM
by alhotch Go to last post
4 407
Left join in query by Tara
I have a query set up with a one-to-many left join on two tables in order to pull all records from one table (the "one" side) and the corresponding records...
(Multi-page thread 1 2)
May 24th, 2010 04:21 PM
by Bob Barrows Go to last post
14 561
Ranking based on Multiple Data Fields by CBender
I am trying to Rank a field based on multiple sort criteria. My query sorts correctly, but the Ranking assignments are not correct. Could someone please...
(Multi-page thread 1 2)
May 24th, 2010 02:12 PM
by CBender Go to last post
10 643
Crosstab query totals by ripper
I have Query1 that returns 2 fields: CatID Step1Decision CatID can be 01 thru 29 Step1Decision can be N,X,P,D,R Query1: SELECT qryGrievances.CatID,...
May 24th, 2010 01:52 PM
by John Spencer Go to last post
3 331
Search Tables by auujxa2 via AccessMonster.com
My client would like to have 6 or so combos on a form, in which they can query any field from any table, and export the results to excel. yikes. i figured...
May 23rd, 2010 11:48 PM
by kc-mass Go to last post
3 361
Coditional IIf with an AND/OR statement by theref147
Trying to get a query to determine a tax rate based on the province on a record. It should look at the field and based on what is in that field come up with...
May 23rd, 2010 03:22 PM
by Douglas J. Steele[_3_] Go to last post
5 410
MS Access 2007 Query Separating Info into months columns by Dan
Hello, I have a contact table (Tblcontacts) that has fields (FldID, FldFirstName, FldLastName, FldPhone, FldStreet, FldCity, FldState, FldZipcode, Fld0to5,...
May 23rd, 2010 01:35 PM
by Dan Go to last post
2 325
M by Dan
-- I hope this helps you, Dan
May 23rd, 2010 02:28 AM
by Dan Go to last post
0 331
#Error by CAM[_2_]
Hello, I am using Access 2003 I have a query where I add three fields together into a new field in the same query, the problem is if one of the three fields...
May 22nd, 2010 03:35 AM
by CAM[_2_] Go to last post
2 288
Query Setup with Two Tables by Curtis Stevens
Is this possible in a query? You have Table A Table B There is a link or join between the two tables. Table A is the main table, B is a sub or secondary.
May 21st, 2010 11:54 PM
by Curtis Stevens Go to last post
2 325
May 21st, 2010 09:36 PM
by Estates Go to last post
0 284
Query using multiple values from one text box by shm135
Hi, I have a form called Test. On this form, I have a textbox where I can type query criteria. I would like to be able to type multiple criteria into this...
May 21st, 2010 09:26 PM
by shm135 Go to last post
8 354
Post New Thread

Display Options
Showing threads 121 to 140 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 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.