Search:

I am writing a report with Access 2003, but having some issues with the proper way to put the iff statement in the control source.

What I need to show in the text box is the sum of 3 tables but...

Got it. Thanks again!

Doing some touch ups with the application. One thing I noticed, is when form is opened. It starts at the 1st record. Is there a way to have the form start at the last record or start at a new record?

Hi Scott,

Ok.. I went the route of a button on this. What happens when the button is clicked, is that a query pops up. I would rather have the results of that query (1 column with 1 sum) show up...

A dsum might be a better solution.

I wrote this based off your suggestion.
=DSum("[Addl_Pages]+[documents]+[Wasted_Paper]","Jobs","[Print_Date] = #" & [Log_Date] & "#")

Now, this will sum the...

Private Sub cmdGetLog_Click()
On Error Go to Err_cmdGetLog_Click

Job.RecordSource = "Select document from job"

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, acMenuVer70
...

I have a form in Access2003 called Daily_Log

The form is tied to the Daily_Log table.

On the form, I have a text box called Log_Date.
I also have a text box called Count_Logged with a button...

When replaced the computers power supply, you might not have reconnected th cable that connects the monitor to the video card.

Also, when you opened your computer, you might have unseated the...

In all seriousness. My wife had the same problem. Still does unless she uses a toy.
She read that this is a common problem with women, so you are no alone.

Try a massager.

I went through something similar when I was a teen. I became a father and displayed some of the same traits as your boyfriend, though not as extreme.
I was scared out of my mind.

I sounds like a...

I created a report with input date parameters. Works well.

In the header, I have a text box and in the control source, as =date().

When the report is ran, it shows the current date. Its in the...

Ok..

I am trying to make a report that will sum up the results for 3 columns in the same table based on date.

I have been using the wizard but all my results come out like this.

1/4/2007...

Nice!

Thanks!

Another thought, and I am not sure if its possible or not, but in the report properties, where the Record Source is at, is it possible to look pull more than 1 query?

Hi Scott,

My job table looks like this:

JobID (pk)
CustomerID
PrintDate
Documents
Addl_Pages
Wasted_Paper

I have a text field in my form header. It will count the sum of 3 tables for the current month.
This helps me know how much stuff has been printed.
...

My wife is a teach and the MAC is only at home during the weekends.
Rules the evil mac out.
I called Linksys and they helped me upgrade to the latest firmware. I forgot to mention it.

I'll...

Hi TSZYMANSKI,

Its hard to price the cards without a visual inspection. Cards are valued by quality.
Your best bet would be to take them to a local card shop for pricing.

The Ken Griffey Jr,...

I thought that if a child is at a certain age, he could make his/her own descion. All it would take was going to a judge. I didn't think it would be a full custody battle.

Wow Scott.
It totally clicked. I got several reports functional with this method. Thanks!

Another question. Now, I am more of a graphics guy than a programmer. I took the basics in college, but...

My wife would like to see my son live with us. Our 2 year old adores her big brother and he is a great help with her. She knows how much I would love my son living with us and supports it.

I do...

Thanks for your advice. Its much appreciated!

Scott, you are everywhere! Mercy.

Can you provide a link for this?
If I am unable to do it from the link, I see that you take calls. I'd be willing to call.

My wife and I talked to him about why the change, there were some things he wasn't happy about.

a. His school was consolidating with a rival school.
b. He worked all summer on a farm detasseling...

I have a Linksys WRT54G wireless router.
A newer HP Pavilion laptop.

When connected wirelessly, the internet goes up and down about 3 times an hour.

This happens all times of day.
This...

I have used Crystal Reports 8.5 in the past. One of features I liked is when a report was ran, it prompted the used to specify a date range.
Can Access 2003 do that? If so, can you point me into the...

Hi, 1st time poster to this site...

My 15 year old son lives with his mother and step-father 2 hours north of me in rural Iowa. He lives in a good home with 2 very nice people. He is happy and...