Search results

I apologize I meant to say what do the &'s mean. Also how does access know to look through the all the values in a given field versus the value in the record. Lastly if I wanted to count how many times a1=b1 is that a dCount function or do I sum a query?

The two #'s around the &'s DCount("[Visiting_Time_N_Date]","[qry_Account_Pick_Ups_Order_List]","[Visiting_Time_N_Date] =#" & [Visiting_Time_N_Date] & "#") What do they represent?

How would you Dcount date and times that are less than records date and time? Right now the format is General Date and the field is date and time Expr1: DCount("[Visiting_Time_N_Date] ","[qry_Account_Pick_Ups_Order_List]","#[Visiting_Time_N_Date]# > #[Visiting_Time_N_Date]#")

How do you use DCount when you want to count how many values in the Field are greater than the record's Date and time Expr1: Dcount("[Visiting_Time_N_Date] ","[qry_Account_Pick_Ups_Order_List]","[Visiting_Time_N_Date] >= [Visiting_Time_N_Date]") P.S. is there a reference for on how to use the...

Ahh that's a clearer way of looking at it and now I feel kinda silly for asking that. TYVM

After taking a second look, I think this is a close scenario to a shipping address scenario, you have a client with a billing address and then need to set up a database for shipping addresses. Correct?

Quick note: This is the first database I'm setting up, no one else is doing it and I thought hey I'm a smart guy I can do this (btw everything looks easier on youtube). I greatly appreciate the community's help that I have been receiving. Project: I'm setting up a database for a food pantry...

I'm not any good with access but I would have used a rather long iif function. But a question to the people who suggested creating additional tables I'm creating a simple database that counts how many times a unique client visited a store and when. Wondering which option is better Option A...

Perfect thanks a bunch, you deserve an award or something

Sorry I'm a total noob and just started using access to help a charity. (I'm an engineer who's above average with Excel so I thought I could help them with an access database) I'm a lil confused by what you said Am I correct in believing that only the criteria part of the expression is wrong?

So now I have rewritten in Query Field Frequency Check: DCount("Layer 2","Repeat Address","Layer 2 ='[Layer 2]'") The error I have is: Syntax error (missing operator) in query expression 'Count(Layer2)'. And then when I close that another message box appears saying: Uknown

Just had a HTTP Error 503. The service is unavailable.

I'm trying to use dcount() as countif() from excel and I'm not having much luck. What I want to do is to report how many times a record's respective Layer 2 occurs throughout the database in a query. For the Frequency Column the formula I have is: Freq: dcount("*", "Repeat Address", "Layer 2"...