Search results

Well, they both work, no surprise. However, they don't round up. If the difference is plus and say, 3 or 5 (odd), I need it to round up as 2 or 3 respectively. I would +1 but that screws up an even result. However, the minus result is working fine. I tried a round function, doesn't work.

Thanks guys Bob, just curious, why 'switch' ?

Anyone care to tackle a formula for a query ? fields = day1 got day2 (or cell values in Excel as in B1 and C1 and D1) if 'got' is less than 'day1', 'day2' result would be value of 'day1' minus half the difference but don't round up if 'got' and 'day1' are equal, 'day2' result is...

Please disregard the above message. I figured it out.

This will be difficult but bear with me please. *Customer database - some are monthly, some are quarterly invoiced *Have a report(invoice) for each due to different method of calculating and both are based on own query based on the parameter of inputting the specific CID. IOW, on the menu, I...

Here's what I have: QryIncome and QryMonthDebit They both seem to work separately

Thanks Assuming I can figure how to join the two queries. I have one similar that I can maybe pattern it from

I need to apologize profusely. Copied a portion of the wrong query. This is the query I am using - SELECT Sum(TblPayments.Creditamt) AS SumOfCreditamt, Format([Recdate],"mmmm") AS AMonth, DatePart("yyyy",[Recdate]) AS AYear, DatePart("m",[Recdate]) AS Expr1 FROM TblPayments GROUP BY...

SELECT TblCharges.Chargeamt, TblCharges.Chargedate, TblPayments.Creditamt, TblPayments.Recdate FROM TblPayments, TblCharges; Trying to get totals (Chargeamt) and (Creditamt) by month (and ultimately by year) The Chargeamt and Recdate date formats are day/month/year I'm missing something I'm...

Thanks George You hit it on the head I thought all the switchboard stuff resided in the FE. How can I move that table from the BE or can I ?

as far as the menus themselves, I just use switchboard manager and edit those. Not sure what you are asking as for the code I am using.

They aren't listed on the menu(switchboard).

Exactly the same both ends. 2003 It doesn't do this every time. I added two reports last week. Sent it three different times. The new reports didn't show up but everything else was fine. Yesterday, I changed the menu colors and resent it. The color changes show up but the two reports still...

OE on both ends have tried all that - guess I should have said that up front. Can't see any problem in the zip nor email procedures. Is there any 'refresh' in Access that could be used ?

Yes a few times just to make sure. I think I have eliminated email or zip problems. Really a weird thing.

I make changes to the front end and send to my sister via email. Sometimes, when she opens the app, the changes are there, sometimes they are not. Of course, these changes do not affect the back end. I always have her delete the mde before saving the new version, empty recycle bin, reboot...

This is the code for the button: Private Sub DebitButton_Click() On Error GoTo Err_DebitButton_Click Dim stDocName As String stDocName = "QryDbtM1" DoCmd.OpenQuery stDocName, acNormal, acEdit Exit_DebitButton_Click: Exit Sub Err_DebitButton_Click: MsgBox Err.Description...

Geeeeez I should have known that Thanks EMP

I know, it sounds silly, Is there a simple way to run query "B" automatically after Query "A" runs ? I looked at union queries but I can't see how to apply those to two totally different queries. Thanks in advance

Thanks Paul. I have been making minor other changes here and there and just deleted the single db without thinking. Exactly what resides in the front and back ends ? I know the tables and data are in the back end. I assume all the rest, queries, forms etc. are in the front ?