Hello, I have a make table query that is the last in a string of several queries, which it uses to create the table. When trying to run it a second time I get...

If you run this and the Birthdate is 9/1 I come up with -1 for the result. Wondering why this would not be zero or...

I have this query I'd lide to export to Excel and group related monthly data allowing a space between the grouped monthly data. Is this possible? The data...

I have table that has a field that can be empty or contain a string. I need a query pull out on entries that have empty fields how can I do this thanks

Hi, I have a number of queries from which I want to export to excel. I can export a query to an invidual workbook. But how do I export another query to form...

Hi, I would need your help to set the query for searching the latest date of any five dates. example: Field1 Field2 ***** ****** Date1 -...

I need to display on the same A4 page more pages of the same report, and, after the A4 paper sheet is over to continue on the next A4 paper. Can I insert it...

I need to display on the same A4 paper sheet more pages of the same report, and, after the A4 paper sheet is over to continue on the next A4 paper. Can I...

I have a field that contains sequential numbers. The user want to run various reports on different ranges, more specifically like this "3280 And 3314"...

I need to display on the same A4 page more pages of the same report, and, after the A4 paper sheet is over to continue on the next A4 paper. Can I insert it...

Michael, Sorry to impose but I ran across the same problem and can't find anything in the MS KB. I'm running an update query in Access 2003 under Win XP Pro. ...

Here is the situation I am stuck in. I have 3 queries that pull data off of 3 seperate tables. I then combine them all into one. The problem is that there...

I have a query that I am trying to concatenate more than 2 fields. This new field is set up as a parameter that asks the user for a value that equals the...

Hi, apologies for the previous accidental post. I currently have a table with the following values ID Value GroupValue 1 ...

Using an Access 2000 mdb with linked SQL tables. I am opening a report (based on a query)...after the report closes I am running a simple macro to open...

Excel has a function named YearFrac() which allows you to specify where a year calculation uses 365 or 360 days. I would like to use this in Access, however,...

Hi, I have a table with records each with a certain dates, I would like to make a report that gives me dates that are one year ahead from the dates in the...

I have a table where one field is date/time format. Only the time value has been entered. When I enter query criteria such as 9:01 PM Access 2000 converts the...

I am using a privot chart where the underlying query groups by the week.The problem is the weeks are not sorted correctly (1, 10, 11,...2, 20, 21...). Any...

I am going through a "teach yourself SQL in 21 days" and doing the examples in Access. They are using Personal Oracle in the book, so I am noting...