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
Using a Parameter Query in a Data Access Page by benbanyas
I looked through previous posts and was too confused to know what to do. I want to turn a parameter query (which returns records which have certain text that...
July 16th, 2008 04:16 PM
by benbanyas Go to last post
0 152
Copy and Paste Append Query Error by Bev
I am attempting to copy and paste an append query within the same data base. When I paste it and type in the new query name I get the following error which...
July 16th, 2008 03:39 PM
by Bev Go to last post
0 141
Format a Calculated Field by jlo
I have two date and time fields that I would like to find the time between them in days/hours/minutes excluding holidays and weekends. I currently have a...
July 16th, 2008 03:18 PM
by jlo Go to last post
0 123
help needed with date expression by Slez via AccessMonster.com
What expression in a query would gather the data from the current date, going back 13 months to the beginning of that month? For instance: If I run the query...
July 16th, 2008 03:04 PM
by Allen Browne Go to last post
1 165
Unique Values blanking out a text field by Faye
In my query when I choose Unique Values some of the records come back with a text field blanked out when there is actually a value in it. If I turn off...
July 16th, 2008 03:02 PM
by Allen Browne Go to last post
1 197
Please help with Query Criteria by Please Help
Hello all, I have a number field in my append query. Instead of hard coated the criteria with the formula "0" on that field, I want to make it to prompt...
July 16th, 2008 02:16 PM
by Please Help Go to last post
4 139
Suming numbers and text together by Adam
I have a problem. I have a table with a text field that was set up wrong from the start. The table looks like this. Feild1 ________ 1 2 1
July 16th, 2008 01:33 PM
by Adam Go to last post
3 130
Aceess 2003 Query using NOT operator? by Trevor Aiston
A database I have inherited has field 'Status'. Data is entered in to this field from a range values in a combo box "planning/design";"data collection";"data...
July 16th, 2008 12:52 PM
by Bob Barrows [MVP][_2_] Go to last post
4 204
Numeric Field Overflow from Excel File to new Table in Access by Beverly76
I have a linked Table in Access "02TBL" which is linked to an Excel spreadsheet. Then I have a make table query "02TBLmtq" which takes the entire linked...
July 16th, 2008 12:15 PM
by John Spencer Go to last post
4 162
Creating OR, AND query in access and getting parametrs frm access by HelpNeeded
Hi All, I am trying to get 7 parameters from access form (textboxes). I have a table called review. I am trying to generate and predefined query. which will...
July 16th, 2008 06:28 AM
by HelpNeeded Go to last post
2 134
How do I modify a query and consolidate data? by Destiny
Let me preface this to say I am a Very new user. I am looking at a query that has repeated records except for one piece of information. I am assuming that...
July 16th, 2008 03:44 AM
by Rob Parker Go to last post
1 133
Public string var as criteria for query? by Rich[_17_]
Hello, Trying to see if this is possible. I have a select query that is run from an onClick button on an options form (user can run report on variety of...
July 16th, 2008 02:51 AM
by MGFoster Go to last post
1 110
Inconsistent return by LeAnn
Hi All, Here’s my situation using Access 2003. I have a linked table to a VFP data source (using ODBC for VFP). I have a query that trims the fields so I...
July 16th, 2008 02:15 AM
by LeAnn Go to last post
1 140
SKUO11.CAB by raul
Cannot open Microsoft Office Professional Edition 2003. A required installation file-SKUO11.CAB is missing. Thanks in advance for your help, Raul...
July 16th, 2008 01:43 AM
by haikal Pribadi Go to last post
5 167
Optimizing my query using MAX by Lina
I need some one to help me Optimize my query using MAX or DMax or Top 1, however. I have a large result query that sumirized the sales (for each region) from...
July 16th, 2008 12:51 AM
by MGFoster Go to last post
1 111
Query Property sheet by BBran[_2_]
Hello, I am using Access 2007 on XPSP2. I recently moved the property sheet for a query and now that sheet is in the same location for every query or report...
July 15th, 2008 11:37 PM
by BBran[_2_] Go to last post
0 111
Inner Join SQL Help by Ray Todd Jr
I'm trying to join two tables via SQL and am getting errors. Any help is appreciated. The tables: taDEFENDANTS DefendantsID PK PropertyID...
July 15th, 2008 08:53 PM
by Ray Todd Jr Go to last post
2 144
Nz problem by Silvio
I have 3 fields in my search form 1. No 2. Street 3. Project If all the fields are left blank then no record will be retrieved... so far so good,......
July 15th, 2008 08:49 PM
by John Spencer Go to last post
9 153
need help with append query by DJTI via AccessMonster.com
Thank you in advance for help on this problem. I have an append query to enter data into a table. The below sql statement is what I am using. I need to edit...
July 15th, 2008 08:47 PM
by John Spencer Go to last post
3 134
Factorial Function by rascal
In access 2003 you can set a field in a table as a number and then as Scientific. Can you set a field in a query to do a factorial calculation? If so any...
July 15th, 2008 08:15 PM
by Marshall Barton Go to last post
2 155
Post New Thread


Display Options
Showing threads 9901 to 9920 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:43 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.