sumhungl0
Last Activity: Feb 26 '08, 08:05 PM
Joined: Jul 23 '07
Location:
-
i need to think back to what data i need from this db and figure the best way to setup my tables. i dont know how i can do my meter readings table having months keep going. i would have a new column for every month. or i could have a column for all 70 something consumers. i cant figure out which would be best. any advise on this? -
i did get the date format yyyymm to work by just typing yyyymm into the format box of column readmonth in my table called "monthly meter readings". that part worked perfect like you said. date shows up as 200701.Leave a comment:
-
ares
i dont think im getting the format date thingy right. says "data type mismatch in criteria expression". this is what i have in criteria under readmonth:
know what that means?Code:Between IIf(Format(Date(),"mm")="01",Format(Date(),"yyyymm")-89,Format(Date(),"yyyymm")-1) And Format(Date(),"yyyymm")
boxcar
that would work perfect. but...Leave a comment:
-
this is very interesting. i read through everything and ill give it a shot come brake time. thank you very much for the help and teaching me a bit. ill give it a shot shortly and ill post again. thanks for your help....Leave a comment:
-
ok as for the date question....
i dont care what format it is i can change it to whatever you suggest, because all i need for the date is that it happens once monthly. we have a guy who goes around my small town and takes water meter readings. the data is input into a excell spreadsheet right now. it only needs to be input monthly, so i dont care what format it is in the end. i just thought it would be better to use the full date format....Leave a comment:
-
well im gonna try a few things. but the meter reading is done monthly. so i only have one meter reading per consumer per month. so thats why i thought i would make a table for each consumer, what do you think? my date column is in the format of mmddyyy just for ease, but the month is all im looking for. i work with an older lady on this part in which her only job on this deal is to input the monthly meter readings for the consumers. we do not...Leave a comment:
-
maybe i need a table for each consumer?Leave a comment:
-
date difference calculation
im not sure how to even start this. im using access 03 to build a db to store my water district meter readings. i have 2 tables so far, 1 consumer info and 2 monthly meter readings. i need a query to bring up the difference between current month meter reading and last months meter reading for each consumer. thats where im stuck because ive never used access to do much of anything at all. so i figured id ask, and here i am. table 1 consumer...
No activity results to display
Leave a comment: