Recent content by dpw204

WAG - I'm not clear from your input what your expected output is. A cross-tab query may be what you're looking for which would generate an spreadsheet like output. e.g: IDDay Total of Value: 1 2 3 1 104 92 92 104 2 108 108 96...

A model / prototype may help here. It looks like you are wanting a total for 'Low Dose Pop Depo IUD Condoms', by the period. That should be easy to get with a group-by query which includes the period field, but doesn't include the non-distinct date field. In the...

MTN's code should serve as a good starting point, but it doesn't handle decimal numbers. A minor change will cover that: Select Case strCh Case "0" To "9" strResult = strResult & strCh Case "." ' ALSO append if a 'period' is used. (Note: for European users a comma may need to be watched for...

Here's a WAG (Wild Assumed Guess) - - Are these clean copies? I've seen problems copying a file that is open and may have unsaved changes... Recommendation: Verify the database isn't in use when creating the copies. - Have you tried Compact and Repair?

Forgive me if I'm being a space case, I'm NOT an access expert, nor well acquainted with report functionality..... A legacy Database, using Access 2000, is generating too much white space, effectively adding an extra page to the report. I'd appreciate any assistance in trimming the excess...

- If con is the opposite of pro, is Congress the opposite of progress?

Not having read this thread, this might be risky; but I thought I'd throw out my solicited opinion: Any women that wants an abortion should be able to get one. IMO if EVERY child in the world were a WANTED child the world would be a much better place. Children can sense when they're viewed as...

I don't know of a query directive which can scan through records looking for a break in a sequence. Two ideas: Both require a bit of programming: 1. -PRE-populate the data: Update the underlying table to contain a sequence counter - Name, Price, Date, IncrementCounter In the forms used with...

Just a wag (1), but I'm guessing that the data-source for the form is based on a query. If so, I'd further guess that the query join-type requires all the joins to have a matching value. If so, the fix would be to revise the join-type on the query. (wag: wild assumption guess)

On the first day, God created the dog and said, “Sit all day by the door of your house and bark at anyone who comes in or walks past. For this, I will give you a life span of twenty years.” The dog said, “That’s a long time to be barking. How about only ten years and I’ll give you back the other...

Re: There are 10 kinds of people.......... A variant: There are 11 kinds of people Those that can count to two in binary, and those that can't!

I don't know about that one.. Yes. One Example I've seen: 'source: http://www.fabalou.com/Access/Modules/refreshtables.asp ' minor revisions by dpw204 'Public Sub RelinkTables(NewPathname As String) Public Sub RelinkTables() Dim NewPathname As String Dim dbs As Database Dim Tdf As...

Looks like illogical code to me. Breaking it down: IIf(IsNull([Last Name]); ' If Last name field is empty IIf(IsNull([First Name]);[Company];[First Name]); 'AND in addition to last name being empty ' if First Name is empty, show Company otherwise show first name (doesn't seem to make...

A debugging question: Is this code within a query? Or is it in VBA Code. If the latter, a fundamental question: have you tried debugging, - stepping through the code and checking the values of [FIELD1] & [FIELD2]? I'm wondering whether for some reason their may be a problem with the data...

All Right! You're on track. Good Luck.