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
how do I print out query criteria by Gene
I created a query and now I want to print out the query criteria. How do I do this?
November 19th, 2009 11:06 PM
by KARL DEWEY Go to last post
3 213
join with different number of rows by stickandrock
I have a table(A) that is joined to 2 other tables (B and C). The Key in all 3 of these tables is Part. Part 123 in on Table A 1 time, on Table B 3 times...
November 19th, 2009 11:00 PM
by KARL DEWEY Go to last post
7 207
Query in a subform field by Joanne
Hello, I have a database that tracks vacation time. The main form has the basic employee information and the subform has a list of all the days taken. If...
November 19th, 2009 10:44 PM
by KARL DEWEY Go to last post
1 139
Batching Append Queries by Steve
I have two tables that are joined through a joining table where the PK of both are inserted when there is a relationship between the two PKs. My problem is,...
November 19th, 2009 08:34 PM
by Steve Go to last post
5 140
Query for Multiple Lookups by Rita_M
I'm using Access as the reporting tool for a third-party-developed proprietary database (I can't change the structure of the database). The database has a...
November 19th, 2009 08:28 PM
by KARL DEWEY Go to last post
2 143
Yes/No parameter for selecting either by Owl
I would like to know if it is possible in a query to have a parameter that will allow the user to select either Yes or No, and if so please supply the...
November 19th, 2009 08:04 PM
by Owl Go to last post
3 182
Alias outfield column header by PatK
I have a question about Aliasing fields in a query, if that it the right terminology. I have linked my Access DB to an external sharepoint list. The person...
November 19th, 2009 07:51 PM
by PatK Go to last post
3 246
Aliasing a column header field name by PatK
I am linking my access DB to a sharepoint list. The field name in the list (I have no control over it) is: Prod (Month Start) I want to change the name of...
November 19th, 2009 07:48 PM
by PatK Go to last post
2 141
Text to Time converstion problem by D. Stacy
The goal of this effort is to convert text data into time data. The data comes in 0045, 0200, 0530, etc. BUT it does not always come in in 4 digit text...
November 19th, 2009 06:28 PM
by John Spencer Go to last post
2 137
Creating a select query from multiple fields on the same table by WhiteTiger
Hi all, I've created a table for stores, the primary key is Store Name. I've created another table for input of deliveries to stores on an employee's shift. ...
November 19th, 2009 04:13 PM
by Daryl S[_2_] Go to last post
1 131
Inserting a character by BlackKnight
In a table I have a textfield containg data like B09-001, B09-002 etc. Now I am almost at B09-999, so I like to insert a "0" so that the data look like...
November 19th, 2009 04:07 PM
by John Spencer Go to last post
5 172
Making a query that shows a value based on another value. by james
Hi I have a Query that extracts two fields of data from a table 1. CustomerName (Contains customer name) 2. BuySell (Has either the Word "Buy" or...
November 19th, 2009 12:06 PM
by james Go to last post
3 147
NZ function by ErinCullen
I am trying to use an nz function on a query, so that I get a zero instead of a blank. I can't figure out where to actually type the nz function. Do I type...
November 19th, 2009 04:25 AM
by kc-mass Go to last post
1 108
I can't figure out how to do this. by SF[_5_]
Hi, I can't figure out how to do this. I want to check if staff is available in the office by create query from TravelTable (TravelID, EmployeeID,...
November 19th, 2009 04:00 AM
by SF[_5_] Go to last post
3 164
Counting records in a query by OssieMac
I have a query created with the query builder that has the Unique values properties set to Yes. I would like to be able to add a virtual field to the query...
November 19th, 2009 12:50 AM
by Marshall Barton Go to last post
9 215
making an equation in access by Dani.
Hi, I would like to create a field that works out a formula based on other fields. i.e field z=field4, when field 1field 2 - field 3 etc. Yes, it may be a...
November 18th, 2009 09:28 PM
by fathi hassan Go to last post
2 114
print multiple reports from databse by alecgreen
Hi I have a table in my database that contains customer orders, within those orders are the products reuired to fulfil the order. For each product there is a...
November 18th, 2009 07:29 PM
by alecgreen Go to last post
0 96
Adding Information to a Table by Toria
Here's my scenario: I have a table called SCT. It has about 150,00 records with many fields. I took all the account numbers from this table and looked up...
November 18th, 2009 07:17 PM
by Toria Go to last post
2 108
SQL Error Help by RayToddJr
The following is the SQL that I have in my code: strSQL = "INSERT INTO taDEFENDANTS(TrusteeDefendantID)" & _ "VALUES(lngTrusteeDefendantID)" &...
November 18th, 2009 04:04 PM
by Daryl S[_2_] Go to last post
1 94
Report from a Crosstab w/Parameters by sg
I'm working on a crosstab query that has parameters. I read an article that said to add the parameters to the Query/Parameters as well as in the criteria...
November 18th, 2009 01:50 PM
by John Spencer Go to last post
1 108
Post New Thread


Display Options
Showing threads 2261 to 2280 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 10:29 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.