Search results

I want to merge two queries into one ( see attachment ). I've unioned queries before but only when one field has matched. This problem needs to match 2 fields. Basically I want all the fields in NEWQRY_SUMRATES but only the fields Resource Whole and Availability from NEWQRY_DAYSBOOKED where Yr...

I am linking to another database and want to convert this field JJ3-1-2009 into a date field 03/01/09 by losing the first 2 characters. Any ideas on how to do this ?

I have designed a report to fit on A3 paper. That was fine until the database was housed on a PC with only an A4 printer. Printing is irrelevant as the database actually distributes the reports as a snapshot by e-mail, nothing is actually printed. So how come MSAccess has no intrinsic idea of...

I have 2 tables ( tbl1 and tbl2 ). One contains arrival dates and the other departure dates. Some of these dates may be the same and/or repeated. First off I want to union the data ( unionqry ) Then I want to collapse the arrivals and departures on repetitive dates to a single date i.e. merge...

Get a chart in a report, in design view, to display the actual data ? I don't want to see the default North, East, South, West data. I want to see my data, so I can format the series as I want to see it. I've read it can be done in a form, so why can't I do it in a report ?

I have a table with 3 columns as follows, keeping track of the number of jobs arriving and jobs departing from a workcentre :- JobDate RSumAR RSumDR 02/01/08 2 03/01/08 1 So, 2 jobs arrived on 02/01/08 and 1 job departed on 03/01/08. A query transforms this table to...

Like many people, I am struggling with getting a cumulative total to work in a query. I think I need to use DSUM but everything I have tried fails ( and I've been trying for hours ). I have a list of dates ( 203 records in all ) sorted in ascending order, for example, DATE COMPL 20/06/2006...

How do I query data like this :- Year Week 2006 10 2006 25 2007 10 2007 10 2007 20 2008 20 2008 20 to turn it into this :- Year Week Arrival Rate 2006 10 1 2006 25 1 2007 10 2 2007 20 1 2008 20 2...

:) Anyone tried applying this in MSAccess ?

Morning Everyone, I have a query in which are 5 categories and 5 values. I am displaying this query in a pie chart on a report. Q1 : Why, having designed one chart does the report repeat the chart 5 times ? I only want one chart on one page, not 5 copies of the same chart over 5 pages. It...

Can I specify which tab is in view when my form opens ? At the moment the tab I want users to see is not the one MSAccess chooses to show. Can I use something like "me.pgGeneral.PageIndex=5". This does not work by the way to specify the tab that is in view when the form opens. I don't want to...

Can a form be ordered by more than one field ? I have a form whos 'Order By' field is set to 'NEW_tblUsers.ROLE', this works fine but only sorts one column of data. Is there a way to cascade the sort order over more than one field ?

My database has just started doing some very strange things - like ignoring its 'vba' code, but only occasionally. It's got me a bit stumped. The database is supposed to update a calculated value as users enter some data into various fields. Opening the database from new, the calculation is...

What I want to do is 'click' a command button on a form and have a pdf file come up as an example of how the form should be completed. I have the form, the command button, and an empty vba routine. I have a table with the pdf file in it ( OLE object ). What I'm missing is the piece of code...

Does anyone elses form display the footer twice, like this :- http://photo.ringo.com/262/262000018O183603375.jpg The form detail section contains a tab control. For some reason if I open the form from say a main menu, it double displays the form footer. It seems to do the same thing initially...

You know how normally in design view there would be a table at the bottom of the screen where you can drag your fields from the view above. Well, I have a query where this table view has disappeared ? I can edit the query in SQL view, the query works, just the table view is missing. Ever...

The record source for a form can either be a table or a query right ? So in theory I should be able to design a form that populates more than one table at once, the common link being the query. So how come when I design a query to bring together 2 tables am I prevented from modifying the data...

When I move between forms they normally overlay one another so the current form fills the screen and any forms behind can not be seen. That was until one of my forms contained some tabs. Now only that part of the screen occupied by the tab is overlayed - makes for some very confusing images...

I've got part way through designing a form and have now decided that it would look better if I used a tab control to display the data - it's a bit busy all on one page. Can I retrospectively add controls to a tab ? If I create new controls using the toolbox these automatically attach...

I have a report that contains a cumulative bar chart, based upon the results of a crosstab query. It ought to be a one page report containing one chart. However, when printing this report it appears to print multiple copies of the same page. Having redesigned the report to incorporate "Page X...