Hello Everyone, I have a crosstab query in my database that I would like to filter based upon user selections from combo boxes on an unbound form. I would...

Hi. I imported over 200 contacts into my Contacts table. The imported data's phone number format is: (###) ###-####. I want to change it to: ###-###-####. Can...

Hey Guys, I want to create tables through ADO that have the exact same fields that are in an existing table in my access 2003 .mdb file. I don't want to copy...

I am trying to use a form to get query parameter dates as is detailed in the help article "Make a query ask for input" The query does not open the date range...

Any idea why this wont sort by Lastname ? SELECT C.Restitution-NZ(P.TotalPaid,0) AS , Trim(C.Firstname & " " & C.Lastname) AS ,...

I have 4 linked tables in Access 2007. At one point in time I was having issues with what turned out to be an AutoCorrect associated file and whether or not...

Thanks in advance for your help. I posted this in a previous thread but I'm afraid that it's faded into oblivion. Two things happen when I click my preview...

What does MPV stand for?

I am using IIF statement to specify weeks as shown below. Unfortunately it does not allow me to go beyond 13 weeks. How can I overcome this...

I need to know how to find out the elapsed days between two dates. For example: Date Ordered: Date Shipped: Days to fulfill order: If the date shipped is null...

I have a subquery that ranks test scores correctly until there is a duplicate. Table1 Results What I want Score Rank ...

Hi. I created a report based on a query that uses Dsum function. This query runs well in the server where I created it. But when I ran it in a different PC,...

Hi Guys, I am converting a access application over to a SQL BE setup and am having to convert a number of update queries, I previously had a query to update...

Could someone please tell me why this is updating 0 rows when it should be updating 245 rows?? It's a text to text copy. The fields are exactly the same. ...

In the table (not the form) I am trying to get a value a user selects from another field to append to my SQL statement so it will read from teh correct...

Hi All, I've puzzled over whether I can accomplish what I want using just a query (or a set of queries), and came to the conclusion that I couldn't - but...

I just recently made a Crosstab query and I used it as an input in a make table query. The problem is, ever since that was done, anytime I try to open (even in...

I have 2 sql The First SELECT G05_LacGastIngr.CodProd, G05_LacGastIngr.CodPer, G05_LacGastIngr.CodLac, Sum(G05_LacGastIngr.Cantidad) AS Cantidad FROM...

I have a table that has 5 fields: ID, AutoNumber Ticket, Number Techs, Number Start, Date/Time Stop, Date/Time I built 3 seperate queries that output the...

Hi, I have a crosstab query which has the date as column headings. If in short date format the order is displayed correctly. The problem is I want it to also...