Search results

thanks for reply. The rates for each subscription year (there are three types) are held in one table. Payments received are held in two tables - cash and cheques paid in on pay in slips, and bank credits paid directly (the later two tables I join in a Union query). So I need to run a query to...

Hi folks. I run a membership database where I use a bunch of nested queries to show who has paid/not paid their subs in a given year, and also who has overpaid and underpaid. I then set my membership forms recordsource to be the result of these queries. This is good for filtering the data, but...

And I should have included that jobno and taskrecid are combined as a unique index in t-jobtasks.

Hi DBGuy. they are Access tables. IT have never shown any interest in helping me out with SQL server ;-( I'm showing 3 tables in 2 backends. Project be t_project JobNo-PK t_projecttasks TaskRecID-PK JobNo-FK Timesheet be...

Hi folks. I have three backends with multiple front ends which have all been playing nicely with each other for well over 10 years now and regularly have 40 users over a network. Relationships are set in each back end and the structure has been fine. However a change in a table structure and...

Thanks, yes I've done the union and cross tabbed that. cheers

thanks - so its using 'First' in the cross tab - so I now have: TRANSFORM First(T_Metrics.Metric) AS FirstOfMetric SELECT T_Metrics.FindID FROM T_Metrics GROUP BY T_Metrics.FindID PIVOT T_Metrics.MetricDescription; I just need to compile the different tables in a query and then run the...

.... Should have explained t_contexts and t_sites etc not resolved yet and still have elements of original design. It's how to get the data out of t_findregister, t_metrics and t_attributes that is my concern. I always design with independent autonumber PK and separate unique index, but...

OK thanks, zip attached

How do I get through cross tabs needing to group values with aggregate functions whereas I want to display the actual value - not a count, an average etc. I'd rather not post the data as it represents several years research by the student I'm helping. If ultimately I need to, I'll pair it down...

thanks vMajp, yes an EAV model is exactly what I have done - very streamlined, efficient and flexible. I'll check out the wiki, previous threads and cross tab, but I wonder if I need to make tables with some vba./sql to define fields depending on the content of the Eav tables. Thanks again.

.... because some attributes are text, eg round, square, clay, stone, and some are numeric, eg 11 mm., 55 g etc.

Hi folks it's been a while since I last visited but I've not been doing much DB development in the past few years. I've recently helped a PhD student by redesigning an access database setup for recording different types of artefacts. The database consisted of a central table holding artefact...

Thanks Static, that's just the pointer I needed. I know my knowledge is perilously light on some fundamentals.

re Apologies. The vba is manipulating a number of records which comprises a recordset that are listed on a subform, along with some controls on that subform. I am sending those records to another table and in the process doing some simple maths: the hours in the host database are daily worked...

Hi folks, the following sql works OK for me as part of a larger SQL statement, but I would like to more efficiently reference the Job_Nos from a table in which these particular job_nos are listed. What would my statement be, to select the Job_nos in the IIf, from a table...

To get what I needed, to suppress the double negative symbol but to show a negative if the hours = 0 and minutes = < 0 I ended up with this: Option Compare Database Function Calc_HrsMins(TotalMinutes As Variant) As Variant On Error GoTo calc_hrsmins_error Dim varHours, varMinutes varHours =...

Thanks very much for your reply, I will give this a try tonight. Matt

Hello folks. I am using a little explanation posted by Allen Browne (here http://allenbrowne.com/casu-13.html on expressing minutes as hours and minutes, and I have written this little function: Function Calc_HrsMins(TotalMinutes As Variant) As Variant On Error GoTo calc_hrsmins_error Dim...

You got it, sorted. Thanks a lot!