Search results for query: *

I currently have a form (reimbursables) with a subform (Items) in Access. These two forms are linked by a relationship called job number (common field). This job number acts as a filter and only outputs those records that contain the same job number as in the reimbursables form. Well, here is...

I have an Access database and need to generate an Invoice number in the following way: "RPI"("YYMM")000 (Autoincrease)= for example:"RPI0306000" for the first invoice generated on June 2003. RPI0306001 (for the second, etc, etc...) ok, let me explain what this...

Hello again. I have a form called Plotting Statement, this statement should automatically send data another form called Plotting Invoice. I created a query, table and form for both of these. They are done. All I need to do is send the data from the Plotting Statement to the Plotting invoice...

This is why I can't use DMax to determine the proper ID to use in Access 2000: aggregate function A function, such as Sum, Count, Avg, and Max, that you can use to calculate totals. In writing expressions and in programming, you can use SQL aggregate functions (including the four listed here)...

="S" & Format(Now(),"yymm") & Left(Format(Right(DMax("Statement Number","Plotting Statement","[Statement Number] Like ""S" & Format(Now(),"yymm") & "*"""),3)+1,"000") & "001",3) ok...

TonyJollans Access gives me the following error: DMax= invalid expression. I have Access 2000. Any ideas?

I created a form in MS Access for which a "unique" automatic number must be created. Here is the critirea I wish to use: SPI(year,Month,Statement-number) I was using the autonumber field in Access but that is not helping me(it only gives me a single number). I tried using the...