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 » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 22 of 22
Search took 0.03 seconds.
Search: Posts made by: AccessKay via AccessMonster.com
Forum: Running & Setting Up Queries June 4th, 2010, 08:56 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 3,359
Forcing an ambiguous outer join

Thanks Ken for your reply. My original SQL is as follows:

SELECT tblTransData.number, tblTransData.Empl, tblTransData.[cost code],
tblTransData.[project alias], tblTransData.[cost category],...
Forum: Setting Up & Running Reports May 24th, 2010, 09:07 PM Posted to microsoft.public.access.reports
Replies: 7
Views: 323
Label for totals in group footer

To note...there are some funky time lapses with the newsgroup. I don't know
if this happens to just me but I've started to check the access monster
website along with the newsgroup. But today, I...
Forum: Setting Up & Running Reports May 19th, 2010, 05:40 PM Posted to microsoft.public.access.reports
Replies: 8
Views: 263
Date Format

Marshall...thanks for trying to help me. I've been testing my report and I've
found that it's not always pulling the right totals. So, I need to fix this
first.

AccessKay wrote:
Okay...here is my...
Forum: Setting Up & Running Reports May 18th, 2010, 07:41 PM Posted to microsoft.public.access.reports
Replies: 8
Views: 263
Date Format

Okay...here is my query:

SELECT tblTrans_Mstr.Category, tblTrans_Mstr.DGroup, tblTrans_Mstr.Product,
tblTrans_Mstr.PA_Descriptions, Sum(IIf([TransDate] Between (Forms!
[frmVariance]!txtMo1) And...
Forum: Setting Up & Running Reports May 18th, 2010, 04:02 PM Posted to microsoft.public.access.reports
Replies: 8
Views: 263
Date Format

Let me try to explain better. I have two text boxes on my form where a user
can pick any two periods. I initially set this up for months. But I needed
to create a report for a quarterly comparison...
Forum: Setting Up & Running Reports May 17th, 2010, 08:19 PM Posted to microsoft.public.access.reports
Replies: 8
Views: 263
Date Format

Thanks for your reply. I wasn't sure how to do the custom format but the
second option you gave me worked great. But how can I show the previous
year's quarter. I have two unbound text boxes on my...
Forum: Using Forms May 4th, 2010, 11:20 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 156
Allen Browne’s date range vb a for more reports

Hi Allen,

Thank you very much! This is exactly what I needed. It’s so professional
and user friendly. I plan to use it many times in the future. I appreciate
your help and I also wanted to...
Forum: Running & Setting Up Queries April 27th, 2010, 12:15 AM Posted to microsoft.public.access.queries
Replies: 4
Views: 141
Help with expression for Qtr

I'm having a good Access day today. Thanks Ken! I won't ask how to do the
year:)


KenSheridan wrote:
Just change the interval argument of the DateAdd function from "m" to "q".

Ken...
Forum: Running & Setting Up Queries April 22nd, 2010, 10:38 PM Posted to microsoft.public.access.queries
Replies: 25
Views: 276
Help with Query to find Month

I'm trying to create a report with two columns for MONTH_1 and MONTH_2 and
then the variance. MONTH_1 is not the current month but usually close to it.
It may be mid April before I pull the report...
Forum: Running & Setting Up Queries April 22nd, 2010, 10:38 PM Posted to microsoft.public.access.queries
Replies: 25
Views: 276
Help with Query to find Month

I'm trying to create a report with two columns for MONTH_1 and MONTH_2 and
then the variance. MONTH_1 is not the current month but usually close to it.
It may be mid April before I pull the report...
Forum: Running & Setting Up Queries April 22nd, 2010, 10:37 PM Posted to microsoft.public.access.queries
Replies: 25
Views: 276
Help with Query to find Month

I'm trying to create a report with two columns for MONTH_1 and MONTH_2 and
then the variance. MONTH_1 is not the current month but usually close to it.
It may be mid April before I pull the report...
Forum: Running & Setting Up Queries April 21st, 2010, 08:37 PM Posted to microsoft.public.access.queries
Replies: 25
Views: 276
Help with Query to find Month

I typed 2/1/2010, 1/1/2010, 02/01/2010, 2/1/2010, etc. in the text boxes...
same result. All my dates are on the first of month so didn't think I needed
to test any other day.

KARL DEWEY wrote:
My...
Forum: Running & Setting Up Queries April 21st, 2010, 04:04 PM Posted to microsoft.public.access.queries
Replies: 25
Views: 276
Help with Query to find Month

Humm...I was thinking that January is a text field in my combo box, so I
answered text. My bad...I should have told you that I wasn't 100% sure.
Anyways, I changed the combos to text boxes. I still...
Forum: Running & Setting Up Queries April 20th, 2010, 02:19 PM Posted to microsoft.public.access.queries
Replies: 25
Views: 276
Help with Query to find Month

That's neat to know about the CVDate.

I tried it and received an error message: Syntax error (missing operator) in
query expression 'Sum(IIF([TransDate.... It highlights the "AS" in the SQL.
Here...
Forum: Using Forms April 16th, 2010, 07:48 PM Posted to microsoft.public.access.forms
Replies: 6
Views: 107
Combo boxes like an option group?

I think Mark just answered my question to you Al. I understand now. I'm
going to try it and see if this way works better.

Thank you Mark!


Mark Andrews wrote:
Do an option group with three radio...
Forum: Using Forms April 16th, 2010, 07:43 PM Posted to microsoft.public.access.forms
Replies: 6
Views: 107
Combo boxes like an option group?

Thanks Beetle...that worked great!

Al...I'm curious about what you suggested. Would you mind explaining it a
little more?

Thank you both for the help.
Kay


Beetle wrote:
Forum: Running & Setting Up Queries April 14th, 2010, 09:24 PM Posted to microsoft.public.access.queries
Replies: 8
Views: 142
Finding missing operator

Good thinking Jerry. I will do so and see how it goes. Thanks for your help.


Jerry Whittle wrote:
Let's just try to get the query to work first. I don't know what you are
trying to do is...
Forum: Running & Setting Up Queries April 14th, 2010, 07:56 PM Posted to microsoft.public.access.queries
Replies: 8
Views: 142
Finding missing operator

No, when I try to run it, that's when I receive the missing operator error.
By your response, I take it that I'm doing this all wrong. What I need is an
input form to pull three reports for the...
Forum: Running & Setting Up Queries April 14th, 2010, 05:43 PM Posted to microsoft.public.access.queries
Replies: 8
Views: 142
Finding missing operator

no...sorry about that Jerry. I was studying DateSerial and had it on my
brain. Forget that. It's just an option group. This SQL should work for
two calculated fields right?



Jerry Whittle...
Forum: Running & Setting Up Queries April 12th, 2010, 08:31 PM Posted to microsoft.public.access.queries
Replies: 13
Views: 170
Help with IIF expression

Yes, I’d much rather create one query than four and use my report for the
rest of the calculations. I knew there had to be a better way. Thanks for
showing this to me. I didn’t know Group was...
Forum: Running & Setting Up Queries April 12th, 2010, 05:58 PM Posted to microsoft.public.access.queries
Replies: 13
Views: 170
Help with IIF expression

Hi Bruce,
My post seems to be buried but hopefully you’ll see this. I set-up the
queries for the combo boxes and created a form based on these. This all
looks good. I studied the DateSerial and...
Forum: Running & Setting Up Queries April 9th, 2010, 04:25 PM Posted to microsoft.public.access.queries
Replies: 13
Views: 170
Help with IIF expression

Thank you so much Bruce. Before I saw your post, I put a new thread out
there to find a way to build a parameter form to avoid inserting paramenters
into the query. I'm going to take a look at what...
Showing results 1 to 22 of 22

 
Forum Jump

All times are GMT +1. The time now is 07:28 PM.


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