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
Isolating text in a field by scubadiver
Hi folks! The following text is an example: "F002 Internal Audit Summary Report Form Rev B.doc" How do I isolate "Rev B" considering that everything that...
February 27th, 2007 05:07 PM
by Michel Walsh Go to last post
1 159
Need help witha calculation query by [email protected]
hi im new to this and really need someones help basically i have created a database with a number of tables such as: Member id, Sales Table and rental...
February 27th, 2007 04:43 PM
by skigal Go to last post
1 127
Subqueries by cprav
I initially posted this question in the Reports forum as my subquery is creating a filtered report. However, I just can't seem to get this subquery down,...
February 27th, 2007 04:08 PM
by cprav Go to last post
8 193
random records are not generated in access 2000 !!!!! by hardik
Hi friends, can anyone solve this query ? I have a table which stores products id and name and then product image now all i want is everytime i refresh a...
February 27th, 2007 03:43 PM
by hardik Go to last post
9 142
Rolling query by THE BIG O
I would like to create a Find Duplicate query that collects information from a table using a rolling year. Essentially we are going to import shipments into...
February 27th, 2007 01:51 PM
by THE BIG O Go to last post
3 141
HELP! Error Message by Novice2000
Hi, I am trying to run a form base on a query and I am getting this message: Reserved error (-1517); there is no message for this error. It was working...
February 27th, 2007 01:30 PM
by Novice2000 Go to last post
2 147
Help modifying a "working days" query/function by Zeunasc
All of my attempts at modifying this function have failed, so I am hoping someone here can give me some direction. Basically, you take today's date, and find...
February 27th, 2007 11:46 AM
by Gary Walter Go to last post
4 144
MDA to MDW conversion by Albert
Could anyone tell me please if there is a utility out there which can perform a satisfactory conversion from the .MDA format of Access V2 to the ..MDW format...
February 27th, 2007 09:58 AM
by Albert Go to last post
0 158
Distinct data by The Rook
Sorry if this is simple but I am very new to SQL. I currently have a link into our MRP database and am wanting to set up a query to show how many technical...
February 27th, 2007 09:31 AM
by The Rook Go to last post
2 140
Creating Calculations based on Cross tab values by Carlee
Hello, I am having some trouble. I have created a crosstab query that displays the numbe of samples by Age (Row) and Classification (column). No problems,...
February 27th, 2007 06:48 AM
by Duane Hookom Go to last post
1 157
update query by mccoy
anyone who can give me a sample database using update query i want to update all records using calculated field from another table a sum of TableA.fieldA to...
February 27th, 2007 06:26 AM
by Duane Hookom Go to last post
3 127
WHERE help needed by Sophie
I have SQL that works fine, but I have a question about the WHERE conditions SELECT ...... FROM ........ WHERE (((K.HardwareClass)=!.) AND...
February 27th, 2007 04:22 AM
by Rick Brandt Go to last post
1 128
using less than in criteria in select query by Anne
Hello! I have a table where I need to evaluate if one field (pre-weight) is less than 0. I tried doing an select query where I said "0.0" in the...
February 27th, 2007 04:17 AM
by John W. Vinson Go to last post
9 183
Query won't open in design view by BBran
Hello, I am using Access 2007 B2T2. I am trying to open a query in design view but get an error. The same query opens fine in design view in Access...
(Multi-page thread 1 2)
February 27th, 2007 02:15 AM
by Allen Browne Go to last post
17 276
Parameter query not working correct. by Jim Moberg
Hi, I have a query that joins table A to Table B via the loan number. Table A contains a record for each loan and an associated load ID that it was...
February 27th, 2007 02:11 AM
by Allen Browne Go to last post
1 202
Sorting numbers in a text field by [email protected]
I have a text field I want to sort. I have this: 1 10 11 2 3 FM 1
February 27th, 2007 01:33 AM
by raskew via AccessMonster.com Go to last post
3 141
newbie SQL question by Victoria
i'm working at learning how to design queries using SQL. Based on what I've seen in this group, the SQL is much easier to follow and understand when...
February 27th, 2007 12:49 AM
by Victoria Go to last post
2 172
Change date to set month by John
Hi, I have a TestDue date which I want to change in some cases to a fixed month PRIOR to the TestDue Date. One table contains a field holding the value of...
February 26th, 2007 11:40 PM
by John Go to last post
2 159
Running query from a Command button by tom sparks
i have a command buttons on a form which have been given the instructions with an on click event to run a macro to open another form that has been created...
February 26th, 2007 10:58 PM
by Van T. Dinh Go to last post
1 160
Combo Box query for current record by Mariano
I am sure this is a common issue, but I couldn't find it in my searches.... I have a form bound to a table called entry. The field 'speed' is a combo list...
February 26th, 2007 10:46 PM
by Mariano Go to last post
2 102
Post New Thread


Display Options
Showing threads 19841 to 19860 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:14 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.