I frequently need to change the source table in my queries. Eg. 10-1-05 to 10-15-05 to 11-1-05. I open up the previous query, then add the new table, delete...

I need to write a query that would be based off of what kind of training someone has. My information is stored as 1's & 2's as it is entered from a data entry...

How can I prompt for the same result in multiple fields. This will have to include a partial ie. Like ("*" & & "*"). I can get this pull up the proper...

I have a form that I use to input criteria for a query. The inputs are in the form of comboboxes. It works great. Of course when I enter the criteria and hit...

Dear Jon: If is is the case that there is no row, or combination of rows, that uniquely identify the rows in a table, then the only way would be to use...

I am trying to select records based on the value of a combo box column. I am using it as criteria in a query and referring to it as...

Please help! I have a database that consists of physicians and their medical specialties. They can have as many as 3 (Spec1, Spec2, Spec3). I need to link...

I just had MS Office 2003 installed on my computer at work. I previously had Office 2000. I am always copying query results and pasting them into Excel. This...

I cannot make a secure connection with my bank & often cannot access google. Can I download to fix this problem jan

I am trying to create a Diff (or Delta) query that will return only data that is different between two tables. All the fields are identical between the two...

I followed Microsoft's instructions for creating a ranking query at: http://support.microsoft.com/default.aspx?scid=kb;en-us;208946 but when I run the...

I have an sql statment that returns a memo field as part of the result, proble is it isn't returning the full string in the memo field? And yet i have other...

hello there is there any way to force a query or a report to give the first 10 for example records of the whole results? thanks

I am using a function (fClientName) in the criteria of my query. Is there a way to show all records if this function is "" or null? eg: If nothing is...

Goodmorning, In my query I have a Bill date, I would like to know how I can have all bills than 90 days as well as all bills than 90 days Thanks!

I have a date field and a time field which I need to merge together to be used in a date/time comparison - any ideas how?

I have to filter records from units of Kg, L, 5L, 5Kg, 10L, 10Kg, 200L, 200Kg etc. But the numerical parts will be good enough, and shorten the list box. How...

Hello I have a table of staff who can perfrom a particular role, however some people can perform many roles. I would like a query that only shows the persons...

I have 2 dates/times which I need to take one from the other, however if between these 2 dates there is a weekend I need to remove 48 hrs. How can I check if...

Hi, MyTable is as...