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
Relationship Issues by Novice2000
Hi, I am trying to creat a query where one side of the relationship is to be changed from Mid GC to GC. When I create the new relationship I cannot delete...
February 15th, 2007 11:02 PM
by KARL DEWEY Go to last post
1 128
Lookup table? by ielmrani via AccessMonster.com
Hi everyone, I was told to do lookup tables for the following but I do not know how to do them. I need help because I never done a lookup table before. I have...
February 15th, 2007 10:47 PM
by ielmrani via AccessMonster.com Go to last post
4 246
Merging two field together by ChuckW
Hi, I am trying to create a field called UserID. It will be based on two other fields: FirstName and LastName. What I want to do is to get the first letter...
February 15th, 2007 10:32 PM
by Rick B Go to last post
1 147
Number Increments by Chris
How can I add a field that increments to an existing table. I know I can use the auto num but that starts at the number 1 and I want to start my numbers at...
February 15th, 2007 09:22 PM
by KARL DEWEY Go to last post
1 121
group by .....? by chill
hello , can anybody help me on this.... i have the following query... SELECT A.A1,A.A2,A.A3,A.A4, B.B1, B.B2, B.B3, B.B3, B.B4, B.B5, B.B6, B.B6,...
February 15th, 2007 08:49 PM
by chill Go to last post
0 119
Expressions in queries that have an #error message come up in rec by M Wiseman
I have the expression in a query, % Change WOW Units: (-)/ I keep getting an error message in records. I believe it is because some records have 0 as the...
February 15th, 2007 08:45 PM
by kingston via AccessMonster.com Go to last post
1 127
Query Help by ckloch
I have a query which includes joins and subquery. One of the fields in the query is coming back empty. Below is all the information from the tables...
February 15th, 2007 08:21 PM
by ckloch Go to last post
0 148
Unmatched query by [email protected]
I need help with a query that sorts out unmatched fields from two tables. I've tried with an union query but it matches my duplicates as well... I want my...
February 15th, 2007 07:58 PM
by Jeff Boyce Go to last post
3 109
IFF in Query?? by HeatherD25
Hi, I have a query where I have a lot of calculated fields. I need to run in monthly to generate a report. Example of a calculated field: TOTAL:...
February 15th, 2007 07:53 PM
by HeatherD25 Go to last post
3 114
Criteria on calculated field in parameter query by Graeme at Raptup
Hi, I have a parameter query that includes calculated fields. My query is seemingly easy, i.e. I want to run a query that lists all records where the...
February 15th, 2007 07:43 PM
by Marshall Barton Go to last post
2 172
Nz(null values in queries, 0) by Engels
I am trying to use the NZ function to return null values from my query. The query is off a table called "Training Course" and another table related (through...
February 15th, 2007 07:05 PM
by Engels Go to last post
2 156
doing an append and an update at the same time by Helen Martin
hello.. I'm trying to import some new names and email addresses into my contact database.. I need to add records to my mail contact information table, and...
February 15th, 2007 06:55 PM
by Helen Martin Go to last post
1 192
How do I add 5 seperate number entries into a single line total? by Tem
I have converted 5 separate field date entries into separate fields converting them to a numeric value. I need to add each one to the other for a total line...
February 15th, 2007 06:27 PM
by Tem Go to last post
2 140
Bizarre..can't figure this one out by Boz
I am using Access 97. I have a database that is used to schedule inbound appointments. On the scheduling form, one piece of information required is the...
February 15th, 2007 05:54 PM
by Jerry Whittle Go to last post
3 139
Sum Values on weekends and total for Monday by Bongard
I have a query which I am currently doing a huge workaround with an export in Excel to sum up weekends values and total them on Monday. For...
February 15th, 2007 05:42 PM
by John Spencer Go to last post
7 127
Question about pass through queries by Bongard
I have a large database where I am contemplating using pass-through queries to all my ODBC tables or just bringing in all the linked tables and running queries...
February 15th, 2007 05:02 PM
by Duane Hookom Go to last post
3 112
Sums & Cross-Tab Query by HeatherD25
I am trying to create an underlying query for a report. Here is the data I have: - I created a cross-tab query that takes employee timecard information and...
February 15th, 2007 04:58 PM
by HeatherD25 Go to last post
2 134
Chart problem: At a loss :-( by scubadiver
I have posted this problem in the "form" thread but have decided to post here (apologies in advance for breaking internet forum guidelines!). To give you an...
February 15th, 2007 04:47 PM
by scubadiver Go to last post
3 156
Formula by KenP
I can use the below expression to display orders for the fourth calendar quarter. DatePart("q", )=4 The above formula performs the calculation and returns...
February 15th, 2007 04:23 PM
by Duane Hookom Go to last post
1 134
Year to Date Query Issue by Steve
Hi all- Thanks in advance for taking time to give me a hand. I'm having an issue with trying to make a Year to Date function in my query. I want it to give...
February 15th, 2007 03:59 PM
by Michael Gramelspacher Go to last post
2 217
Post New Thread


Display Options
Showing threads 20101 to 20120 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:31 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.