hello, i am at the end of my wits with allen brown's concat related function (to be found he http://allenbrowne.com/func-concat.html). it seems the only...

I can export Tables from Microsoft Access MDB files using the export option, but my users have many tables to export, and it's cumbersome for them to do...

I have other union query's that work and this one did work but now I can add 2 quer's together but not 3. I mcan add any 2 but not 5.

Seems to me this should be a lot easier than it seems to be. OK, With a table name of "table". Parameter name of "Amount" I want to to produce a running total...

Help!! I have just started to stock shelves with makeup products at local outlets. I need to keep a track of the product range within each shop. I have...

I have a query that gives me the minimum temperature for a day. On some of my days there are all zeros because of a recording malfunction. I need the query...

I have a query that contains a Date/Time field. I am currently using a between statement to get the results I am looking for. Between #7/16/2009 6:00:00 PM#...

Hello, I have a database of over 10,000 part numbers that are six characters long and should be in this format: XXXXXX; however, I noticed many records in the...

I'm trying to create a report based on an SQL statement that has me a little stumped. Let me start with the fields in my...

Hello, I have an Access Database of students who have taken an examination. I would like to automatically and randomly select one of those students who passed...

Dear Experts, I'm badly in need of your help. pls, help me. I've 2 query and finally I'd like to make the 3rd query that will only select all records except...

I need help with a query to remove the "time" refference in my date/time field. 7/13/2009 12:01:45 PM I would like to update it to this 7/13/2009 Thanks...

Hi all, I have a combo box tha I use to select an ID field. The query is simply: SELECT ID FROM MyTable WHERE ID = !!. Obviously at the beginning cboID is...

Dear Experts, I'm badly in need of your help. pls, help me. I've a table like: 1.item code, 2.Item Serial, 3.Transaction Seril,4.Transc cod . 5. Amt chr ...

Hi, Is it possible to combine these queries below to get a single one? Thanks!!! TRANSFORM Count(.) AS SELECT ., Count(.) AS , FROM GROUP BY .,

Hi Everyone, I have a table with competitor_idx, competitor.fname, competitor.sname In another table I have couples.id, couples.cplnumber, couples.maleid,...

i want to create a filing system with personal cards in which is organized by each individual name on which i could write a synopsis of successive meetings...

I am working on a query that will calculate the average sell thru for the past 5 weeks rolling, by customer and SKU. My data looks like the...

Hello, I would like to use a function that will add 1 working day to the date I have in a table. I would like to be able to take account for US holiday as...

Hello, I am new to this forum and I have this question to start me off: I am attempting to find the percentage of Males Hired and Females Hired in the...