Search results

I just tried it again and it looks like some of the () are being dropped in the string. Me.[Case #] = DMax("[Case #]", "[Incident Reports Table]") + 1 & Year(Date) & "." & Month(Date) I actually went in and used the debugger and tried to add the () but it saved it with just the (Date).

I open the form in design view, went to form properties, and in the "before index" line I put in that code. Thanks so much for your help with this; I'm so challenged by code.

I just started a new record and that's what happened. This is what I wrote: Me.[Case #] = DMax("[Case #]","[Incident Reports Table]") + 1 & Year(Date()) & "." & Month(Date()) Does this look correct or do I have a type-O?

I wrote: Me.[Case #] = DMax("[Case #]","[Incident Reports Table]") + 1 & Year(Date()) & "." & Month(Date()) It replied"Run-Time error '94': Invalid use of null

In the case # would be great. I don't know how it's calculating the 61-235; where would I look? Thanks so much for your help.

Awesome; it worked. The number came out "61-235" Anyway to format it with month and year? That is so great! I just love this forum! Thank you so much!

I wrote: Me.[Case #] = DMax([Case #], [Incident Reports Table]) + 1 It gave me a "compile error". This is so new to me.

I want to make sure that I understand where I am to do this. In the form properties there is a "Before_Insert" listed in the property fields. That I have a text box for (example Case # )on the form that in the Before Insert I use "Me.Case # = DMax("Case #,"Incident Tbl") + 1"

Is there a way to have a form create an auto number with a prefix of "CN-####". There is a data base one department uses and it has Case #, Call #, Incident # and I have been requested to create on their form auto numbers. I have some experience in auto #'s but not much and thought best to ask...

I have a reference table that I have created a form from. I enter the id and all the pertinent data for that customer. I want to populate a monthly invoice table with those fields and the monthly invoice table. Do I create an update query and have a command button to run that query in the form...

Thank you, thank you! Worked perfect!

I have two tables; table one has all the values, table two has values I want to exclude. Would I create a query excluding by using "not like " and then do another to get the values that I want? Just not sure how to do this. Thanks so much!

Thank you all for your help. So to overcome this being two different fields could I: IIf([task]="00059", "BPR, iif([Account_Code]=5112100,"VAH","REG")))

I was actually thinking that as well and thought maybe two separate queries and then join the queries to give all the results I am looking for; sound about right?

qry_sernaPay Period EndIDNameHourly RtDtDeptIDEarn CodeAcct...

IIF Qry:VAHEC: IIf([Acct Code]=5104100,"REG",IIf([Acct Code]=5112100,"VAH",IIf([Task]="0000059","BPR"))) Result qry_sernaPay Period EndIDNameHourly RtDtDeptIDVAHECAcct CodeTaskHoursDiffAmount...

This is what I used VAHEC: IIf([Acct Code]=5104100,"REG",IIf([Acct Code]=5112100,"VAH",IIf([Task]="00059","BPR"))) and am still getting the result of REG for the task 00059;maybe should I quotes around the Acct Code i.e., ="5104100","REG". Thanks again for your help, I really, really...

The first two arguements are pertaining to the account code: Iff([account code] =5104100,"REG", IIf [Account Code]=5112100,"VAH")) Works fine. Now I am adding the following the result is that the earn code reflects REG instead of BPR. IFF([account code] =5104100,"REG", IIf [Account...

Happy Monday everyone!:) I am trying to define two types of data in one query; maybe that's why it's not quite working. I have account code and task code which I am trying to define the earn code for payroll purposes: This is my IIF statement if you could help me, it would be so very much...

I could make a table. Currently we downloaded from our labor system into a database into a table by crop year. ( I was pretty new at this when I started and no resources to learn from) so I did it by copy year. Then I was taught about union queries so now I have one data base that is separate...