Search results

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 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...

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

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...

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?