Search results

The Field has Sum() in text box It doesn't work to the field =Sum([Amount]) At least I cant make it.

Thanks will post some in the morning. It's time to give it up for today Will post something tomorrow. Cheers

I have a cashbook form which has two sub forms. One based on a query of the cashbook table, for the amounts IN and another Based on a Query of the cashbook table for the amounts OUT. When there is a day with no records on one or both sides I cannot get the "Total" Textbox to return Zero. Just...

thanks I have tried to use the Nz(,0) on a field in a form too, although it doesnt seem to work. you see the cashbook form lists In and Out , in two subforms. the total field which calculates Sum of fields in each sub form shows #Error, when there is no data in the query for that day. can I...

I have a line of code : CIT = DLookup("[SumOfAmountIN]", "TotCBINS") which looks in a recordset of a query for the total cash entered. If there is a day without entries (Possible) then the query has no data and I get the error "Invalid use of null" How do I get round this as there could be...

thanks Can I use max([date]) and a condition eg. last recorded date where another field (Balance Carried Forward) is >0? You see there could be many records on that date and I just want the one with a BCF figure. If it is monday i need to get the BCF from saturday and put it into the form for...

i have a cashbook table and after cash up the Balance Carried forward is added as an entry. I need to be able to select the last BCF amount , after a weekend or holiday so i can not rely on date -1 as it may be 3 days ago that the till was last cashed up! can anyone offer a suggestion? I have...

I have a stand alone DB on my pc some times on shutdown i get a message "Table 'TempMsSysAcessObjects' already exists" what is that telling me i should do...am not doing right.

Can anyone tell me why a BMP Image, which I have put on a report, is Printing in Black and White when on preview it shows in colour. It is not the printer ink because the same Bitmap image on a Form, prints in colour?

No It's not that With only the filter everyone comes up as no1??? Any ideas what iv'e done.

Sorry Found it It is ok the Filter on was set to no.

I have a report based on a Single table select query, which has a function in the criteria to obtain the customer number. the query runs fine alone. eg selecting the right record for the number and displaying the name and town...however when i open the report it runs on..That is it displays more...

Thanks for the help guys I've not tried them yet but I shall do. but the whole idea is this. I have a start date and and end date I want to know howmany of the days are weekdays and how many are weekends. Then I want to split that 5 weekdays are charged a "Weekprice" That 2 weekend days are...

Still need help Code ----------------------- countA = DateDiff("d", Forms![rettool1]![StDate], Date, VbMonday, vbUseSystem) For intcount = 0 To countA MsgBox "count" & intcount If Weekday(Strdatestart + intcount) < 6 Then wdcount = wdcount + 1 If Weekday(Strdatestart + intcount) >...

this is what i have so far countA = DateDiff("d", Forms![rettool1]![StDate], Date, vbMonday, vbUseSystem) For intcount = 0 To countA If Weekday(Strdatestart + intcount) < 6 Then MsgBox "<6 so + wd" & Weekday(Strdatestart + intcount) wdcount = wdcount + 1 MsgBox "weekday" &...

WOW Just Found Mod() Is this reliable for this 8 Mod 5 =3 which would be correct if 5 days = 1 wk then mod gives me the remainding days???? Can it be true?

Thank you but there's more The Weekday function has worked well and having looked at a few examples on other threads I have it calculating how many week days and how many weekend days between the start and finish dates. Now in my DB there is a price for a week (being 5 days mon-fri) and a...

I have a form where the user eneters 2 dates. I want to beable to check if the dates are mon-fri (making weekday) or sat & Sun making weekend. Well I also need to know if the period starts on say friday and ends on monday. so i can prompt user that a weekend is included. If anyone has a cool...

I have a query based on one table (Customers) and two other queries. (Orders) and (Invoices) I have a function in the criteria of the new query which selects the customer but the results are repeated ! For 1 invoice i see 6 records of the same invoice. Is it anything to do with (Output all...

Cheers Bert That worked for me... I suppose it is too much that it's possible to uncheck that box programatically, using VBA?