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 25 of 39
Search took 0.16 seconds.
Search: Posts made by: Jim
Forum: Running & Setting Up Queries June 7th, 2010, 04:18 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 1,756
Posted By Jim
How to calculate days due?

Hello,
Sorry, 6/1 means terms of June 1.

Jim

"Ken Snell" wrote in message
...
What does "6/1" mean with respect to...
Forum: Running & Setting Up Queries June 4th, 2010, 06:29 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 1,756
Posted By Jim
How to calculate days due?

I have a table (tblTerms) with 2 fields [strTerms] & [dblDaysDue]. The
typical terms in the table would be 2%10 Net 30 with [dblDaysDue] having a
value of 30. I then take the difference between the...
Forum: Running & Setting Up Queries June 1st, 2010, 10:59 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 215
Posted By Jim
Inventory Loop

I need a way to loop through an invoice and figure out the number of boxes
being used per order. We have the same product that can go into multiple
size boxes depending on the quantity shipped. For...
Forum: Running & Setting Up Queries May 5th, 2010, 07:55 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 143
Posted By Jim
How to calculate overdue?

We have a customer that has terms of June/1 or Net 60. Any orders placed
between 10/2 of the previous year and June 1 of the current year have terms
of 6/1. Orders placed between 6/2 and 10/1 have...
Forum: Running & Setting Up Queries May 5th, 2010, 07:51 PM Posted to microsoft.public.access.queries
Replies: 5
Views: 151
Posted By Jim
DateDiff with variable criteria?

Thanks.


"Marshall Barton" wrote in message
...
Just cahnge your DateDiff calculated field's criteria to:
=...
Forum: Running & Setting Up Queries May 4th, 2010, 06:57 PM Posted to microsoft.public.access.queries
Replies: 5
Views: 151
Posted By Jim
DateDiff with variable criteria?

This is a report for sales commissions. I do have a field that has payment
terms in it. 99% of our customers have 30 day terms or less, a couple have
terms of 60 days. I'm calculating the...
Forum: Running & Setting Up Queries May 3rd, 2010, 09:18 PM Posted to microsoft.public.access.queries
Replies: 5
Views: 151
Posted By Jim
DateDiff with variable criteria?

I have a query field that uses DateDiff("d",[dtmDateShipped],[dtmDatePaid])
to calculate the difference between a ship date and paid date. I also have
=50 in the criteria row to restrict payments...
Forum: Setting Up & Running Reports April 23rd, 2010, 11:17 PM Posted to microsoft.public.access.reports
Replies: 1
Views: 110
Posted By Jim
Importing TXT files with delimiter

Can't you just do a "find and replace" and substitue the | for a comma or
something and then import it into Access?

Jim

"Alaska Ken" wrote in message...
Forum: Setting Up & Running Reports April 23rd, 2010, 09:42 PM Posted to microsoft.public.access.reports
Replies: 0
Views: 144
Posted By Jim
Change Report Title Based on Source & Date?

I have a report with the following code behind:

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)

If Format(Forms!frmCommission!cboStartDate, "mmyyyy") =...
Forum: Setting Up & Running Reports April 23rd, 2010, 04:45 PM Posted to microsoft.public.access.reports
Replies: 6
Views: 311
Posted By Jim
Report title based on Date?

I put it in the On Format event in the Report Header section and it's
working now.
Thanks

Jim

"Steve" wrote in message
...
...
Forum: Setting Up & Running Reports April 23rd, 2010, 04:42 PM Posted to microsoft.public.access.reports
Replies: 6
Views: 311
Posted By Jim
Report title based on Date?

When I do that, it tells me I can't assign a value to this object error
number -2147352567 (800200009)

Jim

"Steve" wrote in message...
Forum: Setting Up & Running Reports April 22nd, 2010, 10:50 PM Posted to microsoft.public.access.reports
Replies: 6
Views: 311
Posted By Jim
Report title based on Date?

Thanks, both codes work. However, I have to close the report and reopen it
twice before the title displays. Is there something else I need to do?

Jim

"John Spencer" wrote in...
Forum: Setting Up & Running Reports April 22nd, 2010, 06:33 PM Posted to microsoft.public.access.reports
Replies: 6
Views: 311
Posted By Jim
Report title based on Date?

I have a report header that fills in the title based on the dates chosen on
a form with this line of code:



Me.txtTitle = "Commission" & " " & Format(Forms!frmCommission!cboStartDate,
"mmmm/yyyy")
Forum: Setting Up & Running Reports April 20th, 2010, 10:17 PM Posted to microsoft.public.access.reports
Replies: 2
Views: 105
Posted By Jim
Sub Query?

Yes I'm grouping on the widget field, but I don't have the group footer
turned on. I was trying to total it in the report footer.


"KARL DEWEY" wrote in...
Forum: Setting Up & Running Reports April 20th, 2010, 05:55 PM Posted to microsoft.public.access.reports
Replies: 2
Views: 105
Posted By Jim
Sub Query?

I have a select query that adds up monthly sales for products both by case
and single items for a commission report. An example would be:



Widget A
Single Qty
Single Cost
...
Forum: Setting Up & Running Reports April 1st, 2010, 11:17 PM Posted to microsoft.public.access.reports
Replies: 2
Views: 358
Posted By Jim
Filter Report Date in VBA

I have an Access 2003 report that I'm trying to filter in VBA. I have a form
setup with radio buttons for selecting year to date or everything. I have a
Select Case statement in the On Open event...
Forum: Running & Setting Up Queries March 23rd, 2010, 08:40 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 133
Posted By Jim
Select unique products per customer?

I will check these out. They seem to be what I need. Thanks

Jim

"John Spencer" wrote in message
...
That will require a bit of VBA...
Forum: Running & Setting Up Queries March 23rd, 2010, 06:35 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 133
Posted By Jim
Select unique products per customer?

What I currently get when I run a query is:



Col A Col B

Customer1 Product 1

Customer1 Product 2
Forum: Running & Setting Up Queries March 19th, 2010, 09:36 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 133
Posted By Jim
Select unique products per customer?

I need the records in a table because it's for a customer lookup on a
website that's not attached to the original data source. When I run the
query you suggest, it gives me multiple entries for...
Forum: Running & Setting Up Queries March 19th, 2010, 06:44 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 133
Posted By Jim
Select unique products per customer?

Looking at the Northwind database as an example, I need to take all the
products from the Orders table and put them into one field in a table for
each customer so that I end up with each customer...
Forum: Setting Up & Running Reports October 27th, 2009, 04:11 PM Posted to microsoft.public.access.reports
Replies: 2
Views: 80
Posted By Jim
Show Report Header on First Page?

Is there a way to only show the report header on the first page of a
multipage report? I'm using Access 2003.
Thanks

Jim
Forum: Using Forms August 26th, 2009, 07:09 PM Posted to microsoft.public.access.forms
Replies: 4
Views: 42
Posted By Jim
Help with syntax

Thanks!

"Clifford Bass" wrote in message
...
Hi Jim,

Try:

...
Forum: Using Forms August 26th, 2009, 06:21 PM Posted to microsoft.public.access.forms
Replies: 4
Views: 42
Posted By Jim
Help with syntax

I need the correct syntax for using IIf with Or in a form. What I currently
have isn't working:

=IIf([cboInvoiceNumber].[Column](16)="SH3700" Or...
Forum: Publisher November 6th, 2008, 06:23 PM Posted to microsoft.public.publisher
Replies: 1
Views: 58
Posted By Jim
Multiple Page Layout?

Hello,
I'm using Publisher 2003 and I need a make a two page publication with a
different page orientation for each page. When I set the orientation for
either the first or second page, it...
Forum: New Users May 6th, 2008, 09:34 PM Posted to microsoft.public.access.gettingstarted
Replies: 3
Views: 95
Posted By Jim
Calculate Year to Date

I will try both of these and see what happens.
Thanks

Jim

"BruceM" wrote in message
...
The criteria could be handled with a...
Showing results 1 to 25 of 39

 
Forum Jump

All times are GMT +1. The time now is 10:49 AM.


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