Search results

On the face of it a simple question. I'm setting up a very simple table with a primary key field consisting of a year and month. Attached is an image of the Design View. Also attached is an image of the response when entering data in Datasheet View. I'd be grateful for a lead as to where I'm...

Greetings I'm sure this subject must have been addressed in the past but I would be grateful for some thoughts on it. On the attached .pdf file diagram I have shown :- 1. a typical "top-down" tree structure (similar to a Bill of Materials but without the frills of including the number of a...

Greetings I cannot find a Function in EXCEL to carry out a specific required task and if there isn't one I'm surprised it hasn't been supplied as standard. I have a spreadsheet in which one of the columns contains cells that have been formatted differently, for example some are 'text', some...

I wish to create a very simple query but cannot find the correct syntax mentioned in any documentation. The WHERE clause needs to have the effect of ignoring certain records in a table ie WHERE fieldvalue <> 12 AND fieldvalue <> 23 AND fieldvalue <> 37 etc etc for up to an unspecified number...

Hi I'm trying to import data from an Excel spreadsheet into an empty table using the Import Wizard (File/Get External Data/Import). All's well until I'm presented with the window that tells me that I can "store" my data either in a new or existing table. However the radio button and Existing...

Hi there I'm sure that this must be easy, so go gently on an old codger! I have a query for which I wish to add another field containing a running total of the number of records produced by the query (after all sorting etc.). In other words, if my query produces n records, that new field would...

I have a form F_EXTRACT whose record source is a table named T_EXTRACT. The form contains 2 controls, a Text Box named Surname and a Combo Box named Member_ID. Column 1 of the combo box is bound to Member_ID (in the T_EXTRACT table). Column Count is set to 3. In Row Source, I have the following...

Hi everyone - happy new year from an older first-timer I'm not sure whether this should have been posted under Forms or Macros as my problem impinges on both so I've posted it here. I've created a macro which successfully performs the following actions :- 1.Runs a Delete Query to clear data...