I have a query that executes a Table-Valued Function in SQL server. If I execute it withing Query Analyzer in SQL server, it completes in 40 seconds. If I...

I ran into something strange while doing a Make Table Query that was followed by an Append Query (from a “purchased system� table that has many field...

In MS-Access, How do I round a formula result up to the nearest fraction (Specifically the nearest half). Example: 1.3 rounds to 1.5, while 1.7 rounds up to...

I have an insert into query which is as follows; strgoaldescription = InputBox("Type new goal.") strservicetype = InputBox("This goal is for what...

I am using both Word and Access 2003. When I merge a Word Letter with Access, sometimes not all of the queries show up, in the drop down box, to link the...

I'm using the code below to display everthing after the pound sign (#) and it works for the most part, but displays the whole field for fields that don't...

Hi Guys, I can't see a table in QBE even when I have the scroll bar as far left as I possibly can. I have joineed another table to the query and I can see...

I have 4 columns/fields of dates in a table: Field A, Field B, Field C & Field D. These fields can be either filled with a date or left blank. ABCD are all...

I am trying to incorporate a pop up calender from Allen Browne. Downloaded the file (for Access 2000 and later) from the address below and unzipped it. ...

Hi, I need some help with the below IF statement for update query. I got it to move the negative sign to the front of the number, but now it is removing all...

How do I calculate elapsed time in a simple query when the starting time is before 00:00 and the end time after 00:00 ... all I'm getting at the moment is a...

I have a parameter query works as long as there are related records in the tables. My problem is I when the query results are "null" or no records exist I...

Good morning and thks for your help, 1. Have on acces Qouestion with the following CODE 02304 02305 02306 Code is the item No 2. I have folder one my pc...

using access 2003 i have the following qry SELECT DateSerial(Year(),Month(),Day()) AS , ., .Parameter, .Desc2, Count(*) AS MyCount, .Module FROM GROUP BY...

Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of...

I'm trying to figure out hoe to calculate 90 days from hire and the first of the month Example: HiredDate Insurance activated 1/3/2010 ...

I would like to delete first 3 records of the table. I know that I can set criteria to delete certain records in the table, but are there any way to set...

I have a table with daily call records. The table includes fields for: Department; Name; Date of Call; Time of Day; Call Direction; Number Dialed; Locale;...

Hi. I've built a pivot table, and get totals values displayed as expected. In this case, it's a count of records. But I also want to see values for several...

Hello, I have a combobox on a form and currently I manually select the next item for a member as needed. This is fine for 1 or 2 but typically I have to do...