Search:

Type: Posts; User: accessnovice; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    9
    Views
    660

    Hi Patt, Firstly Ive amended the below to...

    Hi Patt,

    Firstly Ive amended the below to create table like you suggested, it certainly does speed up running the subsequent querys having them based off it. Two questions I have, Ive just been...
  2. Replies
    9
    Views
    660

    Hi Patt, Firstly thanks for your tips really...

    Hi Patt,

    Firstly thanks for your tips really appreciated. In response to each of your points

    1) The excel sheet is used in the queries. I'd be happy to put this into an access table but is...
  3. Replies
    9
    Views
    660

    Access - Crosstab Performance

    Hi,
    I have finally been converted to Access as the data set Iím using grew to a ridiculous size. I am analysing one yearsí worth of data and the database itself has grown to be quite large at just...
  4. Replies
    1
    Views
    256

    Access: Grouped Sums

    Hi,

    First post but here it goes.

    I have a data set as per the below which shows a unit (denoted by unidad) volumes and prices. This is broken down into hours however for one hour there can be...
Results 1 to 4 of 4