Queries

MARNI handbags handbags - Best High Quality MARNI handbags handbags www.luxury-gift.org
MARNI handbags handbags - Best High Quality MARNI handbags handbags www.luxury-gift.org Luxury Gift : http://www.luxury-gift.org MARNI handbags handbags : http://www.luxury-gift.org/Handbags/MARNI-handbags.html MARNI handbags handbags series contain the following items, each item is the perfect marriage of fun... 30 Jun 2008 05:32

Crosstab query - I need aditional information
Dear all in a follow up to another query I have run a crosstab query which has given me the seperation of information I needed however as always I need more! Because I am exporting data from another d/b in access there is a certain number of fields I need to have added, essentially I have run the crosstab qu... 30 Jun 2008 08:36

Using Filter by Form to create a Query and then a Report
Somebody has told me that they would like to generate their own reports in Access. This person does not know access at all, so I need to come up with a way to make this as user friendly and efficient as possible. I'm working off one master table that uses one lookup table. This basically is a list of documen... 30 Jun 2008 08:36

Expression Builder
I am working in a query that I want to put the address, city, state and zip into one field using the expression builder. When I do this the state which is coming from a lookup value from a table of states, it shows the ID # of the state rather than the two digit code it should show. How do I correct this in ... 4 Jul 2008 18:12

Ungrouping in DSUM
I created a query that works well using DSum , grouping and percentages yet i can not figure out how to target a specific period by date since it breaks up the grouping.My sql is : SELECT VendorInv.InvDesc, Sum(VendorInv.InvAmt) AS Revenue, [Revenue]/DSum("[InvAmt]","[VendorInv]") AS [Percent of Total] FROM V... 30 Jun 2008 10:39

Limiting the total time for dancing to 15 mins [900 sec]
You are very kind, thank you but you may be glad to know it isn't my homework, my headache is because I'm the teacher :-( [? - well at least that's the theory] Here is the sql thing SELECT TblBooking.SlotI1, TblBooking.Slot2, TblDancers.Surname, TblSlots.[Slot Times], Tracklist.Title, Tracklist.[Effort Ra... 29 Jun 2008 17:16

Duplicating values to empty field
I am new to SQL in queries. I can ussually get what I want with forms and the query wizard. This I cannot figure out and it seems like a SQL statement might work. I import data from a spreadsheet automatically (a click of a cmd button). I have most of the fields removed or appended to except one. I need to... 30 Jun 2008 12:44

Limiting the time in a Query
The exam site here has a Query in it which is mostly simple http://www1.edexcel.org.uk/spbs2007/d201/html/SPB201MusicULike.htm It also wants to restrict the total play time for record tracks displayed, to 15 minutes [900 sec]. Track times are in the table as seconds. I have asked various people and they generaly... 29 Jun 2008 13:11

Hate Your Job?
Do You Hate Your Job? If You Are Like Me And REALLY Hate Your Job, You Can Do What I have Done And Tell All About Your Company At A Great And CHEAP New Site Called Dont Work For These . Com http://www.dontworkforthese.com This Site Has Chat Rooms, A Joke Section, A Great Story Section Where You Can Tell All Th... 29 Jun 2008 06:02

Unmatched Query creativity needed - date field
I have a table that contains ClientId and ScheduledDueDate (each Client must submit a plan within 2 days on either side of the ScheduledDueDate), this table contains various dates for each client 14 days apart, some schedules are just 6 months long, others are as long as 2 years). Another table tracks when the... 29 Jun 2008 20:21