Recent content by Ahrek

It is working. Tunred out, for some reason Access was moving the validation rule. /shrug I am trying somethign similar now, that I am having trouble with. This table has "startdate" and "finaldate." I want to have a validation rule that finaldate >= startdate. It doesn't like when I include...

I just started working with validation rules, and I know nothing about how to use them. I have a table where one of the entries is Gender. The entry can only be "M" or "F." I do not want Access to allow any entry that is not one of those two letters. I tried using Like "M" or "F" as the...

I only need the max amount we had on-site for the year. I am fine with writing a module to do the function. I need to tell it to give me the number for every change of date and/or change in product

Not really, I am just getting started in VB. Working with some VB.Net

Sounds like a good idea, but I have no idea how to do it.

I am trying to run a back inventory query and I am hoping someone can help. I know the amount on-site for every product 1/1/03. and I know the date and amount of outgoings and the date and amount of incomings. I am trying to run a report that will tell me the maximum amount on site at any...

Well, all those exprs give me #ERROR. and now the expr that was working that I have listed above is also giving me #ERROR. Anyone have Bill Gates's address and a gun?

When I read, what you said try, I thought it would work (it was the onbe thing I had not yet tried), but it still gave me "#ERROR" ;( I hate having to leave the date a constant that must be changed.

what can you enter in a numeric record that equals infinity?

Ok, I found somethign that works, but not what I want... TSales: DSum("[sale]","44sales","[prodfil2_1].[pname1]='" & [prodfil2_1].[pname1] & "' And [st]='" & [st] & "' and [bldate]>=#1/1/03#") Gives me the numbers I am looking for, but I want to be able to run this report again next year...

The date is not literal. [begdate] is a prompted/entered date when the query is run.

What is wrong with this expression? TSales: DSum("[sale]","44sales","[prodfil2_1].[pname1]='" & [prodfil2_1].[pname1] & "' and [ordhfile].[BLdate]>='" & [begdate] & "'") I need to find the total sales for certain products in each state starting with a paticulat date. The expression works fine...

thanks, but i am writing an aggregate function: dsum("[meas]*[qtord]", "cpfile2", "[pname1]='"&[pname1]&'"") the problem is that multiple of the tables in the query have a record named "pname1". I need to designate which "pname 1" I need. It involves a "!" and the correct order and bracketing.

This is a simple commande that I forget every time I need to use it. I am running a query in which more than one table has the same name for a set of records. How do I designate which table to pull the data from in an expression?