The following phrase is in the criteria of a field; Between criteriachange(1,) And DateAdd("d",daynumber(),criteriachange(1,)) The functions are as...

I'm creating a SQL passthrough query to run a stored proc from code. When I do this after creating the query, I'm getting prompted for a Data source any time...

I have created a crosstab query based on just one linked table using the Access wizard and when I finished I get the erro "The recorset is not updateable",...

I have code in a module as follows: strSql = "Update tbl_admin Set tbl_admin.email_LastDateSent = " & Now DoCmd.RunSQL strSql The field email_LastDateSent...

Any suggestions on making this formula work? IIf(CITY like “Phila*” And BALANCE10,000,”Phila 10,000”,IIf(CITY like “Phila*” And BALANCE 10,000,”Phila ...

I have a crosstab query and would like to count parent and child tables like following: Select tblParent.Parent, count(tblParent.PrentID),...

When you press Control Apostrophe the previous record's data is entered into the field on a form. Is there a code that I can enter On Load property of the...

I have a query for a Quarterly Report which separates and sums the Month of Quarters (ie. QTR1 = Jan, Feb, Mar. However the Mod 3 utilized in Northwind...

Is there a way to 1) Assign events when adding in data thru an update query for example if you append a bunch of data into a table could you then do some...

How do I set up a query to add groups of variables? Say, for instance, I want to add the variables FO and FE and OC and CT and TB. Then I want to add FN...

hi here is what I need. I need to run a query that picks the data i specify from this week's Monday back to and including the previous week's Monday. i need it...

I just converted several my Access Databases to Access 2007 and I am getting the following error message on 2 of them: "is not a valid name. Make sure that...

Sorry to repost this, but I was not sure I would get help with this again and it would get lost in the list. As suggested, I created a table called...

I am trying to work out the number of working days between two dates. I am using the DateDiff function, but this appears to count weekends. Giving me fault...

I have a query and would like to have optional parameters for the users. Because I have more than 10 optional paramters which MS Access gives me query too...

I need some help from you the experts: I am having an issue with my access query... I have a parameter asking for a start and end date (see below) when I...

I have in my database a field called Hire Date. How do I run a query to select all those with dates that are the first of any month of any year?

I have a form that needs to create a unique ID upon entry. Like a new Sales Order Number for a new sale. What I want to do is the run a query that return the...

What is the best way to accomplish this in a query. I have records where I want to return only records where one returned value only is matched with one...

Hi everybody. I am having a problem with a query that I am working on. I have a table containing customer names, trade dates, and dollar amounts. Customers...